{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "PPP_Stats_County_San_Mateo", "type" : "Feature Layer", "serviceItemId" : "76698b9bbb2143459c739ddf01ee28e1", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1599615137704, "schemaLastEditDate" : 1599615137704, "dataLastEditDate" : 1599615137704 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "GEOMETRY__Area", "shapeLengthFieldName" : "GEOMETRY__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 9244649, "maxScale" : 18055, "extent" : { "xmin" : -13639394.068268878, "ymin" : 4453489.9497764688, "xmax" : -13592375.581257818, "ymax" : 4539105.0386992013, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[76,129,205,191],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.75}}},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Zipcode", "type" : "esriFieldTypeString", "alias" : "Zipcode", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_State", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_CD", "type" : "esriFieldTypeString", "alias" : "CD", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_NAICS_Cod", "type" : "esriFieldTypeInteger", "alias" : "NAICS_Codes_Count_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Employees", "type" : "esriFieldTypeString", "alias" : "Employees_99_or_less", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Employe_1", "type" : "esriFieldTypeString", "alias" : "Employees_100_to_999", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_in_", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_April_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_in1", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_May_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_i_1", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_June_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_i_2", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_July_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_i_3", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_August_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_Tot", "type" : "esriFieldTypeInteger", "alias" : "Loans_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loan_Aggr", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_Low", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loan_Ag_1", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_High", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loan_Ag_2", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_Average", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Top_Lende", "type" : "esriFieldTypeString", "alias" : "Top_Lender", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Top_Len_1", "type" : "esriFieldTypeInteger", "alias" : "Top_Lender_Loans_Issued", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Jobs_Repo", "type" : "esriFieldTypeInteger", "alias" : "Jobs_Reported_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Cooperati", "type" : "esriFieldTypeInteger", "alias" : "Cooperative", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Corporati", "type" : "esriFieldTypeInteger", "alias" : "Corporation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Employee_", "type" : "esriFieldTypeInteger", "alias" : "Employee_Stock_Ownership_Plan(ESOP)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Independe", "type" : "esriFieldTypeInteger", "alias" : "Independent_Contractors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Limited__", "type" : "esriFieldTypeInteger", "alias" : "Limited _Liability_Company(LLC)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Limited_L", "type" : "esriFieldTypeInteger", "alias" : "Limited_Liability_Partnership", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Non_Profi", "type" : "esriFieldTypeInteger", "alias" : "Non_Profit_Childcare_Center", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Non_Pro_1", "type" : "esriFieldTypeInteger", "alias" : "Non_Profit_Organization", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_To_", "type" : "esriFieldTypeInteger", "alias" : "Loans_To_Non_Profits_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Partnersh", "type" : "esriFieldTypeInteger", "alias" : "Partnership", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Professio", "type" : "esriFieldTypeInteger", "alias" : "Professional_Association", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Self_Empl", "type" : "esriFieldTypeInteger", "alias" : "Self_Employed_Individuals", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Sole_Prop", "type" : "esriFieldTypeInteger", "alias" : "Sole_Proprietorship", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Subchapte", "type" : "esriFieldTypeInteger", "alias" : "Subchapter_S_Corporation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Trust", "type" : "esriFieldTypeInteger", "alias" : "Trust", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Tenant_in", "type" : "esriFieldTypeInteger", "alias" : "Tenant_in_Common", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_American_", "type" : "esriFieldTypeString", "alias" : "American_Indian_or_Alaska_Native", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Fem", "type" : "esriFieldTypeInteger", "alias" : "Asian_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Mal", "type" : "esriFieldTypeInteger", "alias" : "Asian_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Una", "type" : "esriFieldTypeInteger", "alias" : "Asian_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_or_", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_or1", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_o_1", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispanic_", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispanic1", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispani_1", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Fem", "type" : "esriFieldTypeInteger", "alias" : "White_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Mal", "type" : "esriFieldTypeInteger", "alias" : "White_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Una", "type" : "esriFieldTypeInteger", "alias" : "White_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_American1", "type" : "esriFieldTypeString", "alias" : "American_Indian_or_Alaska_Native_Total", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Tot", "type" : "esriFieldTypeInteger", "alias" : "Asian_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispani_2", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Tot", "type" : "esriFieldTypeInteger", "alias" : "White_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_o_2", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Female_Ow", "type" : "esriFieldTypeInteger", "alias" : "Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Male_Owne", "type" : "esriFieldTypeInteger", "alias" : "Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Gender_Un", "type" : "esriFieldTypeInteger", "alias" : "Gender_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Gender_On", "type" : "esriFieldTypeInteger", "alias" : "Gender_Only_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Race_and_", "type" : "esriFieldTypeInteger", "alias" : "Race_and_Gender_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Veteran", "type" : "esriFieldTypeInteger", "alias" : "Veteran", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Non_Veter", "type" : "esriFieldTypeInteger", "alias" : "Non_Veteran", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Veteran_S", "type" : "esriFieldTypeInteger", "alias" : "Veteran_Status_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Veteran_1", "type" : "esriFieldTypeInteger", "alias" : "Veteran_Status_Only_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GEOMETRY__Area", "type" : "esriFieldTypeDouble", "alias" : "GEOMETRY__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "GEOMETRY__Length", "type" : "esriFieldTypeDouble", "alias" : "GEOMETRY__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "GEOMETRY__Area_Index", "fields" : "GEOMETRY__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "GEOMETRY__Length_Index", "fields" : "GEOMETRY__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__PPP_STAT__F4B70D85FBB039AB", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_3074.PPP_STATISTICS_PPP_STATS_COUNTY_SAN_MATEO_GEOMETRY_sidx", "fields" : "GEOMETRY", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PPP_Statstics_ALL_csv_Loans_Tot_Index", "fields" : "PPP_Statstics_ALL_csv_Loans_Tot", "isAscending" : true, "isUnique" : false, "description" : "PPP_Statstics_ALL_csv_Loans_Tot_Index", "indexType" : "Attribute" }, { "name" : "PPP_Statstics_ALL_csv_Loan_Aggr_Index", "fields" : "PPP_Statstics_ALL_csv_Loan_Aggr", "isAscending" : true, "isUnique" : false, "description" : "PPP_Statstics_ALL_csv_Loan_Aggr_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "PPP_Statstics_ALL_csv_Zipcode" : null, "PPP_Statstics_ALL_csv_City" : null, "PPP_Statstics_ALL_csv_State" : null, "PPP_Statstics_ALL_csv_CD" : null, "PPP_Statstics_ALL_csv_NAICS_Cod" : null, "PPP_Statstics_ALL_csv_Employees" : null, "PPP_Statstics_ALL_csv_Employe_1" : null, "PPP_Statstics_ALL_csv_Loans_in_" : null, "PPP_Statstics_ALL_csv_Loans_in1" : null, "PPP_Statstics_ALL_csv_Loans_i_1" : null, "PPP_Statstics_ALL_csv_Loans_i_2" : null, "PPP_Statstics_ALL_csv_Loans_i_3" : null, "PPP_Statstics_ALL_csv_Loans_Tot" : null, "PPP_Statstics_ALL_csv_Loan_Aggr" : null, "PPP_Statstics_ALL_csv_Loan_Ag_1" : null, "PPP_Statstics_ALL_csv_Loan_Ag_2" : null, "PPP_Statstics_ALL_csv_Top_Lende" : null, "PPP_Statstics_ALL_csv_Top_Len_1" : null, "PPP_Statstics_ALL_csv_Jobs_Repo" : null, "PPP_Statstics_ALL_csv_Cooperati" : null, "PPP_Statstics_ALL_csv_Corporati" : null, "PPP_Statstics_ALL_csv_Employee_" : null, "PPP_Statstics_ALL_csv_Independe" : null, "PPP_Statstics_ALL_csv_Limited__" : null, "PPP_Statstics_ALL_csv_Limited_L" : null, "PPP_Statstics_ALL_csv_Non_Profi" : null, "PPP_Statstics_ALL_csv_Non_Pro_1" : null, "PPP_Statstics_ALL_csv_Loans_To_" : null, "PPP_Statstics_ALL_csv_Partnersh" : null, "PPP_Statstics_ALL_csv_Professio" : null, "PPP_Statstics_ALL_csv_Self_Empl" : null, "PPP_Statstics_ALL_csv_Sole_Prop" : null, "PPP_Statstics_ALL_csv_Subchapte" : null, "PPP_Statstics_ALL_csv_Trust" : null, "PPP_Statstics_ALL_csv_Tenant_in" : null, "PPP_Statstics_ALL_csv_American_" : null, "PPP_Statstics_ALL_csv_Asian_Fem" : null, "PPP_Statstics_ALL_csv_Asian_Mal" : null, "PPP_Statstics_ALL_csv_Asian_Una" : null, "PPP_Statstics_ALL_csv_Black_or_" : null, "PPP_Statstics_ALL_csv_Black_or1" : null, "PPP_Statstics_ALL_csv_Black_o_1" : null, "PPP_Statstics_ALL_csv_Hispanic_" : null, "PPP_Statstics_ALL_csv_Hispanic1" : null, "PPP_Statstics_ALL_csv_Hispani_1" : null, "PPP_Statstics_ALL_csv_White_Fem" : null, "PPP_Statstics_ALL_csv_White_Mal" : null, "PPP_Statstics_ALL_csv_White_Una" : null, "PPP_Statstics_ALL_csv_American1" : null, "PPP_Statstics_ALL_csv_Asian_Tot" : null, "PPP_Statstics_ALL_csv_Hispani_2" : null, "PPP_Statstics_ALL_csv_White_Tot" : null, "PPP_Statstics_ALL_csv_Black_o_2" : null, "PPP_Statstics_ALL_csv_Female_Ow" : null, "PPP_Statstics_ALL_csv_Male_Owne" : null, "PPP_Statstics_ALL_csv_Gender_Un" : null, "PPP_Statstics_ALL_csv_Gender_On" : null, "PPP_Statstics_ALL_csv_Race_and_" : null, "PPP_Statstics_ALL_csv_Veteran" : null, "PPP_Statstics_ALL_csv_Non_Veter" : null, "PPP_Statstics_ALL_csv_Veteran_S" : null, "PPP_Statstics_ALL_csv_Veteran_1" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 1, "name" : "PPP_Stats_Outside_SMC", "type" : "Feature Layer", "serviceItemId" : "76698b9bbb2143459c739ddf01ee28e1", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1599615034513, "schemaLastEditDate" : 1599615034513, "dataLastEditDate" : 1599615034513 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 9244649, "maxScale" : 4513, "extent" : { "xmin" : -13825187.77903886, "ymin" : 4389469.3204495972, "xmax" : -13488995.794993561, "ymax" : 4987475.095137381, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,225,56,191],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.75}}},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "FID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Zipcode", "type" : "esriFieldTypeString", "alias" : "Zipcode", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_State", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_CD", "type" : "esriFieldTypeString", "alias" : "CD", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_NAICS_Cod", "type" : "esriFieldTypeInteger", "alias" : "NAICS_Codes_Count_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Employees", "type" : "esriFieldTypeString", "alias" : "Employees_99_or_less", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Employe_1", "type" : "esriFieldTypeString", "alias" : "Employees_100_to_999", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_in_", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_April_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_in1", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_May_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_i_1", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_June_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_i_2", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_July_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_i_3", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_August_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_Tot", "type" : "esriFieldTypeInteger", "alias" : "Loans_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loan_Aggr", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_Low", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loan_Ag_1", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_High", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loan_Ag_2", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_Average", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Top_Lende", "type" : "esriFieldTypeString", "alias" : "Top_Lender", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Top_Len_1", "type" : "esriFieldTypeInteger", "alias" : "Top_Lender_Loans_Issued", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Jobs_Repo", "type" : "esriFieldTypeInteger", "alias" : "Jobs_Reported_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Cooperati", "type" : "esriFieldTypeInteger", "alias" : "Cooperative", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Corporati", "type" : "esriFieldTypeInteger", "alias" : "Corporation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Employee_", "type" : "esriFieldTypeInteger", "alias" : "Employee_Stock_Ownership_Plan(ESOP)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Independe", "type" : "esriFieldTypeInteger", "alias" : "Independent_Contractors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Limited__", "type" : "esriFieldTypeInteger", "alias" : "Limited _Liability_Company(LLC)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Limited_L", "type" : "esriFieldTypeInteger", "alias" : "Limited_Liability_Partnership", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Non_Profi", "type" : "esriFieldTypeInteger", "alias" : "Non_Profit_Childcare_Center", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Non_Pro_1", "type" : "esriFieldTypeInteger", "alias" : "Non_Profit_Organization", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Loans_To_", "type" : "esriFieldTypeInteger", "alias" : "Loans_To_Non_Profits_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Partnersh", "type" : "esriFieldTypeInteger", "alias" : "Partnership", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Professio", "type" : "esriFieldTypeInteger", "alias" : "Professional_Association", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Self_Empl", "type" : "esriFieldTypeInteger", "alias" : "Self_Employed_Individuals", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Sole_Prop", "type" : "esriFieldTypeInteger", "alias" : "Sole_Proprietorship", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Subchapte", "type" : "esriFieldTypeInteger", "alias" : "Subchapter_S_Corporation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Trust", "type" : "esriFieldTypeInteger", "alias" : "Trust", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Tenant_in", "type" : "esriFieldTypeInteger", "alias" : "Tenant_in_Common", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_American_", "type" : "esriFieldTypeString", "alias" : "American_Indian_or_Alaska_Native", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Fem", "type" : "esriFieldTypeInteger", "alias" : "Asian_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Mal", "type" : "esriFieldTypeInteger", "alias" : "Asian_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Una", "type" : "esriFieldTypeInteger", "alias" : "Asian_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_or_", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_or1", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_o_1", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispanic_", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispanic1", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispani_1", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Fem", "type" : "esriFieldTypeInteger", "alias" : "White_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Mal", "type" : "esriFieldTypeInteger", "alias" : "White_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Una", "type" : "esriFieldTypeInteger", "alias" : "White_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_American1", "type" : "esriFieldTypeString", "alias" : "American_Indian_or_Alaska_Native_Total", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Asian_Tot", "type" : "esriFieldTypeInteger", "alias" : "Asian_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Hispani_2", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_White_Tot", "type" : "esriFieldTypeInteger", "alias" : "White_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Black_o_2", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Female_Ow", "type" : "esriFieldTypeInteger", "alias" : "Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Male_Owne", "type" : "esriFieldTypeInteger", "alias" : "Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Gender_Un", "type" : "esriFieldTypeInteger", "alias" : "Gender_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Gender_On", "type" : "esriFieldTypeInteger", "alias" : "Gender_Only_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Race_and_", "type" : "esriFieldTypeInteger", "alias" : "Race_and_Gender_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Veteran", "type" : "esriFieldTypeInteger", "alias" : "Veteran", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Non_Veter", "type" : "esriFieldTypeInteger", "alias" : "Non_Veteran", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Veteran_S", "type" : "esriFieldTypeInteger", "alias" : "Veteran_Status_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PPP_Statstics_ALL_csv_Veteran_1", "type" : "esriFieldTypeInteger", "alias" : "Veteran_Status_Only_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "PK__PPP_STAT__F4B70D85950647F7", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_3074.PPP_STATISTICS_PPP_STATS_OUTSIDE_SMC_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "undefined_Index", "fields" : "", "isAscending" : false, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "undefined_Index", "fields" : "", "isAscending" : false, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "PPP_Statstics_ALL_csv_Zipcode" : null, "PPP_Statstics_ALL_csv_City" : null, "PPP_Statstics_ALL_csv_State" : null, "PPP_Statstics_ALL_csv_CD" : null, "PPP_Statstics_ALL_csv_NAICS_Cod" : null, "PPP_Statstics_ALL_csv_Employees" : null, "PPP_Statstics_ALL_csv_Employe_1" : null, "PPP_Statstics_ALL_csv_Loans_in_" : null, "PPP_Statstics_ALL_csv_Loans_in1" : null, "PPP_Statstics_ALL_csv_Loans_i_1" : null, "PPP_Statstics_ALL_csv_Loans_i_2" : null, "PPP_Statstics_ALL_csv_Loans_i_3" : null, "PPP_Statstics_ALL_csv_Loans_Tot" : null, "PPP_Statstics_ALL_csv_Loan_Aggr" : null, "PPP_Statstics_ALL_csv_Loan_Ag_1" : null, "PPP_Statstics_ALL_csv_Loan_Ag_2" : null, "PPP_Statstics_ALL_csv_Top_Lende" : null, "PPP_Statstics_ALL_csv_Top_Len_1" : null, "PPP_Statstics_ALL_csv_Jobs_Repo" : null, "PPP_Statstics_ALL_csv_Cooperati" : null, "PPP_Statstics_ALL_csv_Corporati" : null, "PPP_Statstics_ALL_csv_Employee_" : null, "PPP_Statstics_ALL_csv_Independe" : null, "PPP_Statstics_ALL_csv_Limited__" : null, "PPP_Statstics_ALL_csv_Limited_L" : null, "PPP_Statstics_ALL_csv_Non_Profi" : null, "PPP_Statstics_ALL_csv_Non_Pro_1" : null, "PPP_Statstics_ALL_csv_Loans_To_" : null, "PPP_Statstics_ALL_csv_Partnersh" : null, "PPP_Statstics_ALL_csv_Professio" : null, "PPP_Statstics_ALL_csv_Self_Empl" : null, "PPP_Statstics_ALL_csv_Sole_Prop" : null, "PPP_Statstics_ALL_csv_Subchapte" : null, "PPP_Statstics_ALL_csv_Trust" : null, "PPP_Statstics_ALL_csv_Tenant_in" : null, "PPP_Statstics_ALL_csv_American_" : null, "PPP_Statstics_ALL_csv_Asian_Fem" : null, "PPP_Statstics_ALL_csv_Asian_Mal" : null, "PPP_Statstics_ALL_csv_Asian_Una" : null, "PPP_Statstics_ALL_csv_Black_or_" : null, "PPP_Statstics_ALL_csv_Black_or1" : null, "PPP_Statstics_ALL_csv_Black_o_1" : null, "PPP_Statstics_ALL_csv_Hispanic_" : null, "PPP_Statstics_ALL_csv_Hispanic1" : null, "PPP_Statstics_ALL_csv_Hispani_1" : null, "PPP_Statstics_ALL_csv_White_Fem" : null, "PPP_Statstics_ALL_csv_White_Mal" : null, "PPP_Statstics_ALL_csv_White_Una" : null, "PPP_Statstics_ALL_csv_American1" : null, "PPP_Statstics_ALL_csv_Asian_Tot" : null, "PPP_Statstics_ALL_csv_Hispani_2" : null, "PPP_Statstics_ALL_csv_White_Tot" : null, "PPP_Statstics_ALL_csv_Black_o_2" : null, "PPP_Statstics_ALL_csv_Female_Ow" : null, "PPP_Statstics_ALL_csv_Male_Owne" : null, "PPP_Statstics_ALL_csv_Gender_Un" : null, "PPP_Statstics_ALL_csv_Gender_On" : null, "PPP_Statstics_ALL_csv_Race_and_" : null, "PPP_Statstics_ALL_csv_Veteran" : null, "PPP_Statstics_ALL_csv_Non_Veter" : null, "PPP_Statstics_ALL_csv_Veteran_S" : null, "PPP_Statstics_ALL_csv_Veteran_1" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [ { "currentVersion" : 12, "id" : 2, "name" : "PPP_Statstics_ALL", "type" : "Table", "serviceItemId" : "76698b9bbb2143459c739ddf01ee28e1", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1599608941737, "schemaLastEditDate" : 1599608941737, "dataLastEditDate" : 1599608941737 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ID", "type" : "esriFieldTypeInteger", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zipcode", "type" : "esriFieldTypeString", "alias" : "Zipcode", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CD", "type" : "esriFieldTypeString", "alias" : "CD", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NAICS_Codes_Count_Total", "type" : "esriFieldTypeInteger", "alias" : "NAICS_Codes_Count_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Employees_99_or_less", "type" : "esriFieldTypeString", "alias" : "Employees_99_or_less", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Employees_100_to_999", "type" : "esriFieldTypeString", "alias" : "Employees_100_to_999", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_in_April_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_April_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_in_May_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_May_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_in_June_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_June_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_in_July_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_July_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_in_August_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_in_August_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loan_Aggregate_Low", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_Low", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loan_Aggregate_High", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_High", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loan_Aggregate_Average", "type" : "esriFieldTypeInteger", "alias" : "Loan_Aggregate_Average", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Top_Lender", "type" : "esriFieldTypeString", "alias" : "Top_Lender", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Top_Lender_Loans_Issued", "type" : "esriFieldTypeInteger", "alias" : "Top_Lender_Loans_Issued", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Jobs_Reported_Total", "type" : "esriFieldTypeInteger", "alias" : "Jobs_Reported_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cooperative", "type" : "esriFieldTypeInteger", "alias" : "Cooperative", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Corporation", "type" : "esriFieldTypeInteger", "alias" : "Corporation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Employee_Stock_Ownership_Plan_E", "type" : "esriFieldTypeInteger", "alias" : "Employee_Stock_Ownership_Plan(ESOP)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Independent_Contractors", "type" : "esriFieldTypeInteger", "alias" : "Independent_Contractors", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Limited__Liability_Company_LLC_", "type" : "esriFieldTypeInteger", "alias" : "Limited _Liability_Company(LLC)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Limited_Liability_Partnership", "type" : "esriFieldTypeInteger", "alias" : "Limited_Liability_Partnership", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Non_Profit_Childcare_Center", "type" : "esriFieldTypeInteger", "alias" : "Non_Profit_Childcare_Center", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Non_Profit_Organization", "type" : "esriFieldTypeInteger", "alias" : "Non_Profit_Organization", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Loans_To_Non_Profits_Total", "type" : "esriFieldTypeInteger", "alias" : "Loans_To_Non_Profits_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Partnership", "type" : "esriFieldTypeInteger", "alias" : "Partnership", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Professional_Association", "type" : "esriFieldTypeInteger", "alias" : "Professional_Association", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Self_Employed_Individuals", "type" : "esriFieldTypeInteger", "alias" : "Self_Employed_Individuals", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sole_Proprietorship", "type" : "esriFieldTypeInteger", "alias" : "Sole_Proprietorship", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Subchapter_S_Corporation", "type" : "esriFieldTypeInteger", "alias" : "Subchapter_S_Corporation", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Trust", "type" : "esriFieldTypeInteger", "alias" : "Trust", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tenant_in_Common", "type" : "esriFieldTypeInteger", "alias" : "Tenant_in_Common", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "American_Indian_or_Alaska_Nativ", "type" : "esriFieldTypeString", "alias" : "American_Indian_or_Alaska_Native", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asian_Female_Owned", "type" : "esriFieldTypeInteger", "alias" : "Asian_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asian_Male_Owned", "type" : "esriFieldTypeInteger", "alias" : "Asian_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asian_Unanswered", "type" : "esriFieldTypeInteger", "alias" : "Asian_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Black_or_African_American_Femal", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Black_or_African_American_Male_", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Black_or_African_American_Unans", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hispanic_Female_Owned", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hispanic_Male_Owned", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hispanic_Unanswered", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "White_Female_Owned", "type" : "esriFieldTypeInteger", "alias" : "White_Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "White_Male_Owned", "type" : "esriFieldTypeInteger", "alias" : "White_Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "White_Unanswered", "type" : "esriFieldTypeInteger", "alias" : "White_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "American_Indian_or_Alaska_Nat_1", "type" : "esriFieldTypeString", "alias" : "American_Indian_or_Alaska_Native_Total", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asian_Total", "type" : "esriFieldTypeInteger", "alias" : "Asian_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hispanic_Total", "type" : "esriFieldTypeInteger", "alias" : "Hispanic_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "White_Total", "type" : "esriFieldTypeInteger", "alias" : "White_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Black_or_African_American_Total", "type" : "esriFieldTypeInteger", "alias" : "Black_or_African_American_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Female_Owned", "type" : "esriFieldTypeInteger", "alias" : "Female_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Male_Owned", "type" : "esriFieldTypeInteger", "alias" : "Male_Owned", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Gender_Unanswered", "type" : "esriFieldTypeInteger", "alias" : "Gender_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Gender_Only_Total", "type" : "esriFieldTypeInteger", "alias" : "Gender_Only_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Race_and_Gender_Total", "type" : "esriFieldTypeInteger", "alias" : "Race_and_Gender_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Veteran", "type" : "esriFieldTypeInteger", "alias" : "Veteran", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Non_Veteran", "type" : "esriFieldTypeInteger", "alias" : "Non_Veteran", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Veteran_Status_Unanswered", "type" : "esriFieldTypeInteger", "alias" : "Veteran_Status_Unanswered", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Veteran_Status_Only_Total", "type" : "esriFieldTypeInteger", "alias" : "Veteran_Status_Only_Total", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__PPP_STAT__F4B70D853B6FF321", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ] }