superunits_with_maps

Table actions

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

12 rows where ACCESS_TYP = 1 and MNG_AGENCY = 80

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 12 ✖
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
1519 1519 1518 {"type": "Polygon", "coordinates": [[[-118.15617, 33.92637], [-118.15568, 33.92701], [-118.15544, 33.92691], [-118.15443, 33.92823], [-118.15443, 33.92825], [-118.15464, 33.92836], [-118.15424, 33.9289], [-118.1541, 33.92893], [-118.15225, 33.928], [-118.15337, 33.92652], [-118.15348, 33.92656], [-118.1543, 33.92547], [-118.15434, 33.92544], [-118.15442, 33.92545], [-118.15616, 33.92633], [-118.15617, 33.92637]]]} Open Access 1 Apollo Park   15538 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 16.337 Apollo Park  
1576 1576 1575 {"type": "Polygon", "coordinates": [[[-118.14282, 33.92088], [-118.1425, 33.92129], [-118.1422, 33.92159], [-118.14159, 33.92126], [-118.14183, 33.92094], [-118.14219, 33.92112], [-118.14251, 33.92071], [-118.14282, 33.92088]]]} Open Access 1 Brookshire Childrens Park   16430 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1.214 Brookshire Childrens Park  
3288 3288 3287 {"type": "Polygon", "coordinates": [[[-118.15791, 33.95195], [-118.15787, 33.95214], [-118.15728, 33.95269], [-118.15695, 33.95258], [-118.15694, 33.95266], [-118.15691, 33.95273], [-118.15662, 33.95298], [-118.1569, 33.95154], [-118.1574, 33.95173], [-118.15735, 33.95183], [-118.15736, 33.95184], [-118.15759, 33.95192], [-118.15764, 33.95183], [-118.15791, 33.95195]]]} Open Access 1 Crawford Park   17760 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 2.272 Crawford Park  
3565 3565 3564 {"type": "Polygon", "coordinates": [[[-118.11252, 33.95587], [-118.11228, 33.95619], [-118.11214, 33.95644], [-118.11198, 33.95659], [-118.11184, 33.95668], [-118.11162, 33.95675], [-118.1113, 33.95677], [-118.11105, 33.95675], [-118.11093, 33.95672], [-118.11027, 33.95647], [-118.10986, 33.95623], [-118.11031, 33.9554], [-118.11111, 33.95591], [-118.11139, 33.95544], [-118.11252, 33.95587]]]} Open Access 1 Dennis the Menace Park   18091 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 5.772 Dennis the Menace Park  
4454 4454 4453 {"type": "Polygon", "coordinates": [[[-118.13925, 33.95299], [-118.13784, 33.95493], [-118.13573, 33.95379], [-118.13714, 33.95185], [-118.13925, 33.95299]]]} Open Access 1 Furman Park   19152 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 14.403 Furman Park  
4638 4638 4637 {"type": "Polygon", "coordinates": [[[-118.14783, 33.90681], [-118.14677, 33.90837], [-118.14527, 33.90767], [-118.14563, 33.90705], [-118.1463, 33.90606], [-118.14725, 33.90651], [-118.14725, 33.90654], [-118.14783, 33.90681]]]} Open Access 1 Golden Park   19368 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 8.087 Golden Park  
5337 5337 5336 {"type": "Polygon", "coordinates": [[[-118.12526, 33.91991], [-118.12315, 33.91992], [-118.12314, 33.91972], [-118.12153, 33.91973], [-118.12153, 33.91885], [-118.12322, 33.91886], [-118.12526, 33.91886], [-118.12526, 33.91991]]]} Open Access 1 Independence Park   20190 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 9.239 Independence Park  
8727 8727 8726 {"type": "Polygon", "coordinates": [[[-118.11106, 33.93085], [-118.10961, 33.93279], [-118.10745, 33.93172], [-118.10755, 33.93156], [-118.1077, 33.93119], [-118.10794, 33.93047], [-118.10837, 33.92946], [-118.11106, 33.93085]]]} Open Access 1 Rio San Gabriel Park   24386 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 16.594 Rio San Gabriel Park  
10266 10266 10265 {"type": "Polygon", "coordinates": [[[-118.16038, 33.9419], [-118.16005, 33.94234], [-118.15984, 33.94222], [-118.15985, 33.94219], [-118.16015, 33.9418], [-118.1602, 33.9418], [-118.16038, 33.9419]]]} Open Access 1 Temple Park   26236 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 0.348 Temple Park  
10450 10450 10449 {"type": "Polygon", "coordinates": [[[-118.13423, 33.96639], [-118.12944, 33.9687], [-118.12842, 33.96921], [-118.12817, 33.96909], [-118.12902, 33.96866], [-118.13412, 33.96619], [-118.13423, 33.96639]]]} Open Access 1 Treasure Island Park   26518 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 3.731 Treasure Island Park  
11216 11216 11215 {"type": "Polygon", "coordinates": [[[-118.10543, 33.93264], [-118.10487, 33.93319], [-118.10081, 33.93783], [-118.10047, 33.93823], [-118.10017, 33.93865], [-118.09971, 33.93843], [-118.10032, 33.93761], [-118.10032, 33.93724], [-118.10116, 33.93525], [-118.10125, 33.93525], [-118.10344, 33.93344], [-118.10398, 33.93344], [-118.10463, 33.93269], [-118.105, 33.93223], [-118.10543, 33.93264]]]} Open Access 1 Wilderness Park   27512 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 18.458 Wilderness Park  
12514 12514 12513 {"type": "Polygon", "coordinates": [[[-118.13399, 33.91883], [-118.13399, 33.91936], [-118.13301, 33.91937], [-118.13302, 33.92017], [-118.13092, 33.92017], [-118.13085, 33.91977], [-118.13085, 33.91883], [-118.13399, 33.91883]]]} Open Access 1 Discovery Sports Complex   29633 1088 Downey, City of 80 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 8.659 Discovery Sports Complex  

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