units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

3 rows where ACCESS_TYP = 1, LABEL_NAME = "Vincent Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 3 ✖

DES_TP 1

ACCESS_TYP 1

  • Open Access · 3 ✖
Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
1018 1018 1017 {"type": "MultiPolygon", "coordinates": [[[[-118.34823, 33.97142], [-118.34633, 33.97248], [-118.34403, 33.97374], [-118.34402, 33.97333], [-118.34404, 33.97312], [-118.34403, 33.97217], [-118.34405, 33.97163], [-118.344, 33.9716], [-118.3472, 33.9701], [-118.34823, 33.97142]]], [[[-118.344, 33.97165], [-118.34398, 33.97217], [-118.34399, 33.97312], [-118.34396, 33.97333], [-118.34398, 33.97377], [-118.34396, 33.97379], [-118.34395, 33.97549], [-118.34233, 33.97551], [-118.34231, 33.97592], [-118.34171, 33.97593], [-118.34101, 33.97615], [-118.34058, 33.97617], [-118.34056, 33.97553], [-118.33999, 33.97552], [-118.34, 33.97349], [-118.34396, 33.97163], [-118.344, 33.97165]]]]} Open Access 1 6288 Vincent Park 27127 1147 Inglewood, City of 277 City 2 City Agency 2 http://www.cityofinglewood.org/depts/parks_recreation_and_library_services/default.asp City 2 1147 Inglewood, City of 272 City 2 City Agency 2   Los Angeles 6 50.732 Vincent Park 0 Local Park 2 4
5183 5183 5182 {"type": "Polygon", "coordinates": [[[-122.35179, 37.90776], [-122.35177, 37.90908], [-122.3502, 37.90905], [-122.35016, 37.90782], [-122.35179, 37.90776]]]} Open Access 1 13124 Vincent Park 27129 1274 Richmond, City of 20 City 2 City Agency 2 http://www.ci.richmond.ca.us/index.aspx?NID=2075 City 2 1274 Richmond, City of 20 City 2 City Agency 2   Contra Costa 12 4.919 Vincent Park 0 Local Park 2 4
7063 7063 7062 {"type": "MultiPolygon", "coordinates": [[[[-118.38413, 33.84424], [-118.3838, 33.84437], [-118.38362, 33.84405], [-118.3836, 33.84397], [-118.38363, 33.8439], [-118.38368, 33.84385], [-118.38376, 33.84383], [-118.38386, 33.84383], [-118.38392, 33.84387], [-118.38397, 33.84393], [-118.38413, 33.84424]]], [[[-118.38438, 33.84494], [-118.38429, 33.84499], [-118.3841, 33.84497], [-118.38404, 33.8449], [-118.38388, 33.84456], [-118.38423, 33.84445], [-118.38441, 33.84478], [-118.38441, 33.84486], [-118.38438, 33.84494]]]]} Open Access 1 6061 Vincent Park 27128 1270 Redondo Beach, City of 246 City 2 City Agency 2 http://www.redondo.org City 2 1270 Redondo Beach, City of 242 City 2 City Agency 2   Los Angeles 6 0.925 Vincent Park 0 Local Park 2 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);