units_with_maps

Table actions

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

10 rows where AGNCY_NAME = 82 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 10 ✖

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
202 202 201 {"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 779 Furman Park 19152 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 14.404 Furman Park 0 Local Park 2 4
1259 1259 1258 {"type": "Polygon", "coordinates": [[[-118.12526, 33.91991], [-118.12315, 33.91992], [-118.12315, 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 5673 Independence Park 20190 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 9.238 Independence Park 0 Local Park 2 4
1468 1468 1467 {"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 10034 Rio San Gabriel Park 24386 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 16.595 Rio San Gabriel Park 0 Local Park 2 4
4023 4023 4022 {"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 44120 Crawford Park 17760 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 2.269 Crawford Park 0 Local Park 2 4
6123 6123 6122 {"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 1094 Golden Park 19368 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 8.088 Golden Park 0 Local Park 2 4
6855 6855 6854 {"type": "Polygon", "coordinates": [[[-118.15617, 33.92637], [-118.15568, 33.92701], [-118.15544, 33.92691], [-118.15442, 33.92824], [-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.15347, 33.92657], [-118.1543, 33.92547], [-118.15434, 33.92544], [-118.15442, 33.92545], [-118.15616, 33.92633], [-118.15617, 33.92637]]]} Open Access 1 5488 Apollo Park 15538 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 16.334 Apollo Park 0 Local Park 2 4
10480 10480 10479 {"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.11112, 33.95592], [-118.11139, 33.95544], [-118.11252, 33.95587]]]} Open Access 1 18564 Dennis the Menace Park 18091 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 5.767 Dennis the Menace Park 0 Local Park 2 4
10838 10838 10837 {"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 20614 Treasure Island Park 26518 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 3.731 Treasure Island Park 0 Local Park 2 4
10839 10839 10838 {"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 20615 Temple Park 26236 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 0.349 Temple Park 0 Local Park 2 4
10840 10840 10839 {"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.92113], [-118.14251, 33.92071], [-118.14282, 33.92088]]]} Open Access 1 20616 Brookshire Childrens Park 16430 1088 Downey, City of 82 City 2 City Agency 2 http://www.downeyca.org/services/cs/default.asp City 2 1088 Downey, City of 80 City 2 City Agency 2   Los Angeles 6 1.212 Brookshire Childrens 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]);