{ "currentVersion": 10.51, "id": 14, "name": "BROWNFIELD_SITES", "type": "Feature Layer", "description": "This layer was created with the query: SELECT AGENCY_INTEREST.MASTER_AI_ID AS AGENCY_INTEREST,AGENCY_INTEREST_ALT.ALTERNATE_AI_NAME AS SITE_NAME,AGENCY_INTEREST_ADDRESS.PHYSICAL_ADDRESS_LINE_1 AS SITE_PHYSICAL_ADDRESS,AGENCY_INTEREST_ADDRESS.PHYSICAL_ADDRESS_MUNICIPALITY AS CITY,AGENCY_INTEREST_ADDRESS.PHYSICAL_ADDRESS_STATE_CODE AS STATE,AGENCY_INTEREST_ADDRESS.PHYSICAL_ADDRESS_ZIP AS ZIP_CODE,MTB_PARISH_COUNTY.PARISH_OR_COUNTY_DESC AS PARISH,SUBJ_ITEM_LOCATION.X_COORD_STANDARD_VALUE AS LONGITUDE,SUBJ_ITEM_LOCATION.Y_COORD_STANDARD_VALUE AS LATITUDE FROM AGENCY_INTEREST_ALT INNER JOIN AGENCY_INTEREST ON AGENCY_INTEREST_ALT.MASTER_AI_ID = AGENCY_INTEREST.MASTER_AI_ID AND AGENCY_INTEREST.INT_DOC_ID = 0 INNER JOIN AGENCY_INTEREST_ADDRESS ON AGENCY_INTEREST_ALT.MASTER_AI_ID = AGENCY_INTEREST_ADDRESS.MASTER_AI_ID AND AGENCY_INTEREST_ADDRESS.INT_DOC_ID = 0 INNER JOIN SUBJECT_ITEMON AGENCY_INTEREST_ALT.MASTER_AI_ID = SUBJECT_ITEM.MASTER_AI_ID AND SUBJECT_ITEM.INT_DOC_ID = 0 AND SUBJECT_ITEM.SUBJECT_ITEM_CATEGORY_CODE = 'AI' INNER JOIN SUBJ_ITEM_LOC_GOV_WITHIN ON SUBJECT_ITEM.MASTER_AI_ID = SUBJ_ITEM_LOC_GOV_WITHIN.MASTER_AI_ID AND SUBJ_ITEM_LOC_GOV_WITHIN.INT_DOC_ID =0 AND SUBJECT_ITEM.SUBJECT_ITEM_CATEGORY_CODE = SUBJ_ITEM_LOC_GOV_WITHIN.SUBJECT_ITEM_CATEGORY_CODEINNER JOIN MTB_PARISH_COUNTY ON MTB_PARISH_COUNTY.PARISH_OR_COUNTY_CODE = SUBJ_ITEM_LOC_GOV_WITHIN.PARISH_OR_COUNTY_CODE LEFT OUTER JOIN SUBJ_ITEM_LOCATION ON SUBJ_ITEM_LOCATION.MASTER_AI_ID = SUBJECT_ITEM.MASTER_AI_ID AND SUBJ_ITEM_LOCATION.INT_DOC_ID = 0 AND SUBJ_ITEM_LOCATION.SUBJECT_ITEM_ID = SUBJECT_ITEM.SUBJECT_ITEM_ID WHERE AGENCY_INTEREST_ALT.USER_GROUP_ID = '098' AND AGENCY_INTEREST_ALT.END_DATE IS NULL AND AGENCY_INTEREST_ALT.INT_DOC_ID = 0 ORDER BY AGENCY_INTEREST_ALT.MASTER_AI_ID; The field MV_SUBJ_ITEM_LOC_REFRESH_DATE contains the time-stamp of when the snapshot of this data was taken from the TEMPO database. Previously, TEMPO layers in SDE were created using the Latitude and Longitude Degrees, Minutes, Seconds and Tenths fields which were then transformed and stored as UTM coordinates. The new TEMPO layers are created using the Decimal Degree fields (X_COORD_STANDARD_VALUE, Y_COORD_STANDARD_VALUE) and stored in the Geographic Coordinate System (GCS_North_American_1983).", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 26915, "latestWkid": 26915 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 130, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 427789.63769999985, "ymin": 3276009.2277000006, "xmax": 791365.8722000001, "ymax": 3647040.0209999997, "spatialReference": { "wkid": 26915, "latestWkid": 26915 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "SITE_NAME", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "AGENCY_INTEREST", "type": "esriFieldTypeDouble", "alias": "AGENCY_INTEREST", "domain": null }, { "name": "SITE_NAME", "type": "esriFieldTypeString", "alias": "SITE_NAME", "length": 100, "domain": null }, { "name": "SITE_PHYSICAL_ADDRESS", "type": "esriFieldTypeString", "alias": "SITE_PHYSICAL_ADDRESS", "length": 100, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 100, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 2, "domain": null }, { "name": "ZIP_CODE", "type": "esriFieldTypeString", "alias": "ZIP_CODE", "length": 9, "domain": null }, { "name": "PARISH", "type": "esriFieldTypeString", "alias": "PARISH", "length": 30, "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "REFRESH_DATE", "type": "esriFieldTypeDate", "alias": "REFRESH_DATE", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "indexes": [ { "name": "R4282_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S3104_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null }