Name: BROWNFIELD_SITES

Display Field: SITE_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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).

Definition Expression: N/A

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 427789.63769999985
YMin: 3276009.2277000006
XMax: 791365.8722000001
YMax: 3647040.0209999997
Spatial Reference: 26915  (26915)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 130, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• AGENCY_INTEREST ( type: esriFieldTypeDouble , alias: AGENCY_INTEREST )
• SITE_NAME ( type: esriFieldTypeString , alias: SITE_NAME , length: 100 )
• SITE_PHYSICAL_ADDRESS ( type: esriFieldTypeString , alias: SITE_PHYSICAL_ADDRESS , length: 100 )
• CITY ( type: esriFieldTypeString , alias: CITY , length: 100 )
• STATE ( type: esriFieldTypeString , alias: STATE , length: 2 )
• ZIP_CODE ( type: esriFieldTypeString , alias: ZIP_CODE , length: 9 )
• PARISH ( type: esriFieldTypeString , alias: PARISH , length: 30 )
• LONGITUDE ( type: esriFieldTypeDouble , alias: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble , alias: LATITUDE )
• REFRESH_DATE ( type: esriFieldTypeDate , alias: REFRESH_DATE , length: 8 )
• Shape ( type: esriFieldTypeGeometry , alias: Shape )

Supported Operations:   Query   Generate Renderer   Return Updates