Name: taxlots
Display Field: NAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: This feature class is imported weekly from the Josephine County Assessor's GIS data located on the Josephine county map server. The data can be accessed via a link to the county's server here: (gis.co.josephine.or.us.ags), it is under the assessors data titled "GIS_update.DBO.Taxlots". Albert McConathy created a model that imports the service, creates a new field, calculates a tax-lot-file link column, deletes old records from the feature class, and appends the feature class with the new imported data. This process should be run weekly. The tool is called "TaxLotUpdateFeatureService" and it's toolbox can be found at the following path O:\GISUserProjects\Users\AlbertMcConathy\DatabaseMaintenance\Models\DatabaseMaintenanceTools.atbx
Copyright Text: Josephine County Assessor
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: -13810851.7712122
YMin: 5157985.61656807
XMax: -13714454.6586822
YMax: 5281060.55424096
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- MNX (type: esriFieldTypeString, alias: MNX, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
- SD (type: esriFieldTypeString, alias: SD, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MAPNUM (type: esriFieldTypeString, alias: MAPNUM, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- ACCOUNT (type: esriFieldTypeString, alias: ACCOUNT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TWN (type: esriFieldTypeString, alias: TWN, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- RNG (type: esriFieldTypeString, alias: RNG, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- SEC (type: esriFieldTypeString, alias: SEC, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- QQ (type: esriFieldTypeString, alias: QQ, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- Taxlot (type: esriFieldTypeString, alias: TAXLOT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- LOC_DESC (type: esriFieldTypeString, alias: LOC_DESC, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- LOT (type: esriFieldTypeString, alias: LOT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- Lot_1 (type: esriFieldTypeString, alias: Lot_1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- BLOCK (type: esriFieldTypeString, alias: BLOCK, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 167, nullable: true, editable: true)
- ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
- ADDR1 (type: esriFieldTypeString, alias: ADDR1, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
- ADDR2 (type: esriFieldTypeString, alias: ADDR2, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
- ADDR3 (type: esriFieldTypeString, alias: ADDR3, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- City (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- State (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- ZIP (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- CSZ (type: esriFieldTypeString, alias: CSZ, SQL Type: sqlTypeOther, length: 54, nullable: true, editable: true)
- SITUS (type: esriFieldTypeString, alias: SITUS, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- SITUS_CITY (type: esriFieldTypeString, alias: Situs_City, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- SITUS_ST (type: esriFieldTypeString, alias: Situs_St, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- SITUS_ZIP (type: esriFieldTypeString, alias: Situs_Zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ST_NO (type: esriFieldTypeString, alias: ST_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SITUS_PREF (type: esriFieldTypeString, alias: SITUS_PREF, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- ST_NAME (type: esriFieldTypeString, alias: ST_NAME, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
- SITUS_SUFF (type: esriFieldTypeString, alias: SITUS_SUFF, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- SITUS_SUF0 (type: esriFieldTypeInteger, alias: SITUS_SUF0, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACCTSTATUS (type: esriFieldTypeString, alias: ACCTSTATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- APPR_VALUE (type: esriFieldTypeDouble, alias: APPR_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ASSD_VALUE (type: esriFieldTypeDouble, alias: ASSD_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- IMP_VALUE (type: esriFieldTypeDouble, alias: IMP_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LAND_APPR (type: esriFieldTypeDouble, alias: LAND_APPR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LAND_MKT (type: esriFieldTypeDouble, alias: LAND_MKT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RMV (type: esriFieldTypeDouble, alias: RMV, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ACREAGE (type: esriFieldTypeDouble, alias: ACREAGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LEGAL_ACRE (type: esriFieldTypeDouble, alias: LEGAL_ACRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PROP_CLASS (type: esriFieldTypeString, alias: PROP_CLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- BLDG_CLASS (type: esriFieldTypeString, alias: BLDG_CLASS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CODE (type: esriFieldTypeString, alias: CODE, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- MAINT (type: esriFieldTypeString, alias: MAINT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- NBHD (type: esriFieldTypeString, alias: NBHD, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- YR_BLT (type: esriFieldTypeDouble, alias: YR_BLT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SQ_FT (type: esriFieldTypeDouble, alias: SQ_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LIVING_AREA (type: esriFieldTypeDouble, alias: LIVING_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BEDRMS (type: esriFieldTypeDouble, alias: BEDRMS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Exempt (type: esriFieldTypeInteger, alias: EXEMPT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Zone (type: esriFieldTypeString, alias: ZONE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SPTB_CODES (type: esriFieldTypeString, alias: SPTB_CODES, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- MH_MAKE (type: esriFieldTypeString, alias: MH_MAKE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- MH_VALUE (type: esriFieldTypeDouble, alias: MH_VALUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COMP_MTL (type: esriFieldTypeInteger, alias: COMP_MTL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Taxes (type: esriFieldTypeDouble, alias: TAXES, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SALE_DATE (type: esriFieldTypeDate, alias: SALE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SALE_PRICE (type: esriFieldTypeDouble, alias: SALE_PRICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DEED_TYPE (type: esriFieldTypeString, alias: DEED_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- INST_NO (type: esriFieldTypeString, alias: INST_NO, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SALE_TYPE (type: esriFieldTypeString, alias: SALE_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GIS_Acres (type: esriFieldTypeDouble, alias: GIS_Acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Doc_Link (type: esriFieldTypeString, alias: Document Link, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Templates:
Name: taxlots
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/28/2022 10:30:09 PM
Schema Last Edit Date: 9/28/2022 10:30:09 PM
Data Last Edit Date: 9/28/2022 10:30:09 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat