All Layers and Tables (RE_CITYPROPERTY

Layers:

Layer: RE_CITYPROPERTY (19)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Status: UPDATED occasionally using ArcMap

Contact: Dave Koss, City of Tucson Real Estate, 520-837-6716, Dave.Koss@tucsonaz.gov

Intended Use: For map display

Supplemental Information: For list of current City properties, use definition query LAYERDEF = "RE_COTPARC". For sold property use definition query LAYERDEF="RE_SOLDS". Contains some records without geometry.

March 2012 - combined feature classes RE_COTPARC, RE_SOLDS and table RE_RP into RE_CITYPROPERTY.

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[239,252,209,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
RP_NO (type: esriFieldTypeSmallInteger, alias: RP_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
TAX_CODE (type: esriFieldTypeString, alias: TAX_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
OUTTO (type: esriFieldTypeString, alias: OUTTO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
OUTDATE (type: esriFieldTypeDate, alias: OUTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
RP_ADDRESS (type: esriFieldTypeString, alias: RP_ADDRESS, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
FA_NUMBER (type: esriFieldTypeString, alias: FA_NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
OEMFILE (type: esriFieldTypeString, alias: OEMFILE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
CODE (type: esriFieldTypeString, alias: CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
S (type: esriFieldTypeString, alias: S, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
WARD (type: esriFieldTypeString, alias: WARD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 4 more ...)
INTERSECT_ (type: esriFieldTypeString, alias: INTERSECT_, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
STR (type: esriFieldTypeString, alias: STR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
TR (type: esriFieldTypeString, alias: TR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LEGAL (type: esriFieldTypeString, alias: LEGAL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SUBDIVISION (type: esriFieldTypeString, alias: SUBDIVISION, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
I_V (type: esriFieldTypeString, alias: I_V, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
ZONE (type: esriFieldTypeString, alias: ZONE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
USE_STATUS (type: esriFieldTypeString, alias: USE_STATUS, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
RESP_DEPT (type: esriFieldTypeString, alias: RESP_DEPT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
COLOR (type: esriFieldTypeString, alias: COLOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DIMENSIONS (type: esriFieldTypeString, alias: DIMENSIONS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SQ_FT (type: esriFieldTypeDouble, alias: SQ_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
ACRES_THIS_PTN (type: esriFieldTypeDouble, alias: ACRES_THIS_PTN, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOTAL_SQFT (type: esriFieldTypeDouble, alias: TOTAL_SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOTAL_ACRES (type: esriFieldTypeDouble, alias: TOTAL_ACRES, SQL Type: sqlTypeOther, nullable: true, editable: true)
PUR_DATE (type: esriFieldTypeDate, alias: PUR_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PUR_DOC (type: esriFieldTypeString, alias: PUR_DOC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
DEEDIMAG (type: esriFieldTypeString, alias: DEEDIMAG, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
PUR_FROM (type: esriFieldTypeString, alias: PUR_FROM, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
TITLE_ST1 (type: esriFieldTypeString, alias: TITLE_ST1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
ESCROW_NO (type: esriFieldTypeString, alias: ESCROW_NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TITLE_NO (type: esriFieldTypeString, alias: TITLE_NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
PUR_PRICE (type: esriFieldTypeDouble, alias: PUR_PRICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOT_PRICE (type: esriFieldTypeDouble, alias: TOT_PRICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
PUR_FUND (type: esriFieldTypeString, alias: PUR_FUND, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
APP_INDEX (type: esriFieldTypeString, alias: APP_INDEX, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
APPRAISER (type: esriFieldTypeString, alias: APPRAISER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
APP_VAL (type: esriFieldTypeDouble, alias: APP_VAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
APP_DATE (type: esriFieldTypeDate, alias: APP_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ORD1_RESO (type: esriFieldTypeString, alias: ORD1_RESO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ORD2_RESO_NO (type: esriFieldTypeInteger, alias: ORD2_RESO_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
ORD3_RESO_DATE (type: esriFieldTypeDate, alias: ORD3_RESO_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TICKLER (type: esriFieldTypeDate, alias: TICKLER, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TICKLE_NOTES (type: esriFieldTypeString, alias: TICKLE_NOTES, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
SALE_DATE (type: esriFieldTypeDate, alias: SALE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SALE_DOC (type: esriFieldTypeString, alias: SALE_DOC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SALEIMAG (type: esriFieldTypeString, alias: SALEIMAG, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
SOLD_TO (type: esriFieldTypeString, alias: SOLD_TO, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
SALE_TITLE_CO (type: esriFieldTypeString, alias: SALE_TITLE_CO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SALE_ESCROW_NO (type: esriFieldTypeString, alias: SALE_ESCROW_NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SALES_TITLE_INS_NO (type: esriFieldTypeString, alias: SALES_TITLE_INS_NO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SALE_PRICE (type: esriFieldTypeDouble, alias: SALE_PRICE, SQL Type: sqlTypeOther, nullable: true, editable: true)
SALE_FUND (type: esriFieldTypeString, alias: SALE_FUND, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
S1_ORD_RESO (type: esriFieldTypeString, alias: S1_ORD_RESO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
S2_ORD_RESO_NO (type: esriFieldTypeInteger, alias: S2_ORD_RESO_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
S3_ORD_RESO_DATE (type: esriFieldTypeDate, alias: S3_ORD_RESO_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
SALE_COM (type: esriFieldTypeString, alias: SALE_COM, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
IMAGES2 (type: esriFieldTypeString, alias: IMAGES2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
HYPERLINK (type: esriFieldTypeString, alias: HYPERLINK, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
EASEMENTS (type: esriFieldTypeString, alias: EASEMENTS, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
GCOMMENTS (type: esriFieldTypeString, alias: GCOMMENTS, SQL Type: sqlTypeOther, length: 3000, nullable: true, editable: true)
PARCEL (type: esriFieldTypeString, alias: PARCEL, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
USE_ (type: esriFieldTypeString, alias: USE_, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
LANDFCV (type: esriFieldTypeDouble, alias: LANDFCV, SQL Type: sqlTypeOther, nullable: true, editable: true)
IMPFCV (type: esriFieldTypeDouble, alias: IMPFCV, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOTALFCV (type: esriFieldTypeDouble, alias: TOTALFCV, SQL Type: sqlTypeOther, nullable: true, editable: true)
DOCKET (type: esriFieldTypeString, alias: DOCKET, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
PAGE (type: esriFieldTypeString, alias: PAGE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
RECORDDATE (type: esriFieldTypeString, alias: RECORDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TRS_OL (type: esriFieldTypeString, alias: TRS_OL, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
TRS (type: esriFieldTypeString, alias: TRS, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
MAIL1 (type: esriFieldTypeString, alias: MAIL1, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
MAIL2 (type: esriFieldTypeString, alias: MAIL2, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
MAIL3 (type: esriFieldTypeString, alias: MAIL3, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
MAIL4 (type: esriFieldTypeString, alias: MAIL4, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
MAIL5 (type: esriFieldTypeString, alias: MAIL5, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true)
ZIP9 (type: esriFieldTypeString, alias: ZIP9, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
STREETNO (type: esriFieldTypeString, alias: STREETNO, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
STREETNO_R (type: esriFieldTypeInteger, alias: STREETNO_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREETDIR (type: esriFieldTypeString, alias: STREETDIR, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
STREETNAME (type: esriFieldTypeString, alias: STREETNAME, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
STREETCITY (type: esriFieldTypeString, alias: STREETCITY, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
LEGAL1 (type: esriFieldTypeString, alias: LEGAL1, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
LEGAL2 (type: esriFieldTypeString, alias: LEGAL2, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
LEGAL3 (type: esriFieldTypeString, alias: LEGAL3, SQL Type: sqlTypeOther, length: 49, nullable: true, editable: true)
LEGAL4 (type: esriFieldTypeString, alias: LEGAL4, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
LEGAL5 (type: esriFieldTypeString, alias: LEGAL5, SQL Type: sqlTypeOther, length: 39, nullable: true, editable: true)
CURZONE (type: esriFieldTypeString, alias: CURZONE, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
ACRES (type: esriFieldTypeDouble, alias: ACRES, SQL Type: sqlTypeOther, nullable: true, editable: true)
X_HPGN (type: esriFieldTypeDouble, alias: X_HPGN, SQL Type: sqlTypeOther, nullable: true, editable: true)
Y_HPGN (type: esriFieldTypeDouble, alias: Y_HPGN, SQL Type: sqlTypeOther, nullable: true, editable: true)
LON (type: esriFieldTypeDouble, alias: LON, SQL Type: sqlTypeOther, nullable: true, editable: true)
LAT (type: esriFieldTypeDouble, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAPTIP (type: esriFieldTypeString, alias: MAPTIP, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
DATASOURCE (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LAYERDEF (type: esriFieldTypeString, alias: LAYERDEF, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [RE_COTPARC: Current city property], [RE_SOLDS: Sold city property])
OLD_ID (type: esriFieldTypeInteger, alias: OLD_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
DATAORIGIN (type: esriFieldTypeString, alias: DATAORIGIN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
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:

URL: http://166.89.67.61/transview/realestate/search/detail_sum.cfm?&OBJECTID=

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (RE_CITYPROPERTY_AGOVW)

Layers:

Layer: RE_CITYPROPERTY (19)