{ "layers": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 6, "name": "Firm Locations Certifications", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 219, 252, 207, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -9176745.661558352, "ymin": 3206611.989692424, "xmax": -9170019.586541645, "ymax": 3212116.349207576, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FL_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "FL_FIRM_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Firm Global ID", "length": 38, "domain": null }, { "name": "FL_FIRM_NO", "type": "esriFieldTypeString", "alias": "Firm Number", "length": 10, "domain": null }, { "name": "FL_FIRM_NAME", "type": "esriFieldTypeString", "alias": "Firm Name", "length": 250, "domain": null }, { "name": "FL_FIRM_TYPE", "type": "esriFieldTypeString", "alias": "Firm Type", "length": 100, "domain": null }, { "name": "FL_LOC_NO", "type": "esriFieldTypeString", "alias": "Location Number", "length": 10, "domain": null }, { "name": "FL_LOC_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "length": 250, "domain": null }, { "name": "FL_PHYSICALADD", "type": "esriFieldTypeString", "alias": "Location Physical Address", "length": 250, "domain": null }, { "name": "FL_CITY", "type": "esriFieldTypeString", "alias": "City", "length": 150, "domain": null }, { "name": "FL_STATE", "type": "esriFieldTypeString", "alias": "State", "length": 150, "domain": null }, { "name": "FL_ZIP", "type": "esriFieldTypeString", "alias": "Zip", "length": 150, "domain": null }, { "name": "FL_COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 150, "domain": null }, { "name": "FL_PHONE", "type": "esriFieldTypeString", "alias": "Firm Location Phone Number", "length": 20, "domain": null }, { "name": "FL_STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 100, "domain": null }, { "name": "FL_ROUTE", "type": "esriFieldTypeString", "alias": "Route", "length": 100, "domain": null }, { "name": "FL_DISTRICT", "type": "esriFieldTypeString", "alias": "District", "length": 150, "domain": null }, { "name": "FL_NEMA_NO", "type": "esriFieldTypeString", "alias": "Nema Number", "length": 100, "domain": null }, { "name": "FL_PI_AREA", "type": "esriFieldTypeString", "alias": "Area", "length": 7, "domain": null }, { "name": "FL_PI_REGION", "type": "esriFieldTypeString", "alias": "Region", "length": 9, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CT_FIRM_GLOBALID", "type": "esriFieldTypeGUID", "alias": "CT_FIRM_GLOBALID", "length": 38, "domain": null }, { "name": "CT_LOC_GLOBALID", "type": "esriFieldTypeGUID", "alias": "CT_LOC_GLOBALID", "length": 38, "domain": null }, { "name": "CT_FIRM_NO", "type": "esriFieldTypeInteger", "alias": "CT_FIRM_NO", "domain": null }, { "name": "CT_FIRM_NAME", "type": "esriFieldTypeString", "alias": "CT_FIRM_NAME", "length": 250, "domain": null }, { "name": "CT_FIRM_TYPE", "type": "esriFieldTypeString", "alias": "CT_FIRM_TYPE", "length": 100, "domain": null }, { "name": "CT_CERT_TYPE", "type": "esriFieldTypeString", "alias": "CT_CERT_TYPE", "length": 50, "domain": null }, { "name": "CT_CA", "type": "esriFieldTypeString", "alias": "CT_CA", "length": 50, "domain": null }, { "name": "CT_CA_EXPDATE", "type": "esriFieldTypeDate", "alias": "CT_CA_EXPDATE", "length": 8, "domain": null }, { "name": "POTSIZE", "type": "esriFieldTypeString", "alias": "POTSIZE", "length": 2000, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": null, "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "uniqueIdInfo": { "type": "simple", "fields": [ "OBJECTID" ], "OIDFieldContainsHashValue": false }, "maxUniqueIDCount": 100000, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "Firm Locations", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 252, 239, 201, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -1.3656411052299999E7, "ymin": -569.181899998337, "xmax": 9004296.4195, "ymax": 7014819.190800004, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FL_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FL_FIRM_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Firm Global ID", "length": 38, "domain": null }, { "name": "FL_FIRM_NO", "type": "esriFieldTypeInteger", "alias": "Firm Number", "domain": null }, { "name": "FL_FIRM_NAME", "type": "esriFieldTypeString", "alias": "Firm Name", "length": 250, "domain": null }, { "name": "FL_FIRM_TYPE", "type": "esriFieldTypeString", "alias": "Firm Type", "length": 100, "domain": { "type": "codedValue", "name": "PI_FirmTypes", "description": "", "codedValues": [ { "name": "NURSERY", "code": "NURSERY" }, { "name": "STOCK DEALER", "code": "STOCK DEALER" }, { "name": "UNREGISTERED", "code": "UNREGISTERED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_LOC_NO", "type": "esriFieldTypeInteger", "alias": "Location Number", "domain": null }, { "name": "FL_LOC_NAME", "type": "esriFieldTypeString", "alias": "Location Name", "length": 250, "domain": null }, { "name": "FL_LOC_TYPE", "type": "esriFieldTypeString", "alias": "Firm Location Type", "length": 100, "domain": null }, { "name": "FL_CA_EXPDATE", "type": "esriFieldTypeDate", "alias": "NEMA Expiration Date", "length": 8, "domain": null }, { "name": "FL_PHYSICALADD", "type": "esriFieldTypeString", "alias": "Location Physical Address", "length": 250, "domain": null }, { "name": "FL_CITY", "type": "esriFieldTypeString", "alias": "City", "length": 150, "domain": null }, { "name": "FL_STATE", "type": "esriFieldTypeString", "alias": "State", "length": 150, "domain": { "type": "codedValue", "name": "StatesList", "description": "States List", "codedValues": [ { "name": "ALASKA", "code": "AK" }, { "name": "ALABAMA", "code": "AL" }, { "name": "ARKANSAS", "code": "AR" }, { "name": "ARIZONA", "code": "AZ" }, { "name": "CALIFORNIA", "code": "CA" }, { "name": "COLORADO", "code": "CO" }, { "name": "CONNECTICUT", "code": "CT" }, { "name": "DISTRICT OF COLUMBIA", "code": "DC" }, { "name": "DELAWARE", "code": "DE" }, { "name": "FLORIDA", "code": "FL" }, { "name": "GEORGIA", "code": "GA" }, { "name": "HAWAII", "code": "HI" }, { "name": "IOWA", "code": "IA" }, { "name": "IDAHO", "code": "ID" }, { "name": "ILLINOIS", "code": "IL" }, { "name": "INDIANA", "code": "IN" }, { "name": "KANSAS", "code": "KS" }, { "name": "KENTUCKY", "code": "KY" }, { "name": "LOUISIANA", "code": "LA" }, { "name": "MASSACHUSETTS", "code": "MA" }, { "name": "MARYLAND", "code": "MD" }, { "name": "MAINE", "code": "ME" }, { "name": "MICHIGAN", "code": "MI" }, { "name": "MINNESOTA", "code": "MN" }, { "name": "MISSOURI", "code": "MO" }, { "name": "MISSISSIPPI", "code": "MS" }, { "name": "MONTANA", "code": "MT" }, { "name": "NORTH CAROLINA", "code": "NC" }, { "name": "NORTH DAKOTA", "code": "ND" }, { "name": "NEBRASKA", "code": "NE" }, { "name": "NEW HAMPSHIRE", "code": "NH" }, { "name": "NEW JERSEY", "code": "NJ" }, { "name": "NEW MEXICO", "code": "NM" }, { "name": "NEVADA", "code": "NV" }, { "name": "NEW YORK", "code": "NY" }, { "name": "OHIO", "code": "OH" }, { "name": "OKLAHOMA", "code": "OK" }, { "name": "OREGON", "code": "OR" }, { "name": "PENNSYLVANIA", "code": "PA" }, { "name": "RHODE ISLAND", "code": "RI" }, { "name": "SOUTH CAROLINA", "code": "SC" }, { "name": "SOUTH DAKOTA", "code": "SD" }, { "name": "TENNESSEE", "code": "TN" }, { "name": "TEXAS", "code": "TX" }, { "name": "UTAH", "code": "UT" }, { "name": "VIRGINIA", "code": "VA" }, { "name": "VERMONT", "code": "VT" }, { "name": "WASHINGTON", "code": "WA" }, { "name": "WISCONSIN", "code": "WI" }, { "name": "WEST VIRGINIA", "code": "WV" }, { "name": "WYOMING", "code": "WY" }, { "name": "Unknown or Invalid Copes Value", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_ZIP", "type": "esriFieldTypeString", "alias": "Zip", "length": 150, "domain": null }, { "name": "FL_COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 150, "domain": { "type": "codedValue", "name": "CountyList", "description": "County Name List", "codedValues": [ { "name": "ALACHUA", "code": "ALACHUA" }, { "name": "BAKER", "code": "BAKER" }, { "name": "BAY", "code": "BAY" }, { "name": "BRADFORD", "code": "BRADFORD" }, { "name": "BREVARD", "code": "BREVARD" }, { "name": "BROWARD", "code": "BROWARD" }, { "name": "CALHOUN", "code": "CALHOUN" }, { "name": "CHARLOTTE", "code": "CHARLOTTE" }, { "name": "CITRUS", "code": "CITRUS" }, { "name": "CLAY", "code": "CLAY" }, { "name": "COLLIER", "code": "COLLIER" }, { "name": "COLUMBIA", "code": "COLUMBIA" }, { "name": "DESOTO", "code": "DESOTO" }, { "name": "DIXIE", "code": "DIXIE" }, { "name": "DUVAL", "code": "DUVAL" }, { "name": "ESCAMBIA", "code": "ESCAMBIA" }, { "name": "FLAGLER", "code": "FLAGLER" }, { "name": "FRANKLIN", "code": "FRANKLIN" }, { "name": "GADSDEN", "code": "GADSDEN" }, { "name": "GILCHRIST", "code": "GILCHRIST" }, { "name": "GLADES", "code": "GLADES" }, { "name": "GULF", "code": "GULF" }, { "name": "HAMILTON", "code": "HAMILTON" }, { "name": "HARDEE", "code": "HARDEE" }, { "name": "HENDRY", "code": "HENDRY" }, { "name": "HERNANDO", "code": "HERNANDO" }, { "name": "HIGHLANDS", "code": "HIGHLANDS" }, { "name": "HILLSBOROUGH", "code": "HILLSBOROUGH" }, { "name": "HOLMES", "code": "HOLMES" }, { "name": "INDIAN RIVER", "code": "INDIAN RIVER" }, { "name": "JACKSON", "code": "JACKSON" }, { "name": "JEFFERSON", "code": "JEFFERSON" }, { "name": "LAFAYETTE", "code": "LAFAYETTE" }, { "name": "LAKE", "code": "LAKE" }, { "name": "LEE", "code": "LEE" }, { "name": "LEON", "code": "LEON" }, { "name": "LEVY", "code": "LEVY" }, { "name": "LIBERTY", "code": "LIBERTY" }, { "name": "MADISON", "code": "MADISON" }, { "name": "MANATEE", "code": "MANATEE" }, { "name": "MARION", "code": "MARION" }, { "name": "MARTIN", "code": "MARTIN" }, { "name": "MIAMI-DADE", "code": "MIAMI-DADE" }, { "name": "MONROE", "code": "MONROE" }, { "name": "NASSAU", "code": "NASSAU" }, { "name": "OKALOOSA", "code": "OKALOOSA" }, { "name": "OKEECHOBEE", "code": "OKEECHOBEE" }, { "name": "ORANGE", "code": "ORANGE" }, { "name": "OSCEOLA", "code": "OSCEOLA" }, { "name": "OUT OF STATE", "code": "OUT OF STATE" }, { "name": "PALM BEACH", "code": "PALM BEACH" }, { "name": "PASCO", "code": "PASCO" }, { "name": "PINELLAS", "code": "PINELLAS" }, { "name": "POLK", "code": "POLK" }, { "name": "PUTNAM", "code": "PUTNAM" }, { "name": "SANTA ROSA", "code": "SANTA ROSA" }, { "name": "SARASOTA", "code": "SARASOTA" }, { "name": "SEMINOLE", "code": "SEMINOLE" }, { "name": "ST. JOHNS", "code": "ST. JOHNS" }, { "name": "ST. LUCIE", "code": "ST. LUCIE" }, { "name": "SUMTER", "code": "SUMTER" }, { "name": "SUWANNEE", "code": "SUWANNEE" }, { "name": "TAYLOR", "code": "TAYLOR" }, { "name": "UNION", "code": "UNION" }, { "name": "VOLUSIA", "code": "VOLUSIA" }, { "name": "WAKULLA", "code": "WAKULLA" }, { "name": "WALTON", "code": "WALTON" }, { "name": "WASHINGTON", "code": "WASHINGTON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_PHONE", "type": "esriFieldTypeString", "alias": "Firm Location Phone Number", "length": 20, "domain": null }, { "name": "FL_STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 100, "domain": { "type": "codedValue", "name": "PLANT_LOCATION_STATUS", "description": "Location Status", "codedValues": [ { "name": "ACTIVE", "code": "ACTIVE" }, { "name": "RETIRED", "code": "RETIRED" }, { "name": "PENDING", "code": "PENDING" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_ROUTE", "type": "esriFieldTypeString", "alias": "Route", "length": 100, "domain": null }, { "name": "FL_DISTRICT", "type": "esriFieldTypeString", "alias": "District", "length": 150, "domain": null }, { "name": "FL_NEMA_NO", "type": "esriFieldTypeString", "alias": "Nema Number", "length": 100, "domain": null }, { "name": "FL_GARDEN_CENTER", "type": "esriFieldTypeString", "alias": "Garden Center", "length": 5, "domain": null }, { "name": "FL_CITRUSNUR_INSP", "type": "esriFieldTypeString", "alias": "Citrus Nursery Inspection", "length": 5, "domain": null }, { "name": "FL_IFA_NO", "type": "esriFieldTypeString", "alias": "IFA Number", "length": 15, "domain": null }, { "name": "FL_RISK", "type": "esriFieldTypeString", "alias": "Risk", "length": 10, "domain": { "type": "codedValue", "name": "PI_BN_Risk", "description": "", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_PCT_FIELDGROWN", "type": "esriFieldTypeDouble", "alias": "Field Grown Percent", "domain": null }, { "name": "FL_PCT_CONTAINERGROWN", "type": "esriFieldTypeDouble", "alias": "Container Grown Percent", "domain": null }, { "name": "FL_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "FL_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "FL_PARCELS", "type": "esriFieldTypeString", "alias": "Parcels", "length": 250, "domain": null }, { "name": "FL_NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "FL_DELETEFLAG", "type": "esriFieldTypeString", "alias": "Delete Flag", "length": 5, "domain": null }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "Creation User", "length": 50, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "EDIT_USER", "type": "esriFieldTypeString", "alias": "Edited By", "length": 50, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "Edited Date", "length": 8, "domain": null }, { "name": "FL_PI_AREA", "type": "esriFieldTypeString", "alias": "Area", "length": 7, "domain": { "type": "codedValue", "name": "PI_AREAS_1", "description": "Plant Inspection Areas", "codedValues": [ { "name": "A1", "code": "A1" }, { "name": "A2", "code": "A2" }, { "name": "A3", "code": "A3" }, { "name": "A4", "code": "A4" }, { "name": "A5", "code": "A5" }, { "name": "A6", "code": "A6" }, { "name": "A7", "code": "A7" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_PI_REGION", "type": "esriFieldTypeString", "alias": "Region", "length": 9, "domain": { "type": "codedValue", "name": "Region", "description": "Plant Inspection Regions", "codedValues": [ { "name": "R1", "code": "R1" }, { "name": "R2", "code": "R2" }, { "name": "R3", "code": "R3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FL_SPECIALTY", "type": "esriFieldTypeString", "alias": "Secialty", "length": 50, "domain": { "type": "codedValue", "name": "PI_SPECIALTY", "description": "Specialties for a Nursery location", "codedValues": [ { "name": "BULBS/CORMS", "code": "BULBS/CORMS" }, { "name": "BROMELIAD", "code": "BROMELIAD" }, { "name": "BONSAI", "code": "BONSAI" }, { "name": "BLUEBERRY/BLACKBERRY", "code": "BLUEBERRY/BLACKBERRY" }, { "name": "AVOCADO", "code": "AVOCADO" }, { "name": "AQUATIC", "code": "AQUATIC" }, { "name": "ANNUAL", "code": "ANNUAL" }, { "name": "FOLIAGE", "code": "FOLIAGE" }, { "name": "FERN", "code": "FERN" }, { "name": "DECIDUOUS FRUIT", "code": "DECIDUOUS FRUIT" }, { "name": "DAYLILY", "code": "DAYLILY" }, { "name": "CITRUS", "code": "CITRUS" }, { "name": "CAMELLIA", "code": "CAMELLIA" }, { "name": "CACTUS", "code": "CACTUS" }, { "name": "LINERS", "code": "LINERS" }, { "name": "HERBS", "code": "HERBS" }, { "name": "TROPICAL FRUIT", "code": "TROPICAL FRUIT" }, { "name": "SHADE TREE", "code": "SHADE TREE" }, { "name": "PALM", "code": "PALM" }, { "name": "ORCHID", "code": "ORCHID" }, { "name": "NATIVE PLANTS", "code": "NATIVE PLANTS" }, { "name": "VEGETABLE TRANSPLANT", "code": "VEGETABLE TRANSPLANT" }, { "name": "TISSUE CULTURE", "code": "TISSUE CULTURE" }, { "name": "TURFGRASS", "code": "TURFGRASS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FL_BN_INSPECTOR", "type": "esriFieldTypeString", "alias": "BN Inspector", "length": 5, "domain": null }, { "name": "FL_LAST_INSPECTION", "type": "esriFieldTypeDate", "alias": "Last Inspection Date", "length": 8, "domain": null }, { "name": "INTERGRATION_METADATA", "type": "esriFieldTypeString", "alias": "INTERGRATION_METADATA", "length": 255, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "UUID_110", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1419_FL_FIRM", "fields": "FL_FIRM_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_110", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FL_LOC_NO", "fields": "FL_LOC_NO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S48_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DPI_PI_ADMIN.PI_BN_CertificationType", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8D70ABF9-D9A8-49C1-95EE-DE803DB5332C}" }, { "id": 1, "name": "DPI_PI_ADMIN.PI_Firm", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "FL_FIRM_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1C757A2-C507-4A3F-9B39-D4FF4EE4B4CE}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape.STArea()", "shapeLengthFieldName": "Shape.STLength()", "units": "esriMeters", "mapUnits": {"uwkid": 9001} }, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1639750273000 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" } ], "tables": [ { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 14, "name": "QC390_Compliant_Stock_Dealers", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FL_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "BN", "type": "esriFieldTypeString", "alias": "BN", "length": 100, "domain": null }, { "name": "Reg", "type": "esriFieldTypeString", "alias": "Reg", "length": 30, "domain": null }, { "name": "FL_FIRM_NAME", "type": "esriFieldTypeString", "alias": "FL_FIRM_NAME", "length": 250, "domain": null }, { "name": "Mailing_Address", "type": "esriFieldTypeString", "alias": "Mailing_Address", "length": 703, "domain": null }, { "name": "LOCATION_NO", "type": "esriFieldTypeString", "alias": "LOCATION_NO", "length": 30, "domain": null }, { "name": "Physical_Address", "type": "esriFieldTypeString", "alias": "Physical_Address", "length": 703, "domain": null }, { "name": "Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "length": 20, "domain": null }, { "name": "Compliance_Review_Date", "type": "esriFieldTypeDate", "alias": "Compliance_Review_Date", "length": 8, "domain": null }, { "name": "Last_Reviewed", "type": "esriFieldTypeDate", "alias": "Last_Reviewed", "length": 8, "domain": null }, { "name": "Issued", "type": "esriFieldTypeDate", "alias": "Issued", "length": 8, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "GlobalID" ], "OIDFieldContainsHashValue": true }, "maxUniqueIDCount": 100000, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 15, "name": "QC390_Compliant_Nurseries", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FL_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGUID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "BN", "type": "esriFieldTypeString", "alias": "BN", "length": 100, "domain": null }, { "name": "Reg", "type": "esriFieldTypeString", "alias": "Reg", "length": 30, "domain": null }, { "name": "FL_FIRM_NAME", "type": "esriFieldTypeString", "alias": "FL_FIRM_NAME", "length": 250, "domain": null }, { "name": "Mailing_Address", "type": "esriFieldTypeString", "alias": "Mailing_Address", "length": 703, "domain": null }, { "name": "LOCATION_NO", "type": "esriFieldTypeString", "alias": "LOCATION_NO", "length": 30, "domain": null }, { "name": "Physical_Address", "type": "esriFieldTypeString", "alias": "Physical_Address", "length": 703, "domain": null }, { "name": "Telephone", "type": "esriFieldTypeString", "alias": "Telephone", "length": 20, "domain": null }, { "name": "Compliance_Review_Date", "type": "esriFieldTypeDate", "alias": "Compliance_Review_Date", "length": 8, "domain": null }, { "name": "Last_Reviewed", "type": "esriFieldTypeDate", "alias": "Last_Reviewed", "length": 8, "domain": null }, { "name": "Issued", "type": "esriFieldTypeDate", "alias": "Issued", "length": 8, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "uniqueIdInfo": { "type": "simple", "fields": [ "GlobalID" ], "OIDFieldContainsHashValue": true }, "maxUniqueIDCount": 100000, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Certification", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CT_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "CT_FIRM_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Firm Global ID", "length": 38, "domain": null }, { "name": "CT_LOC_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Firm Location Global ID", "length": 38, "domain": null }, { "name": "CT_FIRM_NO", "type": "esriFieldTypeInteger", "alias": "Firm Number", "domain": null }, { "name": "CT_FIRM_NAME", "type": "esriFieldTypeString", "alias": "Firm Name", "length": 250, "domain": null }, { "name": "CT_FIRM_TYPE", "type": "esriFieldTypeString", "alias": "Firm Type", "length": 100, "domain": { "type": "codedValue", "name": "PI_BN_FirmTypes", "description": "", "codedValues": [ { "name": "Nursery-Retail", "code": "NURSERY-RETAIL" }, { "name": "Nursery-Wholesale", "code": "NURSERY-WHOLESALE" }, { "name": "Nursery-Retail & Wholesale", "code": "NURSERY-RETAIL & WHOLESALE" }, { "name": "Nursery-Exempt", "code": "NURSERY-EXEMPT" }, { "name": "Stock Dealer-Retail", "code": "STOCK DEALER-RETAIL" }, { "name": "Stock Dealer-Wholesale", "code": "STOCK DEALER-WHOLESALE" }, { "name": "Stock Dealer-Retail & Wholesale", "code": "STOCK DEALER-RETAIL & WHOLESALE" }, { "name": "Stock Dealer-Exempt", "code": "STOCK DEALER-EXEMPT" }, { "name": "Unregistered-Retail", "code": "UNREGISTERED-RETAIL" }, { "name": "Unregistered-Wholesale", "code": "UNREGISTERED-WHOLESALE" }, { "name": "Unregistered-Retail & Wholesale", "code": "UNREGISTERED-RETAIL & WHOLESALE" }, { "name": "Unregistered-Exempt", "code": "UNREGISTERED-EXEMPT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CT_CERT_TYPE", "type": "esriFieldTypeString", "alias": "Certification Type", "length": 50, "domain": null }, { "name": "CT_CA", "type": "esriFieldTypeString", "alias": "Locaton Number", "length": 50, "domain": null }, { "name": "CT_CA_EXPDATE", "type": "esriFieldTypeDate", "alias": "Certification Expiration Date", "length": 8, "domain": null }, { "name": "POTSIZE", "type": "esriFieldTypeString", "alias": "Pot Size", "length": 2000, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CT_NOTES", "type": "esriFieldTypeString", "alias": "CT_NOTES", "length": 500, "domain": null } ], "indexes": [ { "name": "UUID_95", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G995CT_LOC_GLOBA", "fields": "CT_LOC_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_95", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PI_BN_PlantSpecies", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B2422197-2FC9-4FB0-A879-C83EA186DE06}" }, { "id": 0, "name": "DPI_PI_ADMIN.PI_FirmLocations", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "CT_LOC_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8D70ABF9-D9A8-49C1-95EE-DE803DB5332C}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1639746350000 }, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 3, "name": "PLANT_LIST_LU", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Genus", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Genus", "type": "esriFieldTypeString", "alias": "Genius", "length": 255, "domain": null }, { "name": "Species", "type": "esriFieldTypeString", "alias": "Species", "length": 255, "domain": null }, { "name": "subspecies", "type": "esriFieldTypeString", "alias": "subspecies", "length": 255, "domain": null }, { "name": "variety", "type": "esriFieldTypeString", "alias": "variety", "length": 255, "domain": null }, { "name": "cultivar", "type": "esriFieldTypeString", "alias": "cultivar", "length": 255, "domain": null }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "length": 3, "domain": { "type": "codedValue", "name": "PI_BN_YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Hybrid", "type": "esriFieldTypeString", "alias": "Hybrid", "length": 1, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_100", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1000Genus2", "fields": "Genus,Species,subspecies,variety,cultivar", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_100", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1639747020000 }, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 4, "name": "Plant Species", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PS_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PS_CERTTYPE_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Certification Global Id", "length": 38, "domain": null }, { "name": "PS_FIRM_NO", "type": "esriFieldTypeInteger", "alias": "Firm Number", "domain": null }, { "name": "PS_FIRM_NAME", "type": "esriFieldTypeString", "alias": "Firm Name", "length": 250, "domain": null }, { "name": "PS_FIRM_TYPE", "type": "esriFieldTypeString", "alias": "Firm Type", "length": 100, "domain": { "type": "codedValue", "name": "PI_BN_FirmTypes", "description": "", "codedValues": [ { "name": "Nursery-Retail", "code": "NURSERY-RETAIL" }, { "name": "Nursery-Wholesale", "code": "NURSERY-WHOLESALE" }, { "name": "Nursery-Retail & Wholesale", "code": "NURSERY-RETAIL & WHOLESALE" }, { "name": "Nursery-Exempt", "code": "NURSERY-EXEMPT" }, { "name": "Stock Dealer-Retail", "code": "STOCK DEALER-RETAIL" }, { "name": "Stock Dealer-Wholesale", "code": "STOCK DEALER-WHOLESALE" }, { "name": "Stock Dealer-Retail & Wholesale", "code": "STOCK DEALER-RETAIL & WHOLESALE" }, { "name": "Stock Dealer-Exempt", "code": "STOCK DEALER-EXEMPT" }, { "name": "Unregistered-Retail", "code": "UNREGISTERED-RETAIL" }, { "name": "Unregistered-Wholesale", "code": "UNREGISTERED-WHOLESALE" }, { "name": "Unregistered-Retail & Wholesale", "code": "UNREGISTERED-RETAIL & WHOLESALE" }, { "name": "Unregistered-Exempt", "code": "UNREGISTERED-EXEMPT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PS_FIRM_LOC_NO", "type": "esriFieldTypeInteger", "alias": "Firm Location Number", "domain": null }, { "name": "PS_FIRM_LOC_NAME", "type": "esriFieldTypeString", "alias": "Firm Location Name", "length": 250, "domain": null }, { "name": "PS_FIRM_LOC_TYPE", "type": "esriFieldTypeString", "alias": "Firm Location Type", "length": 100, "domain": null }, { "name": "PS_CERT_TYPE", "type": "esriFieldTypeString", "alias": "Certification Type", "length": 50, "domain": null }, { "name": "PS_GENUS", "type": "esriFieldTypeString", "alias": "Plant Genius", "length": 250, "domain": null }, { "name": "PS_SPECIES", "type": "esriFieldTypeString", "alias": "Plant Species", "length": 250, "domain": null }, { "name": "PS_STATUS", "type": "esriFieldTypeString", "alias": "Plant Certification Status", "length": 8, "domain": { "type": "codedValue", "name": "PI_BN_SpeciesStatus", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Inactive", "code": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PS_FROMDATE", "type": "esriFieldTypeDate", "alias": "Plant Certification Status From Date", "length": 8, "domain": null }, { "name": "PS_TODATE", "type": "esriFieldTypeDate", "alias": "Plant Certification Status To Date", "length": 8, "domain": null }, { "name": "CREATE_USER", "type": "esriFieldTypeString", "alias": "Creation User", "length": 50, "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "EDIT_USER", "type": "esriFieldTypeString", "alias": "Edited By", "length": 50, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "Edited Date", "length": 8, "domain": null }, { "name": "PS_SUBSPECIES", "type": "esriFieldTypeString", "alias": "Plant Subspecies", "length": 255, "domain": null }, { "name": "PS_VARIETY", "type": "esriFieldTypeString", "alias": "Plant Variety", "length": 255, "domain": null }, { "name": "PS_CULTIVAR", "type": "esriFieldTypeString", "alias": "Plant Cultivar", "length": 255, "domain": null }, { "name": "FIRM_GLOBALID", "type": "esriFieldTypeGUID", "alias": "FIRM_GlobalID", "length": 38, "domain": null }, { "name": "LOCATION_GLOBALID", "type": "esriFieldTypeGUID", "alias": "Location_GlobalID", "length": 38, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_101", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1001PS_CERTTYPE", "fields": "PS_CERTTYPE_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_101", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "PI_BN_CertificationType", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "PS_CERTTYPE_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B2422197-2FC9-4FB0-A879-C83EA186DE06}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1639746357000 }, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" }, { "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 5, "name": "Firm", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PI_FIRM_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PI_FIRM_NO", "type": "esriFieldTypeInteger", "alias": "Firm Number", "domain": null }, { "name": "PI_FIRM_NAME", "type": "esriFieldTypeString", "alias": "Firm Name", "length": 250, "domain": null }, { "name": "PI_FIRM_TYPE", "type": "esriFieldTypeString", "alias": "Firm Type", "length": 100, "domain": { "type": "codedValue", "name": "PI_FirmTypes", "description": "", "codedValues": [ { "name": "NURSERY", "code": "NURSERY" }, { "name": "STOCK DEALER", "code": "STOCK DEALER" }, { "name": "UNREGISTERED", "code": "UNREGISTERED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PI_FIRM_STATUS", "type": "esriFieldTypeString", "alias": "Firm Status", "length": 100, "domain": { "type": "codedValue", "name": "PI_STATUS", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Delinquent", "code": "Delinquent" }, { "name": "OB Inspector", "code": "OB Inspector" }, { "name": "OB Owner", "code": "OB Owner" }, { "name": "OB Administrative", "code": "OB Administrative" }, { "name": "Pending", "code": "Pending" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PI_FIRM_OWNERNAME", "type": "esriFieldTypeString", "alias": "Firm Owner Name", "length": 250, "domain": null }, { "name": "PI_FIRM_PHONE", "type": "esriFieldTypeString", "alias": "Firm Phone Number", "length": 20, "domain": null }, { "name": "PI_FIRM_EMAIL", "type": "esriFieldTypeString", "alias": "Firm Email", "length": 50, "domain": null }, { "name": "PI_FIRM_MAILINGADD", "type": "esriFieldTypeString", "alias": "Firm Mailing Address", "length": 250, "domain": null }, { "name": "PI_FIRM_CITY", "type": "esriFieldTypeString", "alias": "City", "length": 150, "domain": null }, { "name": "PI_FIRM_STATE", "type": "esriFieldTypeString", "alias": "State", "length": 150, "domain": { "type": "codedValue", "name": "StatesList", "description": "States List", "codedValues": [ { "name": "ALASKA", "code": "AK" }, { "name": "ALABAMA", "code": "AL" }, { "name": "ARKANSAS", "code": "AR" }, { "name": "ARIZONA", "code": "AZ" }, { "name": "CALIFORNIA", "code": "CA" }, { "name": "COLORADO", "code": "CO" }, { "name": "CONNECTICUT", "code": "CT" }, { "name": "DISTRICT OF COLUMBIA", "code": "DC" }, { "name": "DELAWARE", "code": "DE" }, { "name": "FLORIDA", "code": "FL" }, { "name": "GEORGIA", "code": "GA" }, { "name": "HAWAII", "code": "HI" }, { "name": "IOWA", "code": "IA" }, { "name": "IDAHO", "code": "ID" }, { "name": "ILLINOIS", "code": "IL" }, { "name": "INDIANA", "code": "IN" }, { "name": "KANSAS", "code": "KS" }, { "name": "KENTUCKY", "code": "KY" }, { "name": "LOUISIANA", "code": "LA" }, { "name": "MASSACHUSETTS", "code": "MA" }, { "name": "MARYLAND", "code": "MD" }, { "name": "MAINE", "code": "ME" }, { "name": "MICHIGAN", "code": "MI" }, { "name": "MINNESOTA", "code": "MN" }, { "name": "MISSOURI", "code": "MO" }, { "name": "MISSISSIPPI", "code": "MS" }, { "name": "MONTANA", "code": "MT" }, { "name": "NORTH CAROLINA", "code": "NC" }, { "name": "NORTH DAKOTA", "code": "ND" }, { "name": "NEBRASKA", "code": "NE" }, { "name": "NEW HAMPSHIRE", "code": "NH" }, { "name": "NEW JERSEY", "code": "NJ" }, { "name": "NEW MEXICO", "code": "NM" }, { "name": "NEVADA", "code": "NV" }, { "name": "NEW YORK", "code": "NY" }, { "name": "OHIO", "code": "OH" }, { "name": "OKLAHOMA", "code": "OK" }, { "name": "OREGON", "code": "OR" }, { "name": "PENNSYLVANIA", "code": "PA" }, { "name": "RHODE ISLAND", "code": "RI" }, { "name": "SOUTH CAROLINA", "code": "SC" }, { "name": "SOUTH DAKOTA", "code": "SD" }, { "name": "TENNESSEE", "code": "TN" }, { "name": "TEXAS", "code": "TX" }, { "name": "UTAH", "code": "UT" }, { "name": "VIRGINIA", "code": "VA" }, { "name": "VERMONT", "code": "VT" }, { "name": "WASHINGTON", "code": "WA" }, { "name": "WISCONSIN", "code": "WI" }, { "name": "WEST VIRGINIA", "code": "WV" }, { "name": "WYOMING", "code": "WY" }, { "name": "Unknown or Invalid Copes Value", "code": "ZZ" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PI_FIRM_ZIP", "type": "esriFieldTypeString", "alias": "Zip", "length": 150, "domain": null }, { "name": "PI_FIRM_COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 150, "domain": { "type": "codedValue", "name": "CountyList", "description": "County Name List", "codedValues": [ { "name": "ALACHUA", "code": "ALACHUA" }, { "name": "BAKER", "code": "BAKER" }, { "name": "BAY", "code": "BAY" }, { "name": "BRADFORD", "code": "BRADFORD" }, { "name": "BREVARD", "code": "BREVARD" }, { "name": "BROWARD", "code": "BROWARD" }, { "name": "CALHOUN", "code": "CALHOUN" }, { "name": "CHARLOTTE", "code": "CHARLOTTE" }, { "name": "CITRUS", "code": "CITRUS" }, { "name": "CLAY", "code": "CLAY" }, { "name": "COLLIER", "code": "COLLIER" }, { "name": "COLUMBIA", "code": "COLUMBIA" }, { "name": "DESOTO", "code": "DESOTO" }, { "name": "DIXIE", "code": "DIXIE" }, { "name": "DUVAL", "code": "DUVAL" }, { "name": "ESCAMBIA", "code": "ESCAMBIA" }, { "name": "FLAGLER", "code": "FLAGLER" }, { "name": "FRANKLIN", "code": "FRANKLIN" }, { "name": "GADSDEN", "code": "GADSDEN" }, { "name": "GILCHRIST", "code": "GILCHRIST" }, { "name": "GLADES", "code": "GLADES" }, { "name": "GULF", "code": "GULF" }, { "name": "HAMILTON", "code": "HAMILTON" }, { "name": "HARDEE", "code": "HARDEE" }, { "name": "HENDRY", "code": "HENDRY" }, { "name": "HERNANDO", "code": "HERNANDO" }, { "name": "HIGHLANDS", "code": "HIGHLANDS" }, { "name": "HILLSBOROUGH", "code": "HILLSBOROUGH" }, { "name": "HOLMES", "code": "HOLMES" }, { "name": "INDIAN RIVER", "code": "INDIAN RIVER" }, { "name": "JACKSON", "code": "JACKSON" }, { "name": "JEFFERSON", "code": "JEFFERSON" }, { "name": "LAFAYETTE", "code": "LAFAYETTE" }, { "name": "LAKE", "code": "LAKE" }, { "name": "LEE", "code": "LEE" }, { "name": "LEON", "code": "LEON" }, { "name": "LEVY", "code": "LEVY" }, { "name": "LIBERTY", "code": "LIBERTY" }, { "name": "MADISON", "code": "MADISON" }, { "name": "MANATEE", "code": "MANATEE" }, { "name": "MARION", "code": "MARION" }, { "name": "MARTIN", "code": "MARTIN" }, { "name": "MIAMI-DADE", "code": "MIAMI-DADE" }, { "name": "MONROE", "code": "MONROE" }, { "name": "NASSAU", "code": "NASSAU" }, { "name": "OKALOOSA", "code": "OKALOOSA" }, { "name": "OKEECHOBEE", "code": "OKEECHOBEE" }, { "name": "ORANGE", "code": "ORANGE" }, { "name": "OSCEOLA", "code": "OSCEOLA" }, { "name": "OUT OF STATE", "code": "OUT OF STATE" }, { "name": "PALM BEACH", "code": "PALM BEACH" }, { "name": "PASCO", "code": "PASCO" }, { "name": "PINELLAS", "code": "PINELLAS" }, { "name": "POLK", "code": "POLK" }, { "name": "PUTNAM", "code": "PUTNAM" }, { "name": "SANTA ROSA", "code": "SANTA ROSA" }, { "name": "SARASOTA", "code": "SARASOTA" }, { "name": "SEMINOLE", "code": "SEMINOLE" }, { "name": "ST. JOHNS", "code": "ST. JOHNS" }, { "name": "ST. LUCIE", "code": "ST. LUCIE" }, { "name": "SUMTER", "code": "SUMTER" }, { "name": "SUWANNEE", "code": "SUWANNEE" }, { "name": "TAYLOR", "code": "TAYLOR" }, { "name": "UNION", "code": "UNION" }, { "name": "VOLUSIA", "code": "VOLUSIA" }, { "name": "WAKULLA", "code": "WAKULLA" }, { "name": "WALTON", "code": "WALTON" }, { "name": "WASHINGTON", "code": "WASHINGTON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PI_FIRM_COUNTRY", "type": "esriFieldTypeString", "alias": "Country", "length": 150, "domain": { "type": "codedValue", "name": "CountryList", "description": "Country List", "codedValues": [ { "name": "AFGHANISTAN", "code": "AFGHANISTAN" }, { "name": "ALGERIA", "code": "ALGERIA" }, { "name": "ALBANIA", "code": "ALBANIA" }, { "name": "AMERICAN SAMOA", "code": "AMERICAN SAMOA" }, { "name": "ANDORRA", "code": "ANDORRA" }, { "name": "ANGOLA", "code": "ANGOLA" }, { "name": "ARGENTINA", "code": "ARGENTINA" }, { "name": "ARMENIA", "code": "ARMENIA" }, { "name": "ARUBA", "code": "ARUBA" }, { "name": "ASCENSION ISLAND", "code": "ASCENSION ISLAND" }, { "name": "AUSTRALIA", "code": "AUSTRALIA" }, { "name": "AUSTRIA", "code": "AUSTRIA" }, { "name": "BAHRAIN", "code": "BAHRAIN" }, { "name": "BANGLADESH", "code": "BANGLADESH" }, { "name": "BELARUS", "code": "BELARUS" }, { "name": "BELGIUM", "code": "BELGIUM" }, { "name": "BELIZE", "code": "BELIZE" }, { "name": "BENIN", "code": "BENIN" }, { "name": "BOLIVIA", "code": "BOLIVIA" }, { "name": "BOSNIA AND HERZEGOVINA", "code": "BOSNIA AND HERZEGOVINA" }, { "name": "BRAZIL", "code": "BRAZIL" }, { "name": "BULGARIA", "code": "BULGARIA" }, { "name": "BURUNDI", "code": "BURUNDI" }, { "name": "CAMEROON", "code": "CAMEROON" }, { "name": "CANADA", "code": "CANADA" }, { "name": "CAPE VERDE IS.", "code": "CAPE VERDE IS." }, { "name": "CENTRAL AFRICAN REPUBLIC", "code": "CENTRAL AFRICAN REPUBLIC" }, { "name": "CHAD", "code": "CHAD" }, { "name": "CHILE", "code": "CHILE" }, { "name": "CHINA", "code": "CHINA" }, { "name": "COLUMBIA", "code": "COLUMBIA" }, { "name": "COMOROS", "code": "COMOROS" }, { "name": "CONGO (BRAZZAVILLE)", "code": "CONGO (BRAZZAVILLE)" }, { "name": "COSTA RICA", "code": "COSTA RICA" }, { "name": "CROATIA", "code": "CROATIA" }, { "name": "CYPRUS", "code": "CYPRUS" }, { "name": "CZECHOSLOVAKIA", "code": "CZECHOSLOVAKIA" }, { "name": "DENMARK", "code": "DENMARK" }, { "name": "ECUADOR", "code": "ECUADOR" }, { "name": "EGYPT", "code": "EGYPT" }, { "name": "EL SALVADOR", "code": "EL SALVADOR" }, { "name": "EQUATORIAL GUINEA, REPUBLIC", "code": "EQUATORIAL GUINEA, REPUBLIC" }, { "name": "ETHIOPIA", "code": "ETHIOPIA" }, { "name": "FALKLAND ISLANDS", "code": "FALKLAND ISLANDS" }, { "name": "FIJI", "code": "FIJI" }, { "name": "FINLAND", "code": "FINLAND" }, { "name": "FRANCE", "code": "FRANCE" }, { "name": "FRENCH ANTILLES", "code": "FRENCH ANTILLES" }, { "name": "FRENCH GUIANA", "code": "FRENCH GUIANA" }, { "name": "FRENCH POLYNESIA", "code": "FRENCH POLYNESIA" }, { "name": "GABON", "code": "GABON" }, { "name": "GAMBIA", "code": "GAMBIA" }, { "name": "GEORGIA", "code": "GEORGIA" }, { "name": "GERMANY, FEDERAL REPUBLIC OF", "code": "GERMANY, FEDERAL REPUBLIC OF" }, { "name": "GIBRALTAR", "code": "GIBRALTAR" }, { "name": "GREECE", "code": "GREECE" }, { "name": "GREENLAND", "code": "GREENLAND" }, { "name": "GUADELOUPE", "code": "GUADELOUPE" }, { "name": "GUAM", "code": "GUAM" }, { "name": "GUATEMALA", "code": "GUATEMALA" }, { "name": "GUINEA-BISSAU", "code": "GUINEA-BISSAU" }, { "name": "GUYANA", "code": "GUYANA" }, { "name": "HAITI", "code": "HAITI" }, { "name": "HOLLAND", "code": "HOLLAND" }, { "name": "HONDURAS", "code": "HONDURAS" }, { "name": "HONG KONG", "code": "HONG KONG" }, { "name": "HUNGARY", "code": "HUNGARY" }, { "name": "ICELAND", "code": "ICELAND" }, { "name": "INDIA", "code": "INDIA" }, { "name": "INDONESIA", "code": "INDONESIA" }, { "name": "IRAN", "code": "IRAN" }, { "name": "IRELAND", "code": "IRELAND" }, { "name": "ISRAEL", "code": "ISRAEL" }, { "name": "ITALY", "code": "ITALY" }, { "name": "IVORY COAST", "code": "IVORY COAST" }, { "name": "JAPAN", "code": "JAPAN" }, { "name": "JORDAN", "code": "JORDAN" }, { "name": "KENYA", "code": "KENYA" }, { "name": "KOREA, REPUBLIC OF", "code": "KOREA, REPUBLIC OF" }, { "name": "KUWAIT", "code": "KUWAIT" }, { "name": "LEBANON", "code": "LEBANON" }, { "name": "LOSOTHO", "code": "LOSOTHO" }, { "name": "LIBERIA", "code": "LIBERIA" }, { "name": "LIBYA", "code": "LIBYA" }, { "name": "LIECHTENSTEIN", "code": "LIECHTENSTEIN" }, { "name": "LUXEMBOURG", "code": "LUXEMBOURG" }, { "name": "MACAU", "code": "MACAU" }, { "name": "MACEDONIA", "code": "MACEDONIA" }, { "name": "MADAGASCAR", "code": "MADAGASCAR" }, { "name": "MALAYSIA", "code": "MALAYSIA" }, { "name": "MEXICO", "code": "MEXICO" }, { "name": "NAMIBIA", "code": "NAMIBIA" }, { "name": "NETHERLANDS ANTILLES", "code": "NETHERLANDS ANTILLES" }, { "name": "NEW ZEALAND", "code": "NEW ZEALAND" }, { "name": "NORTH KOREA", "code": "NORTH KOREA" }, { "name": "OMAN", "code": "OMAN" }, { "name": "PALAU", "code": "PALAU" }, { "name": "PARAGUAY", "code": "PARAGUAY" }, { "name": "PHILIPPINES", "code": "PHILIPPINES" }, { "name": "PUERTO RICO", "code": "PUERTO RICO" }, { "name": "ROMANIA", "code": "ROMANIA" }, { "name": "SAIPAN", "code": "SAIPAN" }, { "name": "SAUDI ARABIA", "code": "SAUDI ARABIA" }, { "name": "SLOVENIA", "code": "SLOVENIA" }, { "name": "SOUTH AFRICA", "code": "SOUTH AFRICA" }, { "name": "SRI LANKA", "code": "SRI LANKA" }, { "name": "ST. PIERRE AND MIQUELON", "code": "ST. PIERRE AND MIQUELON" }, { "name": "SWAZILAND", "code": "SWAZILAND" }, { "name": "TANZANIA", "code": "TANZANIA" }, { "name": "THAILAND", "code": "THAILAND" }, { "name": "TURKEY", "code": "TURKEY" }, { "name": "UKRAINE", "code": "UKRAINE" }, { "name": "UNITED KINGDOM", "code": "UNITED KINGDOM" }, { "name": "YUGOSLAVIA", "code": "YUGOSLAVIA" }, { "name": "ZAIRE", "code": "ZAIRE" }, { "name": "ZIMBABWE", "code": "ZIMBABWE" }, { "name": "USA", "code": "USA" }, { "name": "BARBADOS", "code": "BARBADOS" }, { "name": "DOMINICAN REPUBLIC", "code": "DOMINICAN REPUBLIC" }, { "name": "CENTRAL AMERICA", "code": "CENTRAL AMERICA" }, { "name": "SOUTH AMERICA", "code": "SOUTH AMERICA" }, { "name": "PERSIA", "code": "PERSIA" }, { "name": "VIETNAM", "code": "VIETNAM" }, { "name": "AZERBAIJAN", "code": "AZERBAIJAN" }, { "name": "BAHAMAS", "code": "BAHAMAS" }, { "name": "ANGUILLA", "code": "ANGUILLA" }, { "name": "ANTARCTICA", "code": "ANTARCTICA" }, { "name": "ANTIGUA AND BARBUDA", "code": "ANTIGUA AND BARBUDA" }, { "name": "BAKER ISLAND", "code": "BAKER ISLAND" }, { "name": "BERMUDA", "code": "BERMUDA" }, { "name": "BHUTAN", "code": "BHUTAN" }, { "name": "BOTSWANA", "code": "BOTSWANA" }, { "name": "BOUVET ISLAND", "code": "BOUVET ISLAND" }, { "name": "BRITISH INDIAN OCEAN TERRITORY", "code": "BRITISH INDIAN OCEAN TERRITORY" }, { "name": "BURKINA FASO", "code": "BURKINA FASO" }, { "name": "CAMBODIA", "code": "CAMBODIA" }, { "name": "CAYMAN ISLANDS", "code": "CAYMAN ISLANDS" }, { "name": "CHRISTMAS ISLAND", "code": "CHRISTMAS ISLAND" }, { "name": "COCOS(KEELING) ISLANDS", "code": "COCOS(KEELING) ISLANDS" }, { "name": "CONGO (KINSHASA)", "code": "CONGO (KINSHASA)" }, { "name": "COOK ISLANDS", "code": "COOK ISLANDS" }, { "name": "COTE D'IVOIRE", "code": "COTE D'IVOIRE" }, { "name": "CUBA", "code": "CUBA" }, { "name": "DJIBOUTI", "code": "DJIBOUTI" }, { "name": "DOMINICA", "code": "DOMINICA" }, { "name": "ERITREA", "code": "ERITREA" }, { "name": "ESTONIA", "code": "ESTONIA" }, { "name": "FAROE ISLANDS", "code": "FAROE ISLANDS" }, { "name": "FRENCH SOUTHERN TERRITORIES", "code": "FRENCH SOUTHERN TERRITORIES" }, { "name": "GAZA STRIP", "code": "GAZA STRIP" }, { "name": "GHANA", "code": "GHANA" }, { "name": "GRENADA", "code": "GRENADA" }, { "name": "GUINEA", "code": "GUINEA" }, { "name": "HEARD AND MCDONALD ISLANDS", "code": "HEARD AND MCDONALD ISLANDS" }, { "name": "HOWLAND ISLAND", "code": "HOWLAND ISLAND" }, { "name": "IRAQ", "code": "IRAQ" }, { "name": "JAMAICA", "code": "JAMAICA" }, { "name": "JAN MAYEN ISLAND", "code": "JAN MAYEN ISLAND" }, { "name": "JARVIS ISLAND", "code": "JARVIS ISLAND" }, { "name": "JOHNSTON ATOLL", "code": "JOHNSTON ATOLL" }, { "name": "KAZAKHSTAN", "code": "KAZAKHSTAN" }, { "name": "KINGMAN REEF", "code": "KINGMAN REEF" }, { "name": "KYRGYZSTAN", "code": "KYRGYZSTAN" }, { "name": "LAOS", "code": "LAOS" }, { "name": "KIRIBATI", "code": "KIRIBATI" }, { "name": "KOREA, NORTH", "code": "KOREA, NORTH" }, { "name": "KOREA, SOUTH", "code": "KOREA, SOUTH" }, { "name": "LATVIA", "code": "LATVIA" }, { "name": "LESOTHO", "code": "LESOTHO" }, { "name": "LITHUANIA", "code": "LITHUANIA" }, { "name": "MALAWI", "code": "MALAWI" }, { "name": "MARTINIQUE", "code": "MARTINIQUE" }, { "name": "MONACO", "code": "MONACO" }, { "name": "MOROCCO", "code": "MOROCCO" }, { "name": "MALDIVES", "code": "MALDIVES" }, { "name": "MALI", "code": "MALI" }, { "name": "MALTA", "code": "MALTA" }, { "name": "MARSHALL ISLANDS", "code": "MARSHALL ISLANDS" }, { "name": "MAURITANIA", "code": "MAURITANIA" }, { "name": "MAURITIUS", "code": "MAURITIUS" }, { "name": "MICRONESIA", "code": "MICRONESIA" }, { "name": "MIDWAY ISLANDS", "code": "MIDWAY ISLANDS" }, { "name": "MOLDOVA", "code": "MOLDOVA" }, { "name": "MONGOLIA", "code": "MONGOLIA" }, { "name": "MONTSERRAT", "code": "MONTSERRAT" }, { "name": "MOZAMBIQUE", "code": "MOZAMBIQUE" }, { "name": "MYANMAR", "code": "MYANMAR" }, { "name": "NETHERLANDS", "code": "NETHERLANDS" }, { "name": "NEW CALEDONIA", "code": "NEW CALEDONIA" }, { "name": "NICARAGUA", "code": "NICARAGUA" }, { "name": "NIGERIA", "code": "NIGERIA" }, { "name": "NAURU", "code": "NAURU" }, { "name": "NAVASSA ISLAND", "code": "NAVASSA ISLAND" }, { "name": "NEPAL", "code": "NEPAL" }, { "name": "NORWAY", "code": "NORWAY" }, { "name": "NIUE", "code": "NIUE" }, { "name": "NORFOLK ISLAND", "code": "NORFOLK ISLAND" }, { "name": "NORTHERN MARIANA ISLANDS", "code": "NORTHERN MARIANA ISLANDS" }, { "name": "PAKISTAN", "code": "PAKISTAN" }, { "name": "PANAMA", "code": "PANAMA" }, { "name": "PERU", "code": "PERU" }, { "name": "POLAND", "code": "POLAND" }, { "name": "PORTUGAL", "code": "PORTUGAL" }, { "name": "QATAR", "code": "QATAR" }, { "name": "PAPUA NEW GUINEA", "code": "PAPUA NEW GUINEA" }, { "name": "PALESTINE", "code": "PALESTINE" }, { "name": "PALMYRA ATOLL", "code": "PALMYRA ATOLL" }, { "name": "PITCAIRN", "code": "PITCAIRN" }, { "name": "REUNION", "code": "REUNION" }, { "name": "RUSSIAN FEDERATION", "code": "RUSSIAN FEDERATION" }, { "name": "RWANDA", "code": "RWANDA" }, { "name": "SAN MARINO", "code": "SAN MARINO" }, { "name": "SAO TOME AD PRINCIPE", "code": "SAO TOME AD PRINCIPE" }, { "name": "SENEGAL", "code": "SENEGAL" }, { "name": "ST. KITTS AND NEVIS", "code": "ST. KITTS AND NEVIS" }, { "name": "ST. LUCIA", "code": "ST. LUCIA" }, { "name": "ST. VINCENT AND THE GRENADINES", "code": "ST. VINCENT AND THE GRENADINES" }, { "name": "SAMOA", "code": "SAMOA" }, { "name": "SERBIA AND MONTENEGRO", "code": "SERBIA AND MONTENEGRO" }, { "name": "SEYCHELLES", "code": "SEYCHELLES" }, { "name": "SIERRA LEONE", "code": "SIERRA LEONE" }, { "name": "SINGAPORE", "code": "SINGAPORE" }, { "name": "SOLOMON ISLANDS", "code": "SOLOMON ISLANDS" }, { "name": "SPAIN", "code": "SPAIN" }, { "name": "SLOVAKIA", "code": "SLOVAKIA" }, { "name": "SOMALIA", "code": "SOMALIA" }, { "name": "SOUTH GEORGIA AND SOUTH SANDWICH ISLANDS", "code": "SOUTH GEORGIA AND SOUTH SANDWICH ISLANDS" }, { "name": "SUDAN", "code": "SUDAN" }, { "name": "SURINAM", "code": "SURINAM" }, { "name": "SWEDEN", "code": "SWEDEN" }, { "name": "SWITZERLAND", "code": "SWITZERLAND" }, { "name": "SVALBARD AND JAN MAYEN", "code": "SVALBARD AND JAN MAYEN" }, { "name": "SYRIAN ARAB REPUBLIC", "code": "SYRIAN ARAB REPUBLIC" }, { "name": "TAIWAN", "code": "TAIWAN" }, { "name": "TAJIKISTAN", "code": "TAJIKISTAN" }, { "name": "TIMOR-LESTE", "code": "TIMOR-LESTE" }, { "name": "TOGO", "code": "TOGO" }, { "name": "TOKELAU", "code": "TOKELAU" }, { "name": "TUNISIA", "code": "TUNISIA" }, { "name": "UGANDA", "code": "UGANDA" }, { "name": "UNITED ARAB EMIRATES", "code": "UNITED ARAB EMIRATES" }, { "name": "TONGA", "code": "TONGA" }, { "name": "TURKMENISTAN", "code": "TURKMENISTAN" }, { "name": "TURKS AND CAICOS ISLANDS", "code": "TURKS AND CAICOS ISLANDS" }, { "name": "TUVALU", "code": "TUVALU" }, { "name": "URUGUAY", "code": "URUGUAY" }, { "name": "UNITED STATES MINOR OUTLYING ISLANDS", "code": "UNITED STATES MINOR OUTLYING ISLANDS" }, { "name": "VATICAN CITY", "code": "VATICAN CITY" }, { "name": "VENEZUELA", "code": "VENEZUELA" }, { "name": "YEMEN ARAB REPUBLIC", "code": "YEMEN ARAB REPUBLIC" }, { "name": "UZBEKISTAN", "code": "UZBEKISTAN" }, { "name": "VANUATU", "code": "VANUATU" }, { "name": "VIRGIN ISLANDS, BRITISH", "code": "VIRGIN ISLANDS, BRITISH" }, { "name": "VIRGIN ISLANDS, U.S.", "code": "VIRGIN ISLANDS, U.S." }, { "name": "WALLIS AND FUTUNA ISLANDS", "code": "WALLIS AND FUTUNA ISLANDS" }, { "name": "WAKE ISLAND", "code": "WAKE ISLAND" }, { "name": "WEST BANK", "code": "WEST BANK" }, { "name": "WESTERN SAHARA", "code": "WESTERN SAHARA" }, { "name": "ZAMBIA", "code": "ZAMBIA" }, { "name": "BRUNEI DARUSSALAM", "code": "BRUNEI DARUSSALAM" }, { "name": "MAYOTTE", "code": "MAYOTTE" }, { "name": "ST. HELENA", "code": "ST. HELENA" }, { "name": "NIGER", "code": "NIGER" }, { "name": "TRINIDAD AND TOBAGO", "code": "TRINIDAD AND TOBAGO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PI_NEMA_NO", "type": "esriFieldTypeString", "alias": "Nema Number", "length": 15, "domain": null }, { "name": "PI_IFA_NO", "type": "esriFieldTypeString", "alias": "IFA Number", "length": 15, "domain": null }, { "name": "PI_NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 250, "domain": null }, { "name": "PI_DELETEFLAG", "type": "esriFieldTypeString", "alias": "Delete Flag", "length": 5, "domain": { "type": "codedValue", "name": "PI_YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "CERT_EXPIRE", "type": "esriFieldTypeDate", "alias": "Certificate Experation", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PI_FIRM_PHONE2", "type": "esriFieldTypeString", "alias": "Secondary Phon Number", "length": 20, "domain": null }, { "name": "PI_FIRM_BALANCE_DUE", "type": "esriFieldTypeDouble", "alias": "Payment Balance Due", "domain": null }, { "name": "INTERGRATION_METADATA", "type": "esriFieldTypeString", "alias": "INTERGRATION_METADATA", "length": 255, "domain": null } ], "indexes": [ { "name": "UUID_106", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_106", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PI_FIRM_NO", "fields": "PI_FIRM_NO", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "DPI_PI_ADMIN.PI_FirmLocations", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{F1C757A2-C507-4A3F-9B39-D4FF4EE4B4CE}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1639746284000 }, "serviceItemId": "aef1ca095c7945b8bdba8645cc203426" } ] }