Name: Portsmouth_5_6_25_1900_ExportTable

Display Field: Info

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• year (type: esriFieldTypeInteger, alias: year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• serial (type: esriFieldTypeInteger, alias: serial, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gq (type: esriFieldTypeString, alias: gq, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gqtype (type: esriFieldTypeString, alias: gqtype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• dwell (type: esriFieldTypeDouble, alias: dwell, SQL Type: sqlTypeOther, nullable: true, editable: true)
• numperhh (type: esriFieldTypeInteger, alias: numperhh, SQL Type: sqlTypeOther, nullable: true, editable: true)
• linenumber (type: esriFieldTypeDouble, alias: linenumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ed (type: esriFieldTypeInteger, alias: ed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• st_orig (type: esriFieldTypeString, alias: st_orig, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pernum (type: esriFieldTypeInteger, alias: pernum, SQL Type: sqlTypeOther, nullable: true, editable: true)
• relate (type: esriFieldTypeString, alias: relate, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• age (type: esriFieldTypeString, alias: age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sex (type: esriFieldTypeString, alias: sex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• race_str (type: esriFieldTypeString, alias: race_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• marst (type: esriFieldTypeString, alias: marst, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• bpl (type: esriFieldTypeString, alias: bpl, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• nativity (type: esriFieldTypeString, alias: nativity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• citizen (type: esriFieldTypeString, alias: citizen, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• occ1950 (type: esriFieldTypeString, alias: occ1950, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• occscore (type: esriFieldTypeInteger, alias: occscore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ind1950 (type: esriFieldTypeString, alias: ind1950, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• occ_str (type: esriFieldTypeString, alias: occ_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• birthyr (type: esriFieldTypeInteger, alias: birthyr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• namelast (type: esriFieldTypeString, alias: namelast, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• namefrst (type: esriFieldTypeString, alias: namefrst, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• bpl_str (type: esriFieldTypeString, alias: bpl_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• fbpl_str (type: esriFieldTypeString, alias: fbpl_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mbpl_str (type: esriFieldTypeString, alias: mbpl_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mbpl (type: esriFieldTypeString, alias: mbpl, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• fbpl (type: esriFieldTypeString, alias: fbpl, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• birthmo (type: esriFieldTypeString, alias: birthmo, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• histid (type: esriFieldTypeString, alias: histid, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• hn_orig (type: esriFieldTypeInteger, alias: hn_orig, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hn (type: esriFieldTypeInteger, alias: hn, SQL Type: sqlTypeOther, nullable: true, editable: true)
• st (type: esriFieldTypeString, alias: st, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• race (type: esriFieldTypeString, alias: race, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• age_str (type: esriFieldTypeString, alias: age_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• county_str (type: esriFieldTypeString, alias: county_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• state_str (type: esriFieldTypeString, alias: state_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• township_s (type: esriFieldTypeString, alias: township_s, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• city_str (type: esriFieldTypeString, alias: city_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pageno (type: esriFieldTypeInteger, alias: pageno, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ind_str (type: esriFieldTypeString, alias: ind_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• marst_str (type: esriFieldTypeString, alias: marst_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• relate_str (type: esriFieldTypeString, alias: relate_str, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address_Up (type: esriFieldTypeString, alias: Address_Up, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Area (type: esriFieldTypeString, alias: Area, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• geometry (type: esriFieldTypeString, alias: geometry, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gen1IRE (type: esriFieldTypeInteger, alias: gen1IRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gen1CANADA (type: esriFieldTypeInteger, alias: gen1CANADA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gen1UK (type: esriFieldTypeInteger, alias: gen1UK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gen1ITALY (type: esriFieldTypeInteger, alias: gen1ITALY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• gen2ire (type: esriFieldTypeString, alias: gen2ire, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gen2canada (type: esriFieldTypeString, alias: gen2canada, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gen2UK (type: esriFieldTypeString, alias: gen2UK, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gen2Italy (type: esriFieldTypeString, alias: gen2Italy, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• gen3US (type: esriFieldTypeInteger, alias: gen3US, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Info (type: esriFieldTypeString, alias: Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Portsmouth_5_6_25_1900_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Portsmouth_uniq_addr_5_6_26_Geocoded (0) -- Related To: Portsmouth_uniq_addr_5_6_26_Geocoded (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/7/2025 12:08:43 PM

Schema Last Edit Date: 5/7/2025 12:08:43 PM

Data Last Edit Date: 5/7/2025 12:08:43 PM

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