units_with_maps

Table actions

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

7 rows where COUNTY = 37, DES_TP = 2 and MNG_AGENCY = 215

This data as json, copyable, CSV (advanced)

Suggested facets: PARK_URL

MNG_AG_TYP 1

MNG_AGENCY 1

  • Livingston, City of · 7 ✖

DES_TP 1

  • Local Park · 7 ✖

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
595 595 594 {"type": "Polygon", "coordinates": [[[-120.70774, 37.37509], [-120.70769, 37.37584], [-120.70689, 37.37578], [-120.70694, 37.37503], [-120.70774, 37.37509]]]} Open Access 1 48788 Singh Park 33511 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 1.459 Singh Park 0 Local Park 2 4
3620 3620 3619 {"type": "Polygon", "coordinates": [[[-120.73039, 37.37147], [-120.73038, 37.37207], [-120.73005, 37.37207], [-120.72998, 37.37203], [-120.72969, 37.37208], [-120.72899, 37.37208], [-120.729, 37.37138], [-120.72985, 37.37139], [-120.73007, 37.37142], [-120.7302, 37.37147], [-120.73039, 37.37147]]]} Open Access 1 48786 Frederick Worden Park 33509 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2 https://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC=%7BCF892827-E8A2-4A7D-AE4A-C5FB926EE204%7D&DE=%7B27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1%7D Merced 37 2.237 Frederick Worden Park 0 Local Park 2 4
5208 5208 5207 {"type": "Polygon", "coordinates": [[[-120.71882, 37.39087], [-120.71829, 37.39134], [-120.71804, 37.39108], [-120.71769, 37.39086], [-120.71797, 37.39057], [-120.71824, 37.39065], [-120.71876, 37.39058], [-120.71882, 37.39087]]]} Open Access 1 17145 Lucero Park 21578 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 1.205 Lucero Park 0 Local Park 2 4
9962 9962 9961 {"type": "Polygon", "coordinates": [[[-120.73107, 37.37865], [-120.72983, 37.37865], [-120.72981, 37.37893], [-120.72971, 37.37898], [-120.72966, 37.37903], [-120.72963, 37.37909], [-120.72965, 37.37918], [-120.72964, 37.37954], [-120.72957, 37.3796], [-120.72862, 37.37959], [-120.72856, 37.37955], [-120.72857, 37.37907], [-120.72853, 37.379], [-120.72843, 37.37894], [-120.72842, 37.37865], [-120.72754, 37.37865], [-120.72756, 37.37787], [-120.72845, 37.37787], [-120.72857, 37.37793], [-120.72867, 37.37793], [-120.72875, 37.37789], [-120.72879, 37.37782], [-120.72879, 37.37776], [-120.72874, 37.3777], [-120.72894, 37.37753], [-120.72951, 37.37793], [-120.72985, 37.37814], [-120.73018, 37.37826], [-120.73076, 37.37842], [-120.73107, 37.37865]]]} Open Access 1 17136 Arakelian Park 15551 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 8.083 Arakelian Park 0 Local Park 2 4
9966 9966 9965 {"type": "Polygon", "coordinates": [[[-120.72329, 37.37722], [-120.72327, 37.37858], [-120.72104, 37.37854], [-120.72106, 37.37767], [-120.72094, 37.37766], [-120.72094, 37.37753], [-120.72297, 37.37755], [-120.72298, 37.37722], [-120.72329, 37.37722]]]} Open Access 1 17139 Livingston Memorial Park 21384 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2   Merced 37 5.824 Livingston Memorial Park 0 Local Park 2 4
12623 12623 12622 {"type": "Polygon", "coordinates": [[[-120.71049, 37.39404], [-120.70947, 37.39405], [-120.70947, 37.39319], [-120.71033, 37.39321], [-120.71033, 37.39336], [-120.71037, 37.39347], [-120.71046, 37.39362], [-120.71048, 37.39372], [-120.71049, 37.39404]]]} Open Access 1 48787 Don Meyer Park 33510 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2 https://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC=%7BCF892827-E8A2-4A7D-AE4A-C5FB926EE204%7D&DE=%7B27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1%7D Merced 37 1.956 Don Meyer Park 0 Local Park 2 4
14969 14969 14968 {"type": "Polygon", "coordinates": [[[-120.7368, 37.38008], [-120.73483, 37.38008], [-120.7349, 37.37987], [-120.73493, 37.37952], [-120.73494, 37.37898], [-120.73499, 37.37865], [-120.73679, 37.37865], [-120.7368, 37.38008]]]} Open Access 1 45582 Joseph Gallo Park 28408 1179 Livingston, City of 219 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC={CF892827-E8A2-4A7D-AE4A-C5FB926EE204}&DE={27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1} Merced 37 6.479 Joseph Gallo 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]);