superunits_with_maps

Table actions

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

10 rows where MNG_AGENCY = 103

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Rialto, City of · 10 ✖

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
1067 1067 1066 {"type": "Polygon", "coordinates": [[[-117.42271, 34.16041], [-117.42182, 34.15997], [-117.42155, 34.15987], [-117.42129, 34.15982], [-117.42094, 34.15978], [-117.41877, 34.15978], [-117.41874, 34.15977], [-117.41872, 34.15973], [-117.41872, 34.15913], [-117.42114, 34.15907], [-117.42116, 34.15881], [-117.42165, 34.15881], [-117.42166, 34.15911], [-117.4227, 34.1591], [-117.42271, 34.16041]]]} Open Access 1 Alec Fergusson Park   15352 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 8.289 Alec Fergusson Park  
1178 1178 1177 {"type": "Polygon", "coordinates": [[[-117.38123, 34.08863], [-117.37915, 34.08864], [-117.37914, 34.08773], [-117.38122, 34.08773], [-117.38123, 34.08863]]]} Open Access 1 Anderson Park   15478 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 4.784 Anderson Park  
2032 2032 2031 {"type": "Polygon", "coordinates": [[[-117.40091, 34.14811], [-117.39884, 34.14812], [-117.39884, 34.14676], [-117.40084, 34.14675], [-117.40084, 34.14764], [-117.40091, 34.14766], [-117.40091, 34.14811]]]} Open Access 1 Birdsall Park   16123 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 6.956 Birdsall Park  
2331 2331 2330 {"type": "Polygon", "coordinates": [[[-117.379, 34.10313], [-117.37692, 34.10313], [-117.37692, 34.10156], [-117.379, 34.10155], [-117.379, 34.10313]]]} Open Access 1 Bud Bender Park   16478 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 8.327 Bud Bender Park  
4275 4275 4274 {"type": "Polygon", "coordinates": [[[-117.39137, 34.11506], [-117.39122, 34.11519], [-117.39118, 34.11519], [-117.39112, 34.11521], [-117.39035, 34.11521], [-117.39005, 34.11512], [-117.39004, 34.11413], [-117.39124, 34.11413], [-117.39124, 34.11436], [-117.39136, 34.1144], [-117.39137, 34.11506]]]} Open Access 1 Flores Park   18962 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 3.483 Flores Park  
4431 4431 4430 {"type": "MultiPolygon", "coordinates": [[[[-117.36134, 34.13414], [-117.36044, 34.13413], [-117.35976, 34.13403], [-117.35946, 34.134], [-117.35748, 34.134], [-117.35744, 34.13395], [-117.35744, 34.13232], [-117.35952, 34.13231], [-117.35953, 34.1325], [-117.36134, 34.13414]]], [[[-117.36159, 34.13433], [-117.36161, 34.13552], [-117.36157, 34.13564], [-117.36064, 34.13558], [-117.36062, 34.13562], [-117.36025, 34.1356], [-117.35802, 34.13514], [-117.35779, 34.13507], [-117.35765, 34.13499], [-117.35753, 34.13488], [-117.35745, 34.13473], [-117.35745, 34.13419], [-117.35943, 34.13418], [-117.35973, 34.1342], [-117.36018, 34.13429], [-117.36044, 34.13431], [-117.36062, 34.13432], [-117.36064, 34.13431], [-117.36159, 34.13433]]]]} Open Access 1 Frisbie Park   19125 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 24.7 Frisbie Park  
5521 5521 5520 {"type": "Polygon", "coordinates": [[[-117.39227, 34.12865], [-117.39146, 34.12865], [-117.39024, 34.12701], [-117.38904, 34.12385], [-117.39061, 34.12445], [-117.391, 34.12466], [-117.39135, 34.12493], [-117.39226, 34.12493], [-117.39227, 34.12865]]]} Open Access 1 Jerry Eaves Park   20400 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 21.632 Jerry Eaves Park  
6627 6627 6626 {"type": "Polygon", "coordinates": [[[-117.37464, 34.10245], [-117.37387, 34.10245], [-117.37386, 34.10284], [-117.37293, 34.10284], [-117.37293, 34.10166], [-117.37464, 34.10166], [-117.37464, 34.10245]]]} Open Access 1 Margaret Todd Park   21803 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 4.332 Margaret Todd Park  
8656 8656 8655 {"type": "Polygon", "coordinates": [[[-117.37017, 34.07956], [-117.36602, 34.07956], [-117.36601, 34.07783], [-117.37016, 34.07783], [-117.37017, 34.07956]]]} Open Access 1 Rialto City Park   24315 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 18.213 Rialto City Park  
8658 8658 8657 {"type": "Polygon", "coordinates": [[[-117.37692, 34.10313], [-117.37483, 34.10313], [-117.37483, 34.10156], [-117.37691, 34.10156], [-117.37692, 34.10313]]]} Open Access 1 Rialto Park Cemetery   24316 1273 Rialto, City of 103 City 2 City Agency 2 http://www.rialtoca.gov/ City 2 8.303 Rialto Park Cemetery  

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