superunits_with_maps

Table actions

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

4 rows where MNG_AGENCY = 516

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Firebaugh, City of · 4 ✖

ACCESS_TYP 1

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
683 683 682 {"type": "Polygon", "coordinates": [[[-120.45376, 36.85645], [-120.45339, 36.8567], [-120.45287, 36.85616], [-120.45324, 36.85591], [-120.45376, 36.85645]]]} Open Access 1 Library Park   21218 1107 Firebaugh, City of 516 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 0.807 Library Park  
877 877 876 {"type": "Polygon", "coordinates": [[[-120.46319, 36.86907], [-120.46091, 36.8691], [-120.46087, 36.86806], [-120.46317, 36.86804], [-120.46319, 36.86907]]]} Open Access 1 Maldonado Park   21697 1107 Firebaugh, City of 516 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 5.831 Maldonado Park  
1491 1491 1490 {"type": "Polygon", "coordinates": [[[-120.45327, 36.85931], [-120.45288, 36.85957], [-120.45288, 36.85961], [-120.45117, 36.85982], [-120.45094, 36.85983], [-120.45032, 36.86], [-120.4499, 36.86022], [-120.44966, 36.86037], [-120.44952, 36.86052], [-120.44829, 36.85938], [-120.44841, 36.85912], [-120.44868, 36.85886], [-120.44889, 36.85862], [-120.44897, 36.85833], [-120.4498, 36.8584], [-120.45047, 36.85836], [-120.45209, 36.85818], [-120.45215, 36.85822], [-120.45327, 36.85931]]]} Open Access 1 Andrew Firebaugh Historical Park   15484 1107 Firebaugh, City of 516 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 16.636 Andrew Firebaugh Historical Park  
3734 3734 3733 {"type": "Polygon", "coordinates": [[[-120.44996, 36.85605], [-120.44877, 36.8569], [-120.44787, 36.85628], [-120.44726, 36.85606], [-120.44677, 36.85593], [-120.44562, 36.85571], [-120.44725, 36.85447], [-120.44739, 36.8546], [-120.44752, 36.85454], [-120.44806, 36.85455], [-120.44811, 36.85459], [-120.4483, 36.85445], [-120.44996, 36.85605]]]} Open Access 1 Dunkle Park   18303 1107 Firebaugh, City of 516 City 2 City Agency 2 http://www.ci.firebaugh.ca.us/ City 2 12.846 Dunkle 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]);