superunits_with_maps

Table actions

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

8 rows where ACCESS_TYP = 1 and MNG_AGENCY = 215

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Livingston, City of · 8 ✖

ACCESS_TYP 1

  • Open Access · 8 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
493 493 492 {"type": "Polygon", "coordinates": [[[-120.73039, 37.37147], [-120.73038, 37.37207], [-120.73005, 37.37207], [-120.72997, 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 Frederick Worden Park https://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC=%7BCF892827-E8A2-4A7D-AE4A-C5FB926EE204%7D&DE=%7B27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1%7D 33509 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 2.237 Frederick Worden Park  
499 499 498 {"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 Don Meyer Park https://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC=%7BCF892827-E8A2-4A7D-AE4A-C5FB926EE204%7D&DE=%7B27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1%7D 33510 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1.955 Don Meyer Park  
500 500 499 {"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 Singh Park   33511 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1.458 Singh Park  
1531 1531 1530 {"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.37783], [-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 Arakelian Park   15551 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 8.091 Arakelian Park  
5421 5421 5420 {"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 Lucero Park   21578 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 1.205 Lucero Park  
6309 6309 6308 {"type": "Polygon", "coordinates": [[[-120.72329, 37.37722], [-120.72327, 37.37858], [-120.72104, 37.37854], [-120.72106, 37.37768], [-120.72094, 37.37766], [-120.72094, 37.37753], [-120.72296, 37.37755], [-120.72298, 37.37722], [-120.72329, 37.37722]]]} Open Access 1 Livingston Memorial Park   21384 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 5.828 Livingston Memorial Park  
6310 6310 6309 {"type": "Polygon", "coordinates": [[[-120.70787, 37.3895], [-120.70505, 37.38952], [-120.70508, 37.38762], [-120.70787, 37.38761], [-120.70787, 37.3895]]]} Open Access 1 Livingston Sports Complex   21385 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 12.916 Livingston Sports Complex  
11788 11788 11787 {"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 Joseph Gallo Park http://www.livingstoncity.com/index.asp?Type=B_BASIC&SEC={CF892827-E8A2-4A7D-AE4A-C5FB926EE204}&DE={27875D5D-2DDD-4E2A-BDEE-B2B4C34F36A1} 28408 1179 Livingston, City of 215 City 2 City Agency 2 http://www.livingstoncity.com/ City 2 6.477 Joseph Gallo Park  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);