ArcGIS REST Services Directory
Login
Home
>
services
>
BN_PROD_PUBLIC (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (BN_PROD_PUBLIC)
Layers:
Layer:
Firm Locations Certifications
(6)
Name:
Firm Locations Certifications
Display Field:
FL_FIRM_NAME
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
MaxSelectionCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Unique Id Infos:
Type: simple
Fields: ["OBJECTID"]
OID Field Contains Hash Value: false
Extent:
XMin: -9176745.661558352
YMin: 3206611.989692424
XMax: -9170019.586541645
YMax: 3212116.349207576
Spatial Reference: 102100 (3857) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[219, 252, 207, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Feature Draw Order:
N/A
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
Shape
( type: esriFieldTypeGeometry, alias: Shape )
FL_FIRM_GLOBALID
( type: esriFieldTypeGUID, alias: Firm Global ID, length: 38 )
FL_FIRM_NO
( type: esriFieldTypeString, alias: Firm Number, length: 10 )
FL_FIRM_NAME
( type: esriFieldTypeString, alias: Firm Name, length: 250 )
FL_FIRM_TYPE
( type: esriFieldTypeString, alias: Firm Type, length: 100 )
FL_LOC_NO
( type: esriFieldTypeString, alias: Location Number, length: 10 )
FL_LOC_NAME
( type: esriFieldTypeString, alias: Location Name, length: 250 )
FL_PHYSICALADD
( type: esriFieldTypeString, alias: Location Physical Address, length: 250 )
FL_CITY
( type: esriFieldTypeString, alias: City, length: 150 )
FL_STATE
( type: esriFieldTypeString, alias: State, length: 150 )
FL_ZIP
( type: esriFieldTypeString, alias: Zip, length: 150 )
FL_COUNTY
( type: esriFieldTypeString, alias: County, length: 150 )
FL_PHONE
( type: esriFieldTypeString, alias: Firm Location Phone Number, length: 20 )
FL_STATUS
( type: esriFieldTypeString, alias: Status, length: 100 )
FL_ROUTE
( type: esriFieldTypeString, alias: Route, length: 100 )
FL_DISTRICT
( type: esriFieldTypeString, alias: District, length: 150 )
FL_NEMA_NO
( type: esriFieldTypeString, alias: Nema Number, length: 100 )
FL_PI_AREA
( type: esriFieldTypeString, alias: Area, length: 7 )
FL_PI_REGION
( type: esriFieldTypeString, alias: Region, length: 9 )
GlobalID
( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
CT_FIRM_GLOBALID
( type: esriFieldTypeGUID, alias: CT_FIRM_GLOBALID, length: 38 )
CT_LOC_GLOBALID
( type: esriFieldTypeGUID, alias: CT_LOC_GLOBALID, length: 38 )
CT_FIRM_NO
( type: esriFieldTypeInteger, alias: CT_FIRM_NO )
CT_FIRM_NAME
( type: esriFieldTypeString, alias: CT_FIRM_NAME, length: 250 )
CT_FIRM_TYPE
( type: esriFieldTypeString, alias: CT_FIRM_TYPE, length: 100 )
CT_CERT_TYPE
( type: esriFieldTypeString, alias: CT_CERT_TYPE, length: 50 )
CT_CA
( type: esriFieldTypeString, alias: CT_CA, length: 50 )
CT_CA_EXPDATE
( type: esriFieldTypeDate, alias: CT_CA_EXPDATE, length: 8 )
POTSIZE
( type: esriFieldTypeString, alias: POTSIZE, length: 2000 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
Layer:
Firm Locations
(1)
Name:
Firm Locations
Display Field:
FL_FIRM_NAME
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: -1.3656411052299999E7
YMin: -569.181899998337
XMax: 9004296.4195
YMax: 7014819.190800004
Spatial Reference: 102100 (3857) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[252, 239, 201, 255]
Outline:
Style:
esriSLSSolid
Color:
[110, 110, 110, 255]
Width:
0
Label:
N/A
Description:
N/A
Transparency:
0
Labeling Info:
Feature Draw Order:
N/A
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
true
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
FL_FIRM_GLOBALID
( type: esriFieldTypeGUID, alias: Firm Global ID, length: 38 )
FL_FIRM_NO
( type: esriFieldTypeInteger, alias: Firm Number )
FL_FIRM_NAME
( type: esriFieldTypeString, alias: Firm Name, length: 250 )
FL_FIRM_TYPE
( type: esriFieldTypeString, alias: Firm Type, length: 100 ,
Coded Values:
[NURSERY: NURSERY] , [STOCK DEALER: STOCK DEALER] , [UNREGISTERED: UNREGISTERED] )
FL_LOC_NO
( type: esriFieldTypeInteger, alias: Location Number )
FL_LOC_NAME
( type: esriFieldTypeString, alias: Location Name, length: 250 )
FL_LOC_TYPE
( type: esriFieldTypeString, alias: Firm Location Type, length: 100 )
FL_CA_EXPDATE
( type: esriFieldTypeDate, alias: NEMA Expiration Date, length: 8 )
FL_PHYSICALADD
( type: esriFieldTypeString, alias: Location Physical Address, length: 250 )
FL_CITY
( type: esriFieldTypeString, alias: City, length: 150 )
FL_STATE
( type: esriFieldTypeString, alias: State, length: 150 ,
Coded Values:
[AK: ALASKA] , [AL: ALABAMA] , [AR: ARKANSAS]
, ...49 more...
)
FL_ZIP
( type: esriFieldTypeString, alias: Zip, length: 150 )
FL_COUNTY
( type: esriFieldTypeString, alias: County, length: 150 ,
Coded Values:
[ALACHUA: ALACHUA] , [BAKER: BAKER] , [BAY: BAY]
, ...65 more...
)
FL_PHONE
( type: esriFieldTypeString, alias: Firm Location Phone Number, length: 20 )
FL_STATUS
( type: esriFieldTypeString, alias: Status, length: 100 ,
Coded Values:
[ACTIVE: ACTIVE] , [RETIRED: RETIRED] , [PENDING: PENDING] )
FL_ROUTE
( type: esriFieldTypeString, alias: Route, length: 100 )
FL_DISTRICT
( type: esriFieldTypeString, alias: District, length: 150 )
FL_NEMA_NO
( type: esriFieldTypeString, alias: Nema Number, length: 100 )
FL_GARDEN_CENTER
( type: esriFieldTypeString, alias: Garden Center, length: 5 )
FL_CITRUSNUR_INSP
( type: esriFieldTypeString, alias: Citrus Nursery Inspection, length: 5 )
FL_IFA_NO
( type: esriFieldTypeString, alias: IFA Number, length: 15 )
FL_RISK
( type: esriFieldTypeString, alias: Risk, length: 10 ,
Coded Values:
[Low: Low] , [Medium: Medium] , [High: High] )
FL_PCT_FIELDGROWN
( type: esriFieldTypeDouble, alias: Field Grown Percent )
FL_PCT_CONTAINERGROWN
( type: esriFieldTypeDouble, alias: Container Grown Percent )
FL_LATITUDE
( type: esriFieldTypeDouble, alias: Latitude )
FL_LONGITUDE
( type: esriFieldTypeDouble, alias: Longitude )
FL_PARCELS
( type: esriFieldTypeString, alias: Parcels, length: 250 )
FL_NOTES
( type: esriFieldTypeString, alias: Notes, length: 250 )
FL_DELETEFLAG
( type: esriFieldTypeString, alias: Delete Flag, length: 5 )
CREATE_USER
( type: esriFieldTypeString, alias: Creation User, length: 50 )
CREATE_DATE
( type: esriFieldTypeDate, alias: Created Date, length: 8 )
EDIT_USER
( type: esriFieldTypeString, alias: Edited By, length: 50 )
EDIT_DATE
( type: esriFieldTypeDate, alias: Edited Date, length: 8 )
FL_PI_AREA
( type: esriFieldTypeString, alias: Area, length: 7 ,
Coded Values:
[A1: A1] , [A2: A2] , [A3: A3]
, ...4 more...
)
FL_PI_REGION
( type: esriFieldTypeString, alias: Region, length: 9 ,
Coded Values:
[R1: R1] , [R2: R2] , [R3: R3] )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
FL_SPECIALTY
( type: esriFieldTypeString, alias: Secialty, length: 50 ,
Coded Values:
[BULBS/CORMS: BULBS/CORMS] , [BROMELIAD: BROMELIAD] , [BONSAI: BONSAI]
, ...21 more...
)
FL_BN_INSPECTOR
( type: esriFieldTypeString, alias: BN Inspector, length: 5 )
FL_LAST_INSPECTION
( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
INTERGRATION_METADATA
( type: esriFieldTypeString, alias: INTERGRATION_METADATA, length: 255 )
Shape.STArea()
( type: esriFieldTypeDouble, alias: Shape.STArea() )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
Relationships:
DPI_PI_ADMIN.PI_BN_CertificationType (0) --
Related To
:
Certification
(2)
DPI_PI_ADMIN.PI_Firm (1) --
Related To
:
Firm
(5)
Tables:
Table:
QC390_Compliant_Stock_Dealers
(14)
Name:
QC390_Compliant_Stock_Dealers
Display Field:
FL_FIRM_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Unique Id Infos:
Type: simple
Fields: ["GlobalID"]
OID Field Contains Hash Value: true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GlobalID
( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
BN
( type: esriFieldTypeString, alias: BN, length: 100 )
Reg
( type: esriFieldTypeString, alias: Reg, length: 30 )
FL_FIRM_NAME
( type: esriFieldTypeString, alias: FL_FIRM_NAME, length: 250 )
Mailing_Address
( type: esriFieldTypeString, alias: Mailing_Address, length: 703 )
LOCATION_NO
( type: esriFieldTypeString, alias: LOCATION_NO, length: 30 )
Physical_Address
( type: esriFieldTypeString, alias: Physical_Address, length: 703 )
Telephone
( type: esriFieldTypeString, alias: Telephone, length: 20 )
Compliance_Review_Date
( type: esriFieldTypeDate, alias: Compliance_Review_Date, length: 8 )
Last_Reviewed
( type: esriFieldTypeDate, alias: Last_Reviewed, length: 8 )
Issued
( type: esriFieldTypeDate, alias: Issued, length: 8 )
ESRI_OID
( type: esriFieldTypeOID, alias: ESRI_OID )
Table:
QC390_Compliant_Nurseries
(15)
Name:
QC390_Compliant_Nurseries
Display Field:
FL_FIRM_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Unique Id Infos:
Type: simple
Fields: ["GlobalID"]
OID Field Contains Hash Value: true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GlobalID
( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
BN
( type: esriFieldTypeString, alias: BN, length: 100 )
Reg
( type: esriFieldTypeString, alias: Reg, length: 30 )
FL_FIRM_NAME
( type: esriFieldTypeString, alias: FL_FIRM_NAME, length: 250 )
Mailing_Address
( type: esriFieldTypeString, alias: Mailing_Address, length: 703 )
LOCATION_NO
( type: esriFieldTypeString, alias: LOCATION_NO, length: 30 )
Physical_Address
( type: esriFieldTypeString, alias: Physical_Address, length: 703 )
Telephone
( type: esriFieldTypeString, alias: Telephone, length: 20 )
Compliance_Review_Date
( type: esriFieldTypeDate, alias: Compliance_Review_Date, length: 8 )
Last_Reviewed
( type: esriFieldTypeDate, alias: Last_Reviewed, length: 8 )
Issued
( type: esriFieldTypeDate, alias: Issued, length: 8 )
ESRI_OID
( type: esriFieldTypeOID, alias: ESRI_OID )
Table:
Certification
(2)
Name:
Certification
Display Field:
CT_FIRM_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
CT_FIRM_GLOBALID
( type: esriFieldTypeGUID, alias: Firm Global ID, length: 38 )
CT_LOC_GLOBALID
( type: esriFieldTypeGUID, alias: Firm Location Global ID, length: 38 )
CT_FIRM_NO
( type: esriFieldTypeInteger, alias: Firm Number )
CT_FIRM_NAME
( type: esriFieldTypeString, alias: Firm Name, length: 250 )
CT_FIRM_TYPE
( type: esriFieldTypeString, alias: Firm Type, length: 100 ,
Coded Values:
[NURSERY-RETAIL: Nursery-Retail] , [NURSERY-WHOLESALE: Nursery-Wholesale] , [NURSERY-RETAIL & WHOLESALE: Nursery-Retail & Wholesale]
, ...9 more...
)
CT_CERT_TYPE
( type: esriFieldTypeString, alias: Certification Type, length: 50 )
CT_CA
( type: esriFieldTypeString, alias: Locaton Number, length: 50 )
CT_CA_EXPDATE
( type: esriFieldTypeDate, alias: Certification Expiration Date, length: 8 )
POTSIZE
( type: esriFieldTypeString, alias: Pot Size, length: 2000 )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
CT_NOTES
( type: esriFieldTypeString, alias: CT_NOTES, length: 500 )
Relationships:
PI_BN_PlantSpecies (2) --
Related To
:
Plant Species
(4)
DPI_PI_ADMIN.PI_FirmLocations (0) --
Related To
:
Firm Locations
(1)
Table:
PLANT_LIST_LU
(3)
Name:
PLANT_LIST_LU
Display Field:
Genus
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
Genus
( type: esriFieldTypeString, alias: Genius, length: 255 )
Species
( type: esriFieldTypeString, alias: Species, length: 255 )
subspecies
( type: esriFieldTypeString, alias: subspecies, length: 255 )
variety
( type: esriFieldTypeString, alias: variety, length: 255 )
cultivar
( type: esriFieldTypeString, alias: cultivar, length: 255 )
Active
( type: esriFieldTypeString, alias: Active, length: 3 ,
Coded Values:
[Yes: Yes] , [No: No] )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
Hybrid
( type: esriFieldTypeString, alias: Hybrid, length: 1 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
Table:
Plant Species
(4)
Name:
Plant Species
Display Field:
PS_FIRM_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
PS_CERTTYPE_GLOBALID
( type: esriFieldTypeGUID, alias: Certification Global Id, length: 38 )
PS_FIRM_NO
( type: esriFieldTypeInteger, alias: Firm Number )
PS_FIRM_NAME
( type: esriFieldTypeString, alias: Firm Name, length: 250 )
PS_FIRM_TYPE
( type: esriFieldTypeString, alias: Firm Type, length: 100 ,
Coded Values:
[NURSERY-RETAIL: Nursery-Retail] , [NURSERY-WHOLESALE: Nursery-Wholesale] , [NURSERY-RETAIL & WHOLESALE: Nursery-Retail & Wholesale]
, ...9 more...
)
PS_FIRM_LOC_NO
( type: esriFieldTypeInteger, alias: Firm Location Number )
PS_FIRM_LOC_NAME
( type: esriFieldTypeString, alias: Firm Location Name, length: 250 )
PS_FIRM_LOC_TYPE
( type: esriFieldTypeString, alias: Firm Location Type, length: 100 )
PS_CERT_TYPE
( type: esriFieldTypeString, alias: Certification Type, length: 50 )
PS_GENUS
( type: esriFieldTypeString, alias: Plant Genius, length: 250 )
PS_SPECIES
( type: esriFieldTypeString, alias: Plant Species, length: 250 )
PS_STATUS
( type: esriFieldTypeString, alias: Plant Certification Status, length: 8 ,
Coded Values:
[Active: Active] , [Inactive: Inactive] )
PS_FROMDATE
( type: esriFieldTypeDate, alias: Plant Certification Status From Date, length: 8 )
PS_TODATE
( type: esriFieldTypeDate, alias: Plant Certification Status To Date, length: 8 )
CREATE_USER
( type: esriFieldTypeString, alias: Creation User, length: 50 )
CREATE_DATE
( type: esriFieldTypeDate, alias: Created Date, length: 8 )
EDIT_USER
( type: esriFieldTypeString, alias: Edited By, length: 50 )
EDIT_DATE
( type: esriFieldTypeDate, alias: Edited Date, length: 8 )
PS_SUBSPECIES
( type: esriFieldTypeString, alias: Plant Subspecies, length: 255 )
PS_VARIETY
( type: esriFieldTypeString, alias: Plant Variety, length: 255 )
PS_CULTIVAR
( type: esriFieldTypeString, alias: Plant Cultivar, length: 255 )
FIRM_GLOBALID
( type: esriFieldTypeGUID, alias: FIRM_GlobalID, length: 38 )
LOCATION_GLOBALID
( type: esriFieldTypeGUID, alias: Location_GlobalID, length: 38 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
Relationships:
PI_BN_CertificationType (2) --
Related To
:
Certification
(2)
Table:
Firm
(5)
Name:
Firm
Display Field:
PI_FIRM_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
aef1ca095c7945b8bdba8645cc203426
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
PI_FIRM_NO
( type: esriFieldTypeInteger, alias: Firm Number )
PI_FIRM_NAME
( type: esriFieldTypeString, alias: Firm Name, length: 250 )
PI_FIRM_TYPE
( type: esriFieldTypeString, alias: Firm Type, length: 100 ,
Coded Values:
[NURSERY: NURSERY] , [STOCK DEALER: STOCK DEALER] , [UNREGISTERED: UNREGISTERED] )
PI_FIRM_STATUS
( type: esriFieldTypeString, alias: Firm Status, length: 100 ,
Coded Values:
[Active: Active] , [Delinquent: Delinquent] , [OB Inspector: OB Inspector]
, ...3 more...
)
PI_FIRM_OWNERNAME
( type: esriFieldTypeString, alias: Firm Owner Name, length: 250 )
PI_FIRM_PHONE
( type: esriFieldTypeString, alias: Firm Phone Number, length: 20 )
PI_FIRM_EMAIL
( type: esriFieldTypeString, alias: Firm Email, length: 50 )
PI_FIRM_MAILINGADD
( type: esriFieldTypeString, alias: Firm Mailing Address, length: 250 )
PI_FIRM_CITY
( type: esriFieldTypeString, alias: City, length: 150 )
PI_FIRM_STATE
( type: esriFieldTypeString, alias: State, length: 150 ,
Coded Values:
[AK: ALASKA] , [AL: ALABAMA] , [AR: ARKANSAS]
, ...49 more...
)
PI_FIRM_ZIP
( type: esriFieldTypeString, alias: Zip, length: 150 )
PI_FIRM_COUNTY
( type: esriFieldTypeString, alias: County, length: 150 ,
Coded Values:
[ALACHUA: ALACHUA] , [BAKER: BAKER] , [BAY: BAY]
, ...65 more...
)
PI_FIRM_COUNTRY
( type: esriFieldTypeString, alias: Country, length: 150 ,
Coded Values:
[AFGHANISTAN: AFGHANISTAN] , [ALGERIA: ALGERIA] , [ALBANIA: ALBANIA]
, ...261 more...
)
PI_NEMA_NO
( type: esriFieldTypeString, alias: Nema Number, length: 15 )
PI_IFA_NO
( type: esriFieldTypeString, alias: IFA Number, length: 15 )
PI_NOTES
( type: esriFieldTypeString, alias: Notes, length: 250 )
PI_DELETEFLAG
( type: esriFieldTypeString, alias: Delete Flag, length: 5 ,
Coded Values:
[Yes: Yes] , [No: No] )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
CERT_EXPIRE
( type: esriFieldTypeDate, alias: Certificate Experation, length: 8 )
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
PI_FIRM_PHONE2
( type: esriFieldTypeString, alias: Secondary Phon Number, length: 20 )
PI_FIRM_BALANCE_DUE
( type: esriFieldTypeDouble, alias: Payment Balance Due )
INTERGRATION_METADATA
( type: esriFieldTypeString, alias: INTERGRATION_METADATA, length: 255 )
Relationships:
DPI_PI_ADMIN.PI_FirmLocations (1) --
Related To
:
Firm Locations
(1)