units_with_maps

Table actions

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

3 rows where ACRES = "5.302" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 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
4786 4786 4785 {"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]]]} No Public Access 3 47661 Unnamed site - San Diego, City of 31719 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 5.302   0 Local Other or Unknown 14 4
7355 7355 7354 {"type": "Polygon", "coordinates": [[[-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77172], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10417, 33.77181], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788]]]} Open Access 1 6680 Channel View Park 17123 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 5.302 Channel View Park 1968 Local Park 2 4
14896 14896 14895 {"type": "MultiPolygon", "coordinates": [[[[-116.98416, 33.80825], [-116.98321, 33.80894], [-116.98286, 33.80865], [-116.98315, 33.80843], [-116.98327, 33.80845], [-116.98338, 33.80841], [-116.98353, 33.80827], [-116.98385, 33.80804], [-116.98391, 33.80804], [-116.98416, 33.80825]]], [[[-116.98521, 33.80747], [-116.98431, 33.80814], [-116.98407, 33.80794], [-116.98407, 33.80787], [-116.9849, 33.80726], [-116.98497, 33.80727], [-116.98521, 33.80747]]], [[[-116.9863, 33.80667], [-116.98536, 33.80736], [-116.98512, 33.80716], [-116.98512, 33.8071], [-116.98596, 33.80648], [-116.98607, 33.80649], [-116.9863, 33.80667]]], [[[-116.98763, 33.80587], [-116.9867, 33.80666], [-116.98627, 33.80631], [-116.98626, 33.80621], [-116.98663, 33.80589], [-116.98684, 33.80563], [-116.98689, 33.80566], [-116.98705, 33.80554], [-116.98696, 33.80545], [-116.98701, 33.80539], [-116.98729, 33.80514], [-116.9874, 33.80507], [-116.98746, 33.80512], [-116.9871, 33.80543], [-116.98763, 33.80587]]]]} Open Access 1 45447 Skyview Park 28245 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html Riverside 10 5.302 Skyview 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]);