Name: Residential Permit Statistics
Display Field: SUB_NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: This feature class was derived from the LMSACTIVITIES_BUILDINGSAFTEY feature class and the SPECIFIC_PLAN feature class.This feature class is updated by a python script each morning from the previous day's building permits. The script is named BRS_UPDATE.py and is located in the //agency/agencydfs/Tran/Files/rfairhur/Python_Scripts directory. The original data is stored in the Plus_Conversion_Data.gdb file geodatabase in the //agency/agencydfs/Tran/Files/rfairhur/Layers/Plus_Conversion_Data directory.The fields in this feature class are:LMS_KEY - The unique key value within the LMS system. In this feature class it is not unique for Specific Plan Planning Areas.CASENAME - The format a user would input to the LMS system to find the caseCASE_TYPE - The main type of the case, which can be either SP or TR.STATUS - The status of the case. These cases are all approved cases, even if the LMS system does not have that status.CATEGORY - PLNG is the category for all these cases.DEPARTMENT - PLANNING is the Department for all these cases.APPLIED_DATE - The application date for the case expressed as a number in the format YYYYMMDD.APPROVED_DATE - The approved date for the case expressed as a number in the format YYYYMMDD.COMPLETED_DATE - The completed date for the case expressed as a number in the format YYYYMMDD.EXPIRED_DATE - The expiration date for the case expressed as a number in the format YYYYMMDD.CASE_TYPE_DESC - The human readable description of the Case TypeCASE_DESC - A brief description of what the case was designed to do.CONSTRUCTION - The code for the case type.LOCATION - A description of the case locationTRACT - The numeric portion of a Tract number. Only used with Tracts. This corresponds to the same field in PARCEL_ASSESSORS.SUB_NAME - The title of a Tract. Only used with Tracts. This corresponds to the same field in PARCEL_ASSESSORS.SP_NUMBER - The base number assigned a Specifc Plan. Used with both Specific Plans and Tracts (to indicate the Tract is within the Specifc Plan).SP_NAME - The Specific Plan name. Used with both Specific Plans and Tracts (to indicate the Tract is within the Specifc Plan).ADOPTED_DATE - The original adoption date of the Specific Plan or an Amendment adoption date. Only used for Specific Plans.PLANNING_AREA - The Planning Area designation for the portion of the Specific Plan within the boundary. Only used for Specific Plans.SPLU_DESCRIPTION - The Specific Plan Land Use Description as stated in the Specific Plan document. These designations vary from plan to plan and are not standardized.LAND_USE_STANDARDIZED - The standard Land Use Designation codes used by the General Plan that best represents the SPLU_DESCRIPTION.MINIMUM_LOT_SIZE_SQ_FT - The minimum lot size permitted by the Planning Area or Tract, always expressed in square feet.ACRES - The GIS calculated Acreage of the feature boundary, not the acreage identified in the Specific Plan document or Tract description.MIN_DENSITY - The minimum desity permitted within the Planning Area.MAX_DENSITY -The maximum desity permitted within the Planning Area.EXPECTED_UNITS - The number of residential units expected to be built within the Planning Area or Tract. This may be more or less than the Approved Units authorized if the recorded maps had more or less residential lots than the original Planning authorization.APPROVED_UNITS - The number of units authorized by the original Planning approvak of the case,PRE_LMS_UNITS - The building permti units that must have been built before the LMS system could track building permits.PERMIT_FINAL_UNITS - The number of LMS hounsing units counted from BRS cases within the LMS system.PERMIT_FINAL_UNITS - The number of LMS housing units counted from BRS cases within the LMS system that have a status of FINAL.TOTAL_FINAL_UNITS - The sum of the PRE_LMS_UNITS and PERMIT_FINAL_UNITS.PERCENT_FINAL - The percent of build out of the TOTAL_FINAL_UNITS relative to the EXPECTED_UNITS.PERMIT_ISSUED_UNITS - The number of LMS housing units counted from BRS cases within the LMS system that have a status of ISSUED.TOTAL_ISSUED_UNITS - The sum of the PRE_LMS_UNITS, PERMIT_FINAL_UNITS and PERMIT_ISSUED_UNITS.PERCENT_ISSUED - The percent of build out of the TOTAL_ISSUED_UNITS relative to the EXPECTED_UNITS.PERMIT_ACTIVE_UNITS - The number of LMS hounsing units counted from BRS cases within the LMS system that have a Status of APPLIED, PLANCK, or PCAPPR.TOTAL_ACTIVE_UNITS - The sum of the PRE_LMS_UNITS, PERMIT_FINAL_UNITS, PERMIT_ISSUED_UNITS and PERMIT_ACTIVE_UNITS.PERCENT_ACTIVE - The percent of build out of the TOTAL_ACTIVE_UNITS relative to the EXPECTED_UNITSSUPERVISORIAL_DISTRICT - The number of the Supervisorial Distrct in which the case is located.RECORDED_NOTES - Notes concerning the recordation status of the Tract map or of residential tracts within the Specific Plan. The notes are not determined by Planning Area, but only for the entire Specific Plan.
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: false
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 6132308.04956533
YMin: 2098738.673897311
XMax: 7091347.205958247
YMax: 2319907.222372979
Spatial Reference: 102646
(2230)
Drawing Info:
Renderer:
Class Breaks Renderer:
Field: PERCENT_FINAL
Min. Value: 0.0
ClassBreakInfos:
-
Class Maximum Value: 10
Label: 10%
Description:
Symbol:
Style: esriSFSSolid
Color: [0, 0, 255, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 20
Label: 20%
Description:
Symbol:
Style: esriSFSSolid
Color: [54, 97, 255, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 30
Label: 30%
Description:
Symbol:
Style: esriSFSSolid
Color: [56, 172, 255, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 40
Label: 40%
Description:
Symbol:
Style: esriSFSSolid
Color: [0, 255, 255, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 50
Label: 50%
Description:
Symbol:
Style: esriSFSSolid
Color: [145, 255, 180, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 60
Label: 60%
Description:
Symbol:
Style: esriSFSSolid
Color: [210, 255, 105, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 70
Label: 70%
Description:
Symbol:
Style: esriSFSSolid
Color: [255, 255, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 80
Label: 80%
Description:
Symbol:
Style: esriSFSSolid
Color: [255, 183, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 90
Label: 90%
Description:
Symbol:
Style: esriSFSSolid
Color: [255, 111, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
-
Class Maximum Value: 100
Label: 100%
Description:
Symbol:
Style: esriSFSSolid
Color: [255, 0, 0, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
)
-
CASE_TYPE
(
type: esriFieldTypeString
, alias: CASE_TYPE
, length: 50
)
-
DEPARTMENT
(
type: esriFieldTypeString
, alias: DEPARTMENT
, length: 3
)
-
TRACT
(
type: esriFieldTypeInteger
, alias: TRACT
)
-
SUB_NAME
(
type: esriFieldTypeString
, alias: SUB_NAME
, length: 50
)
-
SP_NUMBER
(
type: esriFieldTypeString
, alias: SP_NUMBER
, length: 5
)
-
SP_NAME
(
type: esriFieldTypeString
, alias: SP_NAME
, length: 40
)
-
ADOPTED_DATE
(
type: esriFieldTypeDate
, alias: ADOPTED_DATE
, length: 8
)
-
PLANNING_AREA
(
type: esriFieldTypeString
, alias: PLANNING_AREA
, length: 10
)
-
SPLU_DESIGNATION
(
type: esriFieldTypeString
, alias: SPLU_DESIGNATION
, length: 126
)
-
LAND_USE_STANDARDIZED
(
type: esriFieldTypeString
, alias: LAND_USE_STANDARDIZED
, length: 25
)
-
MINIMUM_LOT_SIZE_SQ_FT
(
type: esriFieldTypeDouble
, alias: MINIMUM_LOT_SIZE_SQ_FT
)
-
ACRES
(
type: esriFieldTypeDouble
, alias: ACRES
)
-
MIN_DENSITY
(
type: esriFieldTypeInteger
, alias: MIN_DENSITY
)
-
MAX_DENSITY
(
type: esriFieldTypeInteger
, alias: MAX_DENSITY
)
-
EXPECTED_UNITS
(
type: esriFieldTypeInteger
, alias: EXPECTED_UNITS
)
-
APPROVED_UNITS
(
type: esriFieldTypeInteger
, alias: APPROVED_UNITS
)
-
PRE_LMS_UNITS
(
type: esriFieldTypeInteger
, alias: PRE_LMS_UNITS
)
-
PERMIT_FINAL_UNITS
(
type: esriFieldTypeInteger
, alias: PERMIT_FINAL_UNITS
)
-
TOTAL_FINAL_UNITS
(
type: esriFieldTypeInteger
, alias: TOTAL_FINAL_UNITS
)
-
PERCENT_FINAL
(
type: esriFieldTypeDouble
, alias: PERCENT_FINAL
)
-
TOTAL_ISSUED_UNITS
(
type: esriFieldTypeInteger
, alias: TOTAL_ISSUED_UNITS
)
-
PERCENT_ISSUED
(
type: esriFieldTypeDouble
, alias: PERCENT_ISSUED
)
-
TOTAL_ACTIVE_UNITS
(
type: esriFieldTypeInteger
, alias: TOTAL_ACTIVE_UNITS
)
-
PERCENT_ACTIVE
(
type: esriFieldTypeDouble
, alias: PERCENT_ACTIVE
)
-
SUPERVISORIAL_DISTRICT
(
type: esriFieldTypeSmallInteger
, alias: SUPERVISORIAL_DISTRICT
)
-
RECORDED_NOTES
(
type: esriFieldTypeString
, alias: RECORDED_NOTES
, length: 50
)
-
Shape
(
type: esriFieldTypeGeometry
, alias: SHAPE
)
-
Shape.STArea()
(
type: esriFieldTypeDouble
, alias: Shape.STArea()
)
-
Shape.STLength()
(
type: esriFieldTypeDouble
, alias: SHAPE.STLength()
)
-
CASE_ID
(
type: esriFieldTypeString
, alias: CASE_ID
, length: 50
)
-
CASE_DESCR
(
type: esriFieldTypeString
, alias: CASE_DESCR
, length: 4000
)
-
CASE_MODULE
(
type: esriFieldTypeString
, alias: CASE_MODULE
, length: 50
)
-
CASE_WORK_CLASS
(
type: esriFieldTypeString
, alias: CASE_WORK_CLASS
, length: 50
)
-
CASE_STATUS
(
type: esriFieldTypeString
, alias: CASE_STATUS
, length: 50
)
-
APPLIED_DATE
(
type: esriFieldTypeDate
, alias: APPLIED_DATE
, length: 8
)
-
APPROVED_DATE
(
type: esriFieldTypeDate
, alias: APPROVED_DATE
, length: 8
)
-
COMPLETED_DATE
(
type: esriFieldTypeDate
, alias: COMPLETED_DATE
, length: 8
)
-
EXPIRED_DATE
(
type: esriFieldTypeDate
, alias: EXPIRED_DATE
, length: 8
)
-
PERMIT_ISSUED_UNITS
(
type: esriFieldTypeInteger
, alias: PERMIT_ISSUED_UNITS
)
-
PERMIT_ACTIVE_UNITS
(
type: esriFieldTypeInteger
, alias: PERMIT_ACTIVE_UNITS
)
-
AP_CODE
(
type: esriFieldTypeString
, alias: AP_CODE
, length: 2
)
-
AP_NAME
(
type: esriFieldTypeString
, alias: AP_NAME
, length: 100
)
Supported Operations:
Query
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata