Name: PLANNINGCADASTRE_plan_review_cases

Display Field: PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This point dataset contains information retrieved from the City's Application MANagement and Data Automation (AMANDA) database and includes information on location, proposed variances, applicants, owners, case managers etc, if available. Note that many fields are intentionally left blank or are not filled out for various reasons.

Copyright Text: This dataset was created by the Development Services Department in coordination with the Communications and Technology Management Department at the City of Austin.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 3022815.00001098
YMin: 10003528.0000509
XMax: 3178811.00002623
YMax: 10161013.0000409
Spatial Reference: 102739 (2277)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[133,0,11,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PLAN_REVIEW_CASES_ID (type: esriFieldTypeInteger, alias: PLAN_REVIEW_CASES_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERMIT_TYPE (type: esriFieldTypeString, alias: PERMIT_TYPE, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FOLDER_TYPE (type: esriFieldTypeString, alias: FOLDER_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FOLDERRSN (type: esriFieldTypeInteger, alias: FOLDERRSN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PERMIT_NUMBER (type: esriFieldTypeString, alias: PERMIT_NUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PROJECT_NAME (type: esriFieldTypeString, alias: PROJECT_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• SUB_TYPE (type: esriFieldTypeString, alias: SUB_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• WORK_CLASS (type: esriFieldTypeString, alias: WORK_CLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• REFERENCEFILE (type: esriFieldTypeString, alias: REFERENCEFILE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FOLDER_DESCRIPTION (type: esriFieldTypeString, alias: FOLDER_DESCRIPTION, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• STATUS_CURRENT (type: esriFieldTypeString, alias: STATUS_CURRENT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATUS_DATE (type: esriFieldTypeDate, alias: STATUS_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WEB_LINK (type: esriFieldTypeString, alias: WEB_LINK, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• APPLICANT_FULL_NAME (type: esriFieldTypeString, alias: APPLICANT_FULL_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• APPLICANT_ORGANIZATION_NAME (type: esriFieldTypeString, alias: APPLICANT_ORGANIZATION_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• APPLICANT_ADDRESS (type: esriFieldTypeString, alias: APPLICANT_ADDRESS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• APPLICANT_PHONE (type: esriFieldTypeString, alias: APPLICANT_PHONE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OWNER_FULL_NAME (type: esriFieldTypeString, alias: OWNER_FULL_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OWNER_ORGANIZATION_NAME (type: esriFieldTypeString, alias: OWNER_ORGANIZATION_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OWNER_ADDRESS (type: esriFieldTypeString, alias: OWNER_ADDRESS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OWNER_PHONE (type: esriFieldTypeString, alias: OWNER_PHONE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OTHER_FULL_NAME (type: esriFieldTypeString, alias: OTHER_FULL_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OTHER_ORGANIZATION_NAME (type: esriFieldTypeString, alias: OTHER_ORGANIZATION_NAME, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OTHER_ADDRESS (type: esriFieldTypeString, alias: OTHER_ADDRESS, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• OTHER_PHONE (type: esriFieldTypeString, alias: OTHER_PHONE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• APPRAISAL_ID (type: esriFieldTypeString, alias: APPRAISAL_ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ISSUED_DATE (type: esriFieldTypeDate, alias: ISSUED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ISSUED_IN_LAST_30_DAYS (type: esriFieldTypeString, alias: ISSUED_IN_LAST_30_DAYS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DAY_ISSUED (type: esriFieldTypeString, alias: DAY_ISSUED, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CALENDAR_YEAR_ISSUED (type: esriFieldTypeString, alias: CALENDAR_YEAR_ISSUED, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FISCAL_YEAR_ISSUED (type: esriFieldTypeString, alias: FISCAL_YEAR_ISSUED, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• APPLIED_DATE (type: esriFieldTypeDate, alias: APPLIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXPIRES_DATE (type: esriFieldTypeDate, alias: EXPIRES_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FINAL_DATE (type: esriFieldTypeDate, alias: FINAL_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BUILDING_VALUATION (type: esriFieldTypeString, alias: BUILDING_VALUATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BUILDING_VALUATION_REMODEL (type: esriFieldTypeString, alias: BUILDING_VALUATION_REMODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ELECTRICAL_VALUATION (type: esriFieldTypeString, alias: ELECTRICAL_VALUATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ELECTRICAL_VALUATION_REMODEL (type: esriFieldTypeString, alias: ELECTRICAL_VALUATION_REMODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MECHANICAL_VALUATION (type: esriFieldTypeString, alias: MECHANICAL_VALUATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MECHANICAL_VALUATION_REMODEL (type: esriFieldTypeString, alias: MECHANICAL_VALUATION_REMODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MEDGAS_VALUATION (type: esriFieldTypeString, alias: MEDGAS_VALUATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MEDGAS_VALUATION_REMODEL (type: esriFieldTypeString, alias: MEDGAS_VALUATION_REMODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NUMBER_OF_FLOORS (type: esriFieldTypeString, alias: NUMBER_OF_FLOORS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NUMBER_OF_UNITS (type: esriFieldTypeString, alias: NUMBER_OF_UNITS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PLUMBING_VALUATION (type: esriFieldTypeString, alias: PLUMBING_VALUATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PLUMBING_VALUATION_REMODEL (type: esriFieldTypeString, alias: PLUMBING_VALUATION_REMODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REMODEL_REPAIR_FOOTAGE (type: esriFieldTypeString, alias: REMODEL_REPAIR_FOOTAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOTAL_EXISTING_BLDG_FOOTAGE (type: esriFieldTypeString, alias: TOTAL_EXISTING_BLDG_FOOTAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOTAL_JOB_VALUATION (type: esriFieldTypeString, alias: TOTAL_JOB_VALUATION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOTAL_NEW_ADD_FOOTAGE (type: esriFieldTypeString, alias: TOTAL_NEW_ADD_FOOTAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOTAL_VALUATION_REMODEL (type: esriFieldTypeString, alias: TOTAL_VALUATION_REMODEL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CONDOMINIUM (type: esriFieldTypeString, alias: CONDOMINIUM, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• COUNCIL_DISTRICT (type: esriFieldTypeString, alias: COUNCIL_DISTRICT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LEGAL_DESCRIPTION (type: esriFieldTypeString, alias: LEGAL_DESCRIPTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PROPX (type: esriFieldTypeString, alias: PROPX, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROPY (type: esriFieldTypeString, alias: PROPY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeString, alias: LATITUDE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeString, alias: LONGITUDE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PROPERTYRSN (type: esriFieldTypeInteger, alias: PROPERTYRSN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPDATE_DATE (type: esriFieldTypeDate, alias: UPDATE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATED_BY (type: esriFieldTypeString, alias: CREATED_BY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MODIFIED_DATE (type: esriFieldTypeDate, alias: MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODIFIED_BY (type: esriFieldTypeString, alias: MODIFIED_BY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: PLANNINGCADASTRE_plan_review_cases
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 7:28:01 AM

Schema Last Edit Date: 7/22/2025 7:28:01 AM

Data Last Edit Date: 7/22/2025 7:28:01 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat