{
  "id" : "tmnf-yvry",
  "name" : "Police Department Incident Reports: Historical 2003 to May 2018",
  "assetType" : "dataset",
  "attribution" : "City and County of San Francisco",
  "attributionLink" : "http://www.sfgov.org",
  "averageRating" : 0,
  "category" : "Public Safety",
  "createdAt" : 1330116913,
  "description" : "For up to date data starting in 2018, please go to the new dataset at: https://data.sfgov.org/d/wg3w-h783\n\nAs of May 2018, the feed from the legacy mainframe CABLE was discontinued. It was extremely prone to issues and caused many delays in data accessibility. The new dataset linked above comes from the Crime Data Warehouse, a more reliable data system maintained by the Police Department.\n\nThis data will undergo a minor update to conform more closely to the schema of the new dataset. We will post a change notice when that work is planned. This change will not include adding new fields or backfilling data. It is provided as is. We are keeping data from the two systems separate to make it transparent to data users that there were fundamental changes.",
  "diciBackend" : false,
  "displayType" : "table",
  "domainCName" : "data.sfgov.org",
  "downloadCount" : 79619,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "licenseId" : "PDDL",
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 25,
  "oid" : 41371094,
  "provenance" : "official",
  "publicationAppendEnabled" : true,
  "publicationDate" : 1749502808,
  "publicationGroup" : 289138,
  "publicationStage" : "published",
  "rowIdentifierColumnId" : 611613906,
  "rowsUpdatedAt" : 1750450434,
  "tableId" : 19919952,
  "totalTimesRated" : 0,
  "viewCount" : 257938,
  "viewLastModified" : 1750449957,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1489451997,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 6916903,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1489451997,
    "targetAudience" : "public",
    "workflowId" : 2546,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "failureCount" : 0,
      "status" : "success"
    },
    "submitter" : {
      "id" : "dbag-6qd9",
      "displayName" : "OpenData"
    }
  }, {
    "message" : "The `strict_permissions` flag must be on to enable internal approvals.",
    "state" : "unsubmittable",
    "targetAudience" : "internal",
    "workflowId" : 5264
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 611613906,
    "name" : "PdId",
    "dataTypeName" : "number",
    "description" : "Unique Identifier for use in update and insert operations",
    "fieldName" : "pdid",
    "position" : 1,
    "renderTypeName" : "number",
    "tableColumnId" : 24618210,
    "width" : 100,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "99158237763010",
      "null" : "0",
      "top" : [ {
        "item" : "1012863010",
        "count" : "1"
      }, {
        "item" : "1073663010",
        "count" : "1"
      }, {
        "item" : "3826163010",
        "count" : "1"
      }, {
        "item" : "5220563010",
        "count" : "1"
      }, {
        "item" : "6139763010",
        "count" : "1"
      }, {
        "item" : "6238907023",
        "count" : "1"
      }, {
        "item" : "6238907043",
        "count" : "1"
      }, {
        "item" : "6295363010",
        "count" : "1"
      }, {
        "item" : "7079662050",
        "count" : "1"
      }, {
        "item" : "7305763010",
        "count" : "1"
      }, {
        "item" : "7723163010",
        "count" : "1"
      }, {
        "item" : "8173763010",
        "count" : "1"
      }, {
        "item" : "10062263010",
        "count" : "1"
      }, {
        "item" : "11987763010",
        "count" : "1"
      }, {
        "item" : "12343602004",
        "count" : "1"
      }, {
        "item" : "12343616010",
        "count" : "1"
      }, {
        "item" : "13191263010",
        "count" : "1"
      }, {
        "item" : "15257663010",
        "count" : "1"
      }, {
        "item" : "19839863010",
        "count" : "1"
      }, {
        "item" : "24825062050",
        "count" : "1"
      } ],
      "smallest" : "397963010",
      "count" : "2071736",
      "cardinality" : "2071736"
    },
    "format" : {
      "precisionStyle" : "standard",
      "noCommas" : "true",
      "align" : "right"
    }
  }, {
    "id" : 611613907,
    "name" : "IncidntNum",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "incidntnum",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 2155096,
    "width" : 80,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "991582377",
      "null" : "0",
      "top" : [ {
        "item" : "180187811",
        "count" : "23"
      }, {
        "item" : "140135145",
        "count" : "19"
      }, {
        "item" : "171000725",
        "count" : "18"
      }, {
        "item" : "160629623",
        "count" : "17"
      }, {
        "item" : "160174703",
        "count" : "15"
      }, {
        "item" : "151121761",
        "count" : "14"
      }, {
        "item" : "170186986",
        "count" : "14"
      }, {
        "item" : "160354262",
        "count" : "14"
      }, {
        "item" : "170559220",
        "count" : "14"
      }, {
        "item" : "130994393",
        "count" : "13"
      }, {
        "item" : "151038144",
        "count" : "13"
      }, {
        "item" : "150109908",
        "count" : "13"
      }, {
        "item" : "160434193",
        "count" : "13"
      }, {
        "item" : "170265847",
        "count" : "13"
      }, {
        "item" : "160696202",
        "count" : "13"
      }, {
        "item" : "120772983",
        "count" : "13"
      }, {
        "item" : "160263431",
        "count" : "13"
      }, {
        "item" : "180269635",
        "count" : "12"
      }, {
        "item" : "180010911",
        "count" : "12"
      }, {
        "item" : "130247982",
        "count" : "12"
      } ],
      "smallest" : "000003979",
      "count" : "2071736",
      "cardinality" : "1651726"
    },
    "format" : {
      "precisionStyle" : "standard",
      "noCommas" : "true",
      "align" : "right"
    }
  }, {
    "id" : 611613908,
    "name" : "Incident Code",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "incident_code",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 112236924,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "75030",
      "null" : "0",
      "top" : [ {
        "item" : "06244",
        "count" : "178776"
      }, {
        "item" : "71000",
        "count" : "77947"
      }, {
        "item" : "04134",
        "count" : "66321"
      }, {
        "item" : "07021",
        "count" : "64616"
      }, {
        "item" : "65016",
        "count" : "62372"
      }, {
        "item" : "63010",
        "count" : "55123"
      }, {
        "item" : "64070",
        "count" : "52253"
      }, {
        "item" : "28150",
        "count" : "45013"
      }, {
        "item" : "28160",
        "count" : "44144"
      }, {
        "item" : "06372",
        "count" : "38113"
      }, {
        "item" : "65015",
        "count" : "37569"
      }, {
        "item" : "19057",
        "count" : "34117"
      }, {
        "item" : "72000",
        "count" : "33344"
      }, {
        "item" : "06374",
        "count" : "29400"
      }, {
        "item" : "62050",
        "count" : "28740"
      }, {
        "item" : "06243",
        "count" : "26748"
      }, {
        "item" : "75000",
        "count" : "23708"
      }, {
        "item" : "16710",
        "count" : "22785"
      }, {
        "item" : "06304",
        "count" : "22445"
      }, {
        "item" : "09320",
        "count" : "22067"
      } ],
      "smallest" : "00000",
      "count" : "2071736",
      "cardinality" : "883"
    },
    "format" : { }
  }, {
    "id" : 611613909,
    "name" : "Category",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "category",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 2155097,
    "width" : 127,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "WEAPON LAWS",
      "null" : "0",
      "top" : [ {
        "item" : "LARCENY/THEFT",
        "count" : "477975"
      }, {
        "item" : "OTHER OFFENSES",
        "count" : "301874"
      }, {
        "item" : "NON-CRIMINAL",
        "count" : "179139"
      }, {
        "item" : "ASSAULT",
        "count" : "167042"
      }, {
        "item" : "VEHICLE THEFT",
        "count" : "126228"
      }, {
        "item" : "DRUG/NARCOTIC",
        "count" : "117821"
      }, {
        "item" : "VANDALISM",
        "count" : "114718"
      }, {
        "item" : "WARRANTS",
        "count" : "99821"
      }, {
        "item" : "BURGLARY",
        "count" : "91067"
      }, {
        "item" : "SUSPICIOUS OCC",
        "count" : "79087"
      }, {
        "item" : "ROBBERY",
        "count" : "54467"
      }, {
        "item" : "MISSING PERSON",
        "count" : "44268"
      }, {
        "item" : "FRAUD",
        "count" : "41348"
      }, {
        "item" : "FORGERY/COUNTERFEITING",
        "count" : "22995"
      }, {
        "item" : "SECONDARY CODES",
        "count" : "22378"
      }, {
        "item" : "WEAPON LAWS",
        "count" : "21004"
      }, {
        "item" : "TRESPASS",
        "count" : "19194"
      }, {
        "item" : "PROSTITUTION",
        "count" : "16501"
      }, {
        "item" : "STOLEN PROPERTY",
        "count" : "11450"
      }, {
        "item" : "DISORDERLY CONDUCT",
        "count" : "9932"
      } ],
      "smallest" : "ARSON",
      "count" : "2071736",
      "cardinality" : "37"
    },
    "format" : { }
  }, {
    "id" : 611613910,
    "name" : "Descript",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "descript",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 2155098,
    "width" : 195,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "WIRETAPS, UNAUTHORIZED",
      "null" : "0",
      "top" : [ {
        "item" : "GRAND THEFT FROM LOCKED AUTO",
        "count" : "178776"
      }, {
        "item" : "LOST PROPERTY",
        "count" : "77947"
      }, {
        "item" : "BATTERY",
        "count" : "66321"
      }, {
        "item" : "STOLEN AUTOMOBILE",
        "count" : "64616"
      }, {
        "item" : "DRIVERS LICENSE, SUSPENDED OR REVOKED",
        "count" : "62372"
      }, {
        "item" : "WARRANT ARREST",
        "count" : "55123"
      }, {
        "item" : "SUSPICIOUS OCCURRENCE",
        "count" : "52253"
      }, {
        "item" : "PETTY THEFT FROM LOCKED AUTO",
        "count" : "51912"
      }, {
        "item" : "PETTY THEFT OF PROPERTY",
        "count" : "46049"
      }, {
        "item" : "MALICIOUS MISCHIEF, VANDALISM",
        "count" : "45013"
      }, {
        "item" : "MALICIOUS MISCHIEF, VANDALISM OF VEHICLES",
        "count" : "44144"
      }, {
        "item" : "TRAFFIC VIOLATION",
        "count" : "37569"
      }, {
        "item" : "THREATS AGAINST LIFE",
        "count" : "34117"
      }, {
        "item" : "FOUND PROPERTY",
        "count" : "33344"
      }, {
        "item" : "GRAND THEFT OF PROPERTY",
        "count" : "29400"
      }, {
        "item" : "ENROUTE TO OUTSIDE JURISDICTION",
        "count" : "28740"
      }, {
        "item" : "PETTY THEFT FROM A BUILDING",
        "count" : "25623"
      }, {
        "item" : "FOUND PERSON",
        "count" : "23708"
      }, {
        "item" : "PETTY THEFT SHOPLIFTING",
        "count" : "22930"
      }, {
        "item" : "POSSESSION OF NARCOTICS PARAPHERNALIA",
        "count" : "22785"
      } ],
      "smallest" : "ABORTION",
      "count" : "2071736",
      "cardinality" : "845"
    },
    "format" : { }
  }, {
    "id" : 611613911,
    "name" : "DayOfWeek",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "dayofweek",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 2155099,
    "width" : 78,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "Wednesday",
      "null" : "0",
      "top" : [ {
        "item" : "Friday",
        "count" : "315723"
      }, {
        "item" : "Wednesday",
        "count" : "303404"
      }, {
        "item" : "Saturday",
        "count" : "300899"
      }, {
        "item" : "Thursday",
        "count" : "295582"
      }, {
        "item" : "Tuesday",
        "count" : "294126"
      }, {
        "item" : "Monday",
        "count" : "286081"
      }, {
        "item" : "Sunday",
        "count" : "275921"
      } ],
      "smallest" : "Friday",
      "count" : "2071736",
      "cardinality" : "7"
    },
    "format" : { }
  }, {
    "id" : 611613912,
    "name" : "Date",
    "dataTypeName" : "calendar_date",
    "description" : "",
    "fieldName" : "date",
    "position" : 7,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 2155100,
    "width" : 71,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "2018-05-15T00:00:00.000",
      "null" : "0",
      "top" : [ {
        "item" : "2011-01-01T00:00:00.000",
        "count" : "619"
      }, {
        "item" : "2013-01-01T00:00:00.000",
        "count" : "590"
      }, {
        "item" : "2013-11-01T00:00:00.000",
        "count" : "589"
      }, {
        "item" : "2006-01-01T00:00:00.000",
        "count" : "577"
      }, {
        "item" : "2003-01-01T00:00:00.000",
        "count" : "575"
      }, {
        "item" : "2015-06-28T00:00:00.000",
        "count" : "569"
      }, {
        "item" : "2009-01-01T00:00:00.000",
        "count" : "560"
      }, {
        "item" : "2010-01-01T00:00:00.000",
        "count" : "535"
      }, {
        "item" : "2004-04-01T00:00:00.000",
        "count" : "533"
      }, {
        "item" : "2016-01-01T00:00:00.000",
        "count" : "529"
      }, {
        "item" : "2015-10-01T00:00:00.000",
        "count" : "526"
      }, {
        "item" : "2015-01-01T00:00:00.000",
        "count" : "525"
      }, {
        "item" : "2005-02-01T00:00:00.000",
        "count" : "524"
      }, {
        "item" : "2017-06-25T00:00:00.000",
        "count" : "523"
      }, {
        "item" : "2013-10-04T00:00:00.000",
        "count" : "518"
      }, {
        "item" : "2010-10-01T00:00:00.000",
        "count" : "516"
      }, {
        "item" : "2015-08-07T00:00:00.000",
        "count" : "513"
      }, {
        "item" : "2017-03-01T00:00:00.000",
        "count" : "512"
      }, {
        "item" : "2015-02-20T00:00:00.000",
        "count" : "511"
      }, {
        "item" : "2005-01-01T00:00:00.000",
        "count" : "510"
      } ],
      "smallest" : "2003-01-01T00:00:00.000",
      "count" : "2071736",
      "cardinality" : "5613"
    },
    "format" : {
      "view" : "date",
      "align" : "left"
    }
  }, {
    "id" : 611613913,
    "name" : "Time",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "time",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 2155101,
    "width" : 50,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "23:59",
      "null" : "0",
      "top" : [ {
        "item" : "12:00",
        "count" : "54788"
      }, {
        "item" : "00:01",
        "count" : "53857"
      }, {
        "item" : "18:00",
        "count" : "46739"
      }, {
        "item" : "17:00",
        "count" : "40561"
      }, {
        "item" : "19:00",
        "count" : "40354"
      }, {
        "item" : "20:00",
        "count" : "40094"
      }, {
        "item" : "22:00",
        "count" : "38381"
      }, {
        "item" : "21:00",
        "count" : "36848"
      }, {
        "item" : "15:00",
        "count" : "35731"
      }, {
        "item" : "16:00",
        "count" : "34954"
      }, {
        "item" : "23:00",
        "count" : "32693"
      }, {
        "item" : "14:00",
        "count" : "31375"
      }, {
        "item" : "09:00",
        "count" : "29241"
      }, {
        "item" : "13:00",
        "count" : "29150"
      }, {
        "item" : "10:00",
        "count" : "29061"
      }, {
        "item" : "08:00",
        "count" : "27599"
      }, {
        "item" : "11:00",
        "count" : "25315"
      }, {
        "item" : "18:30",
        "count" : "21094"
      }, {
        "item" : "19:30",
        "count" : "19548"
      }, {
        "item" : "17:30",
        "count" : "19319"
      } ],
      "smallest" : "00:01",
      "count" : "2071736",
      "cardinality" : "1439"
    },
    "format" : { }
  }, {
    "id" : 611613914,
    "name" : "PdDistrict",
    "dataTypeName" : "text",
    "description" : "Historical PD District Effective Through 7-18-2015",
    "fieldName" : "pddistrict",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 2155102,
    "width" : 91,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "TENDERLOIN",
      "null" : "0",
      "top" : [ {
        "item" : "SOUTHERN",
        "count" : "378453"
      }, {
        "item" : "MISSION",
        "count" : "279744"
      }, {
        "item" : "NORTHERN",
        "count" : "260013"
      }, {
        "item" : "CENTRAL",
        "count" : "216646"
      }, {
        "item" : "BAYVIEW",
        "count" : "201989"
      }, {
        "item" : "TENDERLOIN",
        "count" : "180934"
      }, {
        "item" : "INGLESIDE",
        "count" : "176557"
      }, {
        "item" : "TARAVAL",
        "count" : "150970"
      }, {
        "item" : "PARK",
        "count" : "116296"
      }, {
        "item" : "RICHMOND",
        "count" : "110133"
      }, {
        "item" : "NA",
        "count" : "1"
      } ],
      "smallest" : "BAYVIEW",
      "count" : "2071736",
      "cardinality" : "11"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 611613915,
    "name" : "Resolution",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "resolution",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 2155103,
    "width" : 136,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "UNFOUNDED",
      "null" : "0",
      "top" : [ {
        "item" : "NONE",
        "count" : "1333363"
      }, {
        "item" : "ARREST, BOOKED",
        "count" : "508058"
      }, {
        "item" : "ARREST, CITED",
        "count" : "153001"
      }, {
        "item" : "UNFOUNDED",
        "count" : "22442"
      }, {
        "item" : "LOCATED",
        "count" : "20973"
      }, {
        "item" : "COMPLAINANT REFUSES TO PROSECUTE",
        "count" : "7567"
      }, {
        "item" : "NOT PROSECUTED",
        "count" : "7496"
      }, {
        "item" : "DISTRICT ATTORNEY REFUSES TO PROSECUTE",
        "count" : "7102"
      }, {
        "item" : "PROSECUTED BY OUTSIDE AGENCY",
        "count" : "4921"
      }, {
        "item" : "EXCEPTIONAL CLEARANCE",
        "count" : "3711"
      }, {
        "item" : "PSYCHOPATHIC CASE",
        "count" : "3021"
      }, {
        "item" : "PROSECUTED FOR LESSER OFFENSE",
        "count" : "81"
      } ],
      "smallest" : "ARREST, BOOKED",
      "count" : "2071736",
      "cardinality" : "12"
    },
    "format" : { }
  }, {
    "id" : 611613916,
    "name" : "Address",
    "dataTypeName" : "text",
    "description" : "",
    "fieldName" : "address",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 2155104,
    "width" : 184,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "ZOE ST / WELSH ST",
      "null" : "0",
      "top" : [ {
        "item" : "800 Block of BRYANT ST",
        "count" : "62026"
      }, {
        "item" : "800 Block of MARKET ST",
        "count" : "16385"
      }, {
        "item" : "2000 Block of MISSION ST",
        "count" : "10542"
      }, {
        "item" : "1000 Block of POTRERO AV",
        "count" : "8686"
      }, {
        "item" : "900 Block of MARKET ST",
        "count" : "7274"
      }, {
        "item" : "0 Block of TURK ST",
        "count" : "6465"
      }, {
        "item" : "16TH ST / MISSION ST",
        "count" : "6022"
      }, {
        "item" : "0 Block of 6TH ST",
        "count" : "6013"
      }, {
        "item" : "300 Block of ELLIS ST",
        "count" : "5765"
      }, {
        "item" : "1000 Block of MARKET ST",
        "count" : "5453"
      }, {
        "item" : "100 Block of OFARRELL ST",
        "count" : "5240"
      }, {
        "item" : "400 Block of ELLIS ST",
        "count" : "5224"
      }, {
        "item" : "1100 Block of MARKET ST",
        "count" : "5218"
      }, {
        "item" : "2000 Block of MARKET ST",
        "count" : "5120"
      }, {
        "item" : "3200 Block of 20TH AV",
        "count" : "5079"
      }, {
        "item" : "700 Block of MARKET ST",
        "count" : "4836"
      }, {
        "item" : "500 Block of JOHNFKENNEDY DR",
        "count" : "4810"
      }, {
        "item" : "0 Block of UNITEDNATIONS PZ",
        "count" : "4583"
      }, {
        "item" : "100 Block of 6TH ST",
        "count" : "4216"
      }, {
        "item" : "300 Block of EDDY ST",
        "count" : "3909"
      } ],
      "smallest" : "0 Block of 10TH AV",
      "count" : "2071736",
      "cardinality" : "25101"
    },
    "format" : { }
  }, {
    "id" : 611613917,
    "name" : "X",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "x",
    "position" : 12,
    "renderTypeName" : "number",
    "tableColumnId" : 2155105,
    "width" : 112,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "-120.5",
      "null" : "0",
      "top" : [ {
        "item" : "-122.403404791479",
        "count" : "52977"
      }, {
        "item" : "-122.40340479147905",
        "count" : "8699"
      }, {
        "item" : "-122.41965834371",
        "count" : "8656"
      }, {
        "item" : "-122.406539115148",
        "count" : "7127"
      }, {
        "item" : "-122.419671780296",
        "count" : "6473"
      }, {
        "item" : "-122.407633520742",
        "count" : "6460"
      }, {
        "item" : "-122.406520987144",
        "count" : "4856"
      }, {
        "item" : "-122.409853729941",
        "count" : "4725"
      }, {
        "item" : "-122.466204667893",
        "count" : "4636"
      }, {
        "item" : "-122.426955631709",
        "count" : "4081"
      }, {
        "item" : "-122.407244087032",
        "count" : "3950"
      }, {
        "item" : "-122.475647460786",
        "count" : "3828"
      }, {
        "item" : "-122.452289660492",
        "count" : "3364"
      }, {
        "item" : "-122.411071423064",
        "count" : "3247"
      }, {
        "item" : "-122.413564091744",
        "count" : "3215"
      }, {
        "item" : "-122.41029351969",
        "count" : "3155"
      }, {
        "item" : "-122.410768766343",
        "count" : "3118"
      }, {
        "item" : "-122.414056291891",
        "count" : "3035"
      }, {
        "item" : "-122.411965795229",
        "count" : "2916"
      }, {
        "item" : "-122.413609328985",
        "count" : "2897"
      } ],
      "smallest" : "-122.51364206429",
      "count" : "2071736",
      "cardinality" : "60776"
    },
    "format" : { }
  }, {
    "id" : 611613918,
    "name" : "Y",
    "dataTypeName" : "number",
    "description" : "",
    "fieldName" : "y",
    "position" : 13,
    "renderTypeName" : "number",
    "tableColumnId" : 2155106,
    "width" : 112,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "90",
      "null" : "0",
      "top" : [ {
        "item" : "37.775420706711",
        "count" : "61676"
      }, {
        "item" : "37.7642205603745",
        "count" : "8656"
      }, {
        "item" : "37.7564864109309",
        "count" : "7127"
      }, {
        "item" : "37.7650501214668",
        "count" : "6473"
      }, {
        "item" : "37.7841893501425",
        "count" : "6460"
      }, {
        "item" : "37.7850629421661",
        "count" : "4856"
      }, {
        "item" : "37.7833862379382",
        "count" : "4725"
      }, {
        "item" : "37.7725405391593",
        "count" : "4636"
      }, {
        "item" : "37.769247063207",
        "count" : "4081"
      }, {
        "item" : "37.7865647607685",
        "count" : "3950"
      }, {
        "item" : "37.7285280627465",
        "count" : "3828"
      }, {
        "item" : "37.7817511307229",
        "count" : "3540"
      }, {
        "item" : "37.7256933575703",
        "count" : "3364"
      }, {
        "item" : "37.779514030063",
        "count" : "3215"
      }, {
        "item" : "37.7822305870036",
        "count" : "3155"
      }, {
        "item" : "37.7832145190013",
        "count" : "3118"
      }, {
        "item" : "37.7827931071006",
        "count" : "3035"
      }, {
        "item" : "37.7849141859562",
        "count" : "2916"
      }, {
        "item" : "37.784696907904",
        "count" : "2897"
      }, {
        "item" : "37.7850943210103",
        "count" : "2775"
      } ],
      "smallest" : "37.7078790224135",
      "count" : "2071736",
      "cardinality" : "59467"
    },
    "format" : { }
  }, {
    "id" : 611613919,
    "name" : "location",
    "dataTypeName" : "point",
    "description" : "",
    "fieldName" : "location",
    "position" : 14,
    "renderTypeName" : "point",
    "tableColumnId" : 112332150,
    "cachedContents" : {
      "non_null" : "2071736",
      "null" : "0",
      "top" : [ {
        "item" : {
          "coordinates" : [ -122.403404791, 37.775420707 ],
          "type" : "Point"
        },
        "count" : "61676"
      }, {
        "item" : {
          "coordinates" : [ -122.41967178, 37.765050121 ],
          "type" : "Point"
        },
        "count" : "9129"
      }, {
        "item" : {
          "coordinates" : [ -122.419658344, 37.76422056 ],
          "type" : "Point"
        },
        "count" : "9019"
      }, {
        "item" : {
          "coordinates" : [ -122.406539115, 37.756486411 ],
          "type" : "Point"
        },
        "count" : "8361"
      }, {
        "item" : {
          "coordinates" : [ -122.407633521, 37.78418935 ],
          "type" : "Point"
        },
        "count" : "7745"
      }, {
        "item" : {
          "coordinates" : [ -122.406520987, 37.785062942 ],
          "type" : "Point"
        },
        "count" : "5861"
      }, {
        "item" : {
          "coordinates" : [ -122.466204668, 37.772540539 ],
          "type" : "Point"
        },
        "count" : "5479"
      }, {
        "item" : {
          "coordinates" : [ -122.475647461, 37.728528063 ],
          "type" : "Point"
        },
        "count" : "5031"
      }, {
        "item" : {
          "coordinates" : [ -122.40985373, 37.783386238 ],
          "type" : "Point"
        },
        "count" : "5013"
      }, {
        "item" : {
          "coordinates" : [ -122.426955632, 37.769247063 ],
          "type" : "Point"
        },
        "count" : "4667"
      }, {
        "item" : {
          "coordinates" : [ -122.407244087, 37.786564761 ],
          "type" : "Point"
        },
        "count" : "4660"
      }, {
        "item" : {
          "coordinates" : [ -122.41029352, 37.782230587 ],
          "type" : "Point"
        },
        "count" : "4594"
      }, {
        "item" : {
          "coordinates" : [ -122.410768766, 37.783214519 ],
          "type" : "Point"
        },
        "count" : "4287"
      }, {
        "item" : {
          "coordinates" : [ -122.414056292, 37.782793107 ],
          "type" : "Point"
        },
        "count" : "3895"
      }, {
        "item" : {
          "coordinates" : [ -122.412515341, 37.780477748 ],
          "type" : "Point"
        },
        "count" : "3798"
      }, {
        "item" : {
          "coordinates" : [ -122.413564092, 37.77951403 ],
          "type" : "Point"
        },
        "count" : "3703"
      }, {
        "item" : {
          "coordinates" : [ -122.45228966, 37.725693358 ],
          "type" : "Point"
        },
        "count" : "3682"
      }, {
        "item" : {
          "coordinates" : [ -122.408068345, 37.783991677 ],
          "type" : "Point"
        },
        "count" : "3544"
      }, {
        "item" : {
          "coordinates" : [ -122.411071423, 37.781751131 ],
          "type" : "Point"
        },
        "count" : "3540"
      }, {
        "item" : {
          "coordinates" : [ -122.410774214, 37.808435018 ],
          "type" : "Point"
        },
        "count" : "3226"
      } ],
      "count" : "2071736",
      "cardinality" : "31117"
    },
    "format" : { }
  }, {
    "id" : 611613941,
    "name" : "data_loaded_at",
    "dataTypeName" : "calendar_date",
    "description" : "Timestamp the data was uploaded to the open data portal.",
    "fieldName" : "data_loaded_at",
    "position" : 15,
    "renderTypeName" : "calendar_date",
    "tableColumnId" : 159147349,
    "cachedContents" : {
      "non_null" : "2071736",
      "largest" : "2025-06-20T12:17:56.000",
      "null" : "0",
      "top" : [ {
        "item" : "2025-06-20T12:17:56.000",
        "count" : "2071736"
      } ],
      "smallest" : "2025-06-20T12:17:56.000",
      "count" : "2071736",
      "cardinality" : "1"
    },
    "format" : {
      "view" : "date_ymd_time"
    }
  }, {
    "id" : 611613920,
    "name" : "SF Find Neighborhoods 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'SF Find Neighborhoods 2' (6qbp-sg9q) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_6qbp_sg9q",
    "position" : 59,
    "renderTypeName" : "number",
    "tableColumnId" : 112332151,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_6qbp-sg9q",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613921,
    "name" : "Current Police Districts 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Current Police Districts 2' (qgnn-b9vv) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_qgnn_b9vv",
    "position" : 60,
    "renderTypeName" : "number",
    "tableColumnId" : 112332152,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_qgnn-b9vv",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613922,
    "name" : "Current Supervisor Districts 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Current Supervisor Districts 2' (26cr-cadq) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_26cr_cadq",
    "position" : 61,
    "renderTypeName" : "number",
    "tableColumnId" : 112332153,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_26cr-cadq",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613923,
    "name" : "Analysis Neighborhoods 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Analysis Neighborhoods 2' (ajp5-b2md) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_ajp5_b2md",
    "position" : 62,
    "renderTypeName" : "number",
    "tableColumnId" : 112332154,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_ajp5-b2md",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613924,
    "name" : "DELETE - Fire Prevention Districts 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - Fire Prevention Districts 2' (yftq-j783) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_yftq_j783",
    "position" : 63,
    "renderTypeName" : "number",
    "tableColumnId" : 112332155,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_yftq-j783",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613925,
    "name" : "DELETE - Police Districts 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - Police Districts 2' (p5aj-wyqh) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_p5aj_wyqh",
    "position" : 64,
    "renderTypeName" : "number",
    "tableColumnId" : 112332156,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_p5aj-wyqh",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613926,
    "name" : "DELETE - Supervisor Districts 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - Supervisor Districts 2' (rxqg-mtj9) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_rxqg_mtj9",
    "position" : 65,
    "renderTypeName" : "number",
    "tableColumnId" : 112332157,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_rxqg-mtj9",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613927,
    "name" : "DELETE - Zip Codes 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - Zip Codes 2' (bh8s-q3mv) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_bh8s_q3mv",
    "position" : 66,
    "renderTypeName" : "number",
    "tableColumnId" : 112332158,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_bh8s-q3mv",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613928,
    "name" : "DELETE - Neighborhoods 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - Neighborhoods 2' (fyvs-ahh9) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_fyvs_ahh9",
    "position" : 67,
    "renderTypeName" : "number",
    "tableColumnId" : 112332159,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_fyvs-ahh9",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613929,
    "name" : "DELETE - 2017 Fix It Zones 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - 2017 Fix It Zones 2' (9dfj-4gjx) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_9dfj_4gjx",
    "position" : 68,
    "renderTypeName" : "number",
    "tableColumnId" : 112332160,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_9dfj-4gjx",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613930,
    "name" : "Civic Center Harm Reduction Project Boundary 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Civic Center Harm Reduction Project Boundary 2' (n4xg-c4py) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_n4xg_c4py",
    "position" : 69,
    "renderTypeName" : "number",
    "tableColumnId" : 112332161,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_n4xg-c4py",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613931,
    "name" : "Fix It Zones as of 2017-11-06  2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Fix It Zones as of 2017-11-06  2' (4isq-27mq) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_4isq_27mq",
    "position" : 70,
    "renderTypeName" : "number",
    "tableColumnId" : 112332162,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_4isq-27mq",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613932,
    "name" : "DELETE - HSOC Zones 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'DELETE - HSOC Zones 2' (fcz8-est8) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_fcz8_est8",
    "position" : 71,
    "renderTypeName" : "number",
    "tableColumnId" : 112332163,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_fcz8-est8",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613933,
    "name" : "Fix It Zones as of 2018-02-07 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Fix It Zones as of 2018-02-07 2' (pigm-ib2e) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_pigm_ib2e",
    "position" : 72,
    "renderTypeName" : "number",
    "tableColumnId" : 112332164,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_pigm-ib2e",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613934,
    "name" : "CBD, BID and GBD Boundaries as of 2017 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'CBD, BID and GBD Boundaries as of 2017 2' (9jxd-iqea) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_9jxd_iqea",
    "position" : 73,
    "renderTypeName" : "number",
    "tableColumnId" : 112332165,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_9jxd-iqea",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613935,
    "name" : "Areas of Vulnerability, 2016 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Areas of Vulnerability, 2016 2' (6pnf-4xz7) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_6pnf_4xz7",
    "position" : 74,
    "renderTypeName" : "number",
    "tableColumnId" : 112332166,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_6pnf-4xz7",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613936,
    "name" : "Central Market/Tenderloin Boundary 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Central Market/Tenderloin Boundary 2' (6ezc-tdp2) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_6ezc_tdp2",
    "position" : 75,
    "renderTypeName" : "number",
    "tableColumnId" : 112332167,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_6ezc-tdp2",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613937,
    "name" : "Central Market/Tenderloin Boundary Polygon - Updated 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Central Market/Tenderloin Boundary Polygon - Updated 2' (h4ep-8xdi) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_h4ep_8xdi",
    "position" : 76,
    "renderTypeName" : "number",
    "tableColumnId" : 112332168,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_h4ep-8xdi",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613938,
    "name" : "HSOC Zones as of 2018-06-05 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'HSOC Zones as of 2018-06-05 2' (nqbw-i6c3) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_nqbw_i6c3",
    "position" : 77,
    "renderTypeName" : "number",
    "tableColumnId" : 112332169,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_nqbw-i6c3",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613939,
    "name" : "OWED Public Spaces 2 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'OWED Public Spaces 2' (2dwj-jsy4) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_2dwj_jsy4",
    "position" : 78,
    "renderTypeName" : "number",
    "tableColumnId" : 112332170,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_2dwj-jsy4",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  }, {
    "id" : 611613940,
    "name" : "Neighborhoods 2",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'Neighborhoods' (jwn9-ihcz) the point in column 'location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_jwn9_ihcz",
    "position" : 79,
    "renderTypeName" : "number",
    "tableColumnId" : 112332171,
    "computationStrategy" : {
      "source_columns" : [ "location" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_jwn9-ihcz",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "license" : {
    "name" : "Open Data Commons Public Domain Dedication and License",
    "termsLink" : "http://opendatacommons.org/licenses/pddl/1.0/"
  },
  "metadata" : {
    "thumbnail" : {
      "page" : {
        "created" : true
      }
    },
    "rdfSubject" : "0",
    "attachments" : [ {
      "filename" : "20180416_Dataset_Change_Notice_-_Police_Incidents.pdf",
      "assetId" : "1938fceb-6c57-4063-841a-eff4b892b0bd",
      "name" : "20180416_Dataset_Change_Notice_-_Police_Incidents.pdf"
    } ],
    "custom_fields" : {
      "Department Metrics" : {
        "Publishing Department" : "Police Department"
      },
      "Internal Management" : {
        "Inventory ID" : "POL-0001"
      },
      "Publishing Details" : {
        "Data change frequency" : "Not updated (historical only)",
        "Program link" : "",
        "Publishing frequency" : "Not updated (historical only)",
        "Geographic unit" : ""
      }
    },
    "filterCondition" : {
      "metadata" : {
        "advanced" : true,
        "unifiedVersion" : 2
      },
      "children" : [ {
        "metadata" : {
          "tableColumnId" : {
            "289138" : 2155100
          },
          "operator" : "BETWEEN"
        },
        "type" : "operator",
        "value" : "OR"
      }, {
        "metadata" : {
          "tableColumnId" : {
            "289138" : 2155097
          },
          "operator" : "EQUALS"
        },
        "type" : "operator",
        "value" : "OR"
      }, {
        "metadata" : {
          "tableColumnId" : {
            "289138" : 2155096
          },
          "operator" : "EQUALS"
        },
        "type" : "operator",
        "value" : "OR"
      } ],
      "type" : "operator",
      "value" : "AND"
    },
    "rowIdentifier" : 611613906,
    "rowLabel" : "Incident Report",
    "availableDisplayTypes" : [ "table", "fatrow", "page" ],
    "renderTypeConfig" : {
      "visible" : {
        "table" : true
      }
    }
  },
  "owner" : {
    "id" : "dbag-6qd9",
    "displayName" : "OpenData",
    "screenName" : "OpenData",
    "type" : "interactive",
    "flags" : [ "acceptedEula" ]
  },
  "query" : { },
  "rights" : [ "read" ],
  "tableAuthor" : {
    "id" : "dbag-6qd9",
    "displayName" : "OpenData",
    "screenName" : "OpenData",
    "type" : "interactive",
    "flags" : [ "acceptedEula" ]
  },
  "tags" : [ "sfpd", "crime", "police department", "crime reports" ],
  "flags" : [ "default", "federated", "internalToPublicFederatedView", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}