20230503 09502800 1.0 TRUE CreateFeatureclass "C:\Users\abloomfield\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\DSEC\DSEC_28Dec2022\DSEC_28Dec2022.gdb" Public_School_Characteristics_202021_XYTableToPoint Point Public_School_Characteristics_2020-21.csv No No "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" # 0 0 0 # XYTableToPoint Public_School_Characteristics_2020-21.csv "C:\Users\abloomfield\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\DSEC\DSEC_28Dec2022\DSEC_28Dec2022.gdb\Public_School_Characteristics_202021_XYTableToPoint" X Y # "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\abloomfield\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\DSEC\DSEC_28Dec2022\DSEC_28Dec2022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Public_School_Characteristics_202021_XYTableToPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Atleast75percentFARMS</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Public_School_Characteristics_202021_XYTableToPoint Atleast75percentFARMS Reclass(!FRLPerc!) "Python 3" "def Reclass(FRLPerc): if FRLPerc >=.75: return 1 return 0" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint Atleast75percentFARMS Reclass(!FRLPerc!) "Python 3" "def Reclass(FRLPerc): if FRLPerc >=.75: return 1 else: return 0" Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\abloomfield\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\DSEC\DSEC_28Dec2022\DSEC_28Dec2022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Public_School_Characteristics_202021_XYTableToPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>School_Level2</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\abloomfield\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\DSEC\DSEC_28Dec2022\DSEC_28Dec2022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Public_School_Characteristics_202021_XYTableToPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>School_Level2</field_name></DeleteField></workflow><workflow><AddField><field_name>School_level_string</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Public_School_Characteristics_202021_XYTableToPoint School_level_string Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Not Applicable": return "Other" elif SCHOOL_LEVEL=="Not Reported": return "Other" elif SCHOOL_LEVEL=="Ungraded": return "Other" elif SCHOOL_LEVEL=="Secondary": return "High" return "SCHOOL_LEVEL"" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint STABR Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Not Applicable": return "Other" elif SCHOOL_LEVEL=="Not Reported": return "Other" elif SCHOOL_LEVEL=="Ungraded": return "Other" elif SCHOOL_LEVEL=="Secondary": return "High" return "SCHOOL_LEVEL"" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint STABR Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Not Applicable": return "Other" elif SCHOOL_LEVEL=="Not Reported": return "Other" elif SCHOOL_LEVEL=="Ungraded": return "Other" elif SCHOOL_LEVEL=="Secondary": return "High" else: return "SCHOOL_LEVEL"" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint STABR Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Not Applicable": return "Other" elif SCHOOL_LEVEL=="Not Reported": return "Other" elif SCHOOL_LEVEL=="Ungraded": return "Other" elif SCHOOL_LEVEL=="Secondary": return "High" else: return "SCHOOL_LEVEL"" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint STABR Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Not Applicable": return "Other" elif SCHOOL_LEVEL=="Not Reported": return "Other" elif SCHOOL_LEVEL=="Ungraded": return "Other" elif SCHOOL_LEVEL=="Secondary": return "High" else: return SCHOOL_LEVEL" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint STABR Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Not Applicable": return "Other" elif SCHOOL_LEVEL=="Not Reported": return "Other" elif SCHOOL_LEVEL=="Ungraded": return "Other" elif SCHOOL_LEVEL=="Secondary": return "High" else: return SCHOOL_LEVEL" Text NO_ENFORCE_DOMAINS CalculateField Public_School_Characteristics_202021_XYTableToPoint STABR Reclass(!SCHOOL_LEVEL!) "Python 3" "def Reclass(SCHOOL_LEVEL): if SCHOOL_LEVEL=="Secondary": return "High" else: return SCHOOL_LEVEL" Text NO_ENFORCE_DOMAINS PublicSchools_0_XYTableToPoint /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3Ciii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigD//2Q==