units_with_maps

Table actions

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

1 row where ACRES = "5.302", MNG_AGENCY = 218 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • San Jacinto, City of · 1 ✖

DES_TP 1

ACCESS_TYP 1

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
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]);