Name: Received Calls From Yesterday
Display Field: CREATENAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: This point feature class is created from an Oracle table (CIRM_SR_REQUESTS) containing all of the county's 311 requests.A daily job, J790510, runs and queries all records where status (SRStatus) is Open (O) and Closed (C) from the PCIRMDW database, but only those cases closed within the last 6 months. A CIRM311 user was created for this job to run on PSDE6.
Copyright Text: Data Source: Records are retrieved from the PCIRMDW database, CIRM_SR_REQUESTS table.
Database Contact Person: Syed Abbas
Department Contact Person: Thomas Hilpold
Default Visibility: true
MaxRecordCount: 6000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 750000
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: 764476.1623235941
YMin: 378017.61703868955
XMax: 945692.621084176
YMax: 597352.4798772708
Spatial Reference: 102658
(2236)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
UNIT
(
type: esriFieldTypeString, alias: UNIT, length: 70
)
-
CITY
(
type: esriFieldTypeString, alias: CITY, length: 30
)
-
Shape
(
type: esriFieldTypeGeometry, alias: SHAPE
)
-
SRRQSTID
(
type: esriFieldTypeInteger, alias: SR_REQUEST_ID
)
-
SRTYPE
(
type: esriFieldTypeString, alias: SR_TYPE, length: 20
)
-
SRTYPEDESC
(
type: esriFieldTypeString, alias: SR_TYPE_DESCRIPTION, length: 88
)
-
SRSTATUS
(
type: esriFieldTypeString, alias: SR_STATUS, length: 8
)
-
CASENUMBER
(
type: esriFieldTypeString, alias: CASE_NUMBER, length: 11
)
-
INTKEMTHD
(
type: esriFieldTypeString, alias: SR_INTAKE_METHOD, length: 11
)
-
SRPRIORITY
(
type: esriFieldTypeString, alias: SR_PRIORITY, length: 8
)
-
SRRQSTADDR
(
type: esriFieldTypeInteger, alias: SR_REQUEST_ADDRESS
)
-
GISINFOID
(
type: esriFieldTypeInteger, alias: GIS_INFO_ID
)
-
SRDESC
(
type: esriFieldTypeString, alias: SR_DESCRIPTION, length: 1073741822
)
-
SRCOMMENTS
(
type: esriFieldTypeString, alias: SR_COMMENTS, length: 35
)
-
DUEDATE
(
type: esriFieldTypeDate, alias: DUE_DATE, length: 8
)
-
CREATEBY
(
type: esriFieldTypeString, alias: CREATED_BY, length: 65
)
-
CREATENAME
(
type: esriFieldTypeString, alias: CREATED_BY_NAME, length: 35
)
-
CREATEDATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, length: 8
)
-
UPDATEBY
(
type: esriFieldTypeString, alias: UPDATED_BY, length: 65
)
-
UPDATENAME
(
type: esriFieldTypeString, alias: UPDATED_BY_NAME, length: 35
)
-
UPDATEDATE
(
type: esriFieldTypeDate, alias: UPDATED_DATE, length: 8
)
-
ADDRESS
(
type: esriFieldTypeString, alias: FULL_ADDRESS, length: 110
)
-
ZIP
(
type: esriFieldTypeInteger, alias: ZIP
)
-
LOCNAME
(
type: esriFieldTypeString, alias: LOCATION_NAME, length: 35
)
-
SROWNER
(
type: esriFieldTypeString, alias: SR_OWNER, length: 54
)
-
OWNERDESC
(
type: esriFieldTypeString, alias: SR_OWNER_DESCRIPTION, length: 48
)
-
DURATIONDY
(
type: esriFieldTypeSmallInteger, alias: DURATION_DAYS
)
-
CLOSEDDATE
(
type: esriFieldTypeDate, alias: CLOSED_DATE, length: 8
)
-
LASTSTATUS
(
type: esriFieldTypeDate, alias: LAST_STATUS_DATE, length: 8
)
-
LATITUDE
(
type: esriFieldTypeDouble, alias: SR_LATITUDE
)
-
LONGITUDE
(
type: esriFieldTypeDouble, alias: SR_LONGITUDE
)
-
POINT_X
(
type: esriFieldTypeDouble, alias: SR_XCOORDINATE
)
-
POINT_Y
(
type: esriFieldTypeDouble, alias: SR_YCOORDINATE
)
-
FOLIO
(
type: esriFieldTypeString, alias: SR_FOLIO, length: 13
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata