Name: Development Parcels
Display Field: PROJECT_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: Retrieved rows from the TRAKiT database and select from LR_PARCELSELECTCASE WHEN STATUS = ‘SEE PARENT PROJECT’ THEN PARENT_PROJECT_NOELSE PROJECT_NOEND AS PROJECT_NUMBER,[PARENT_PROJECT_NO],[PROJECT_NO],[PROJECT_NAME],[PROJECTTYPE],[STATUS],[APPLICANT_NAME],[SITE_APN],[SITE_ADDR],[SITE_CITY],[SITE_STATE],[SITE_ZIP],[APPLIED],[APPROVED],[CLOSED]FROM [TRAKIT_prod].[dbo].[PROJECT_MAIN]WHERE STATUS IN (‘COMPLETE’,’ON HOLD',‘PENDING ASSIGNMENT’,’PENDING STATUS LTR', ‘SEE PARENT PROJECT’)AND APPLIED != ‘2012-01-01 00:00:00.000’
Service Item Id: 747253ccad224b9281a02a73d99cf02a
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Supports Datum Transformation: true
Extent:
XMin: 6262980.305936724
YMin: 1976864.0219777226
XMax: 6301630.999960631
YMax: 2013496.9998927265
Spatial Reference: 102646
(2230)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: N/A
UniqueValueInfos:
-
Value: COMPLETE
Label: COMPLETE
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [163, 83, 142, 255]
Outline:
Style: esriSLSSolid
Color: [214, 157, 188, 255]
Width: 2
-
Value: ON HOLD
Label: ON HOLD
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [255, 255, 0, 255]
Outline:
Style: esriSLSSolid
Color: [230, 230, 0, 255]
Width: 2
-
Value: PENDING ASSIGNMENT
Label: PENDING ASSIGNMENT
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [90, 218, 232, 255]
Outline:
Style: esriSLSSolid
Color: [190, 232, 255, 255]
Width: 2
-
Value: PENDING STATUS LTR
Label: PENDING STATUS LTR
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [250, 172, 107, 255]
Outline:
Style: esriSLSSolid
Color: [245, 202, 122, 255]
Width: 2
-
Value: SEE PARENT PROJECT
Label: SEE PARENT PROJECT
Description: N/A
Symbol:
Style: esriSFSSolid
Color: [84, 82, 227, 255]
Outline:
Style: esriSLSSolid
Color: [158, 170, 215, 255]
Width: 2
Transparency: 20
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
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: true
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID_1
(
type: esriFieldTypeOID, alias: OBJECTID_1
)
-
APN
(
type: esriFieldTypeString, alias: APN, length: 10
)
-
OBJECTID
(
type: esriFieldTypeInteger, alias: OBJECTID
)
-
PROJECT_NUMBER
(
type: esriFieldTypeString, alias: PROJECT_NUMBER, length: 1073741822
)
-
PARENT_PROJECT_NO
(
type: esriFieldTypeString, alias: PARENT_PROJECT_NO, length: 1073741822
)
-
PROJECT_NO
(
type: esriFieldTypeString, alias: PROJECT_NO, length: 1073741822
)
-
PROJECT_NAME
(
type: esriFieldTypeString, alias: PROJECT_NAME, length: 1073741822
)
-
PROJECTTYPE
(
type: esriFieldTypeString, alias: PROJECTTYPE, length: 1073741822
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 1073741822
)
-
APPLICANT_NAME
(
type: esriFieldTypeString, alias: APPLICANT_NAME, length: 1073741822
)
-
SITE_APN
(
type: esriFieldTypeString, alias: SITE_APN, length: 10
)
-
SITE_ADDR
(
type: esriFieldTypeString, alias: SITE_ADDR, length: 1073741822
)
-
SITE_CITY
(
type: esriFieldTypeString, alias: SITE_CITY, length: 1073741822
)
-
SITE_STATE
(
type: esriFieldTypeString, alias: SITE_STATE, length: 1073741822
)
-
SITE_ZIP
(
type: esriFieldTypeInteger, alias: SITE_ZIP
)
-
APPLIED
(
type: esriFieldTypeDate, alias: APPLIED, length: 8
)
-
APPROVED
(
type: esriFieldTypeDate, alias: APPROVED, length: 8
)
-
CLOSED
(
type: esriFieldTypeDate, alias: CLOSED, length: 8
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
Shape.STArea()
(
type: esriFieldTypeDouble, alias: Shape.STArea()
)
-
Shape.STLength()
(
type: esriFieldTypeDouble, alias: Shape.STLength()
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata