units_with_maps

Table actions

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

504 rows where ACCESS_TYP = 1, COUNTY = 10 and DES_TP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 504 ✖
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
50 50 49 {"type": "MultiPolygon", "coordinates": [[[[-117.21301, 33.87552], [-117.21265, 33.8756], [-117.21258, 33.87543], [-117.21246, 33.87526], [-117.2123, 33.87511], [-117.21214, 33.87501], [-117.21187, 33.87491], [-117.21099, 33.87478], [-117.2109, 33.87468], [-117.21098, 33.87391], [-117.21278, 33.87393], [-117.21279, 33.8744], [-117.21285, 33.87488], [-117.21287, 33.87501], [-117.21289, 33.87505], [-117.21301, 33.87552]]], [[[-117.21735, 33.87448], [-117.21724, 33.87454], [-117.21542, 33.87452], [-117.21528, 33.87448], [-117.21519, 33.87448], [-117.21508, 33.87454], [-117.21502, 33.87462], [-117.21502, 33.87471], [-117.21505, 33.87477], [-117.21504, 33.87503], [-117.21332, 33.87502], [-117.21325, 33.87454], [-117.21324, 33.87428], [-117.21325, 33.87393], [-117.21469, 33.87393], [-117.2147, 33.87379], [-117.21734, 33.8738], [-117.21735, 33.87448]]]]} Open Access 1 116 El Potrero Park 18530 1216 Moreno Valley, City of 15 City 2 City Agency 2 http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml City 2 1216 Moreno Valley, City of 15 City 2 City Agency 2   Riverside 10 14.762 El Potrero Park 0 Local Park 2 4
96 96 95 {"type": "Polygon", "coordinates": [[[-117.17871, 33.90266], [-117.17628, 33.90268], [-117.17627, 33.90187], [-117.17869, 33.90186], [-117.17871, 33.90266]]]} Open Access 1 458 Fairway Park 18825 1216 Moreno Valley, City of 15 City 2 City Agency 2 http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml City 2 1216 Moreno Valley, City of 15 City 2 City Agency 2   Riverside 10 4.956 Fairway Park 0 Local Park 2 4
170 170 169 {"type": "Polygon", "coordinates": [[[-117.58627, 33.90811], [-117.58528, 33.90901], [-117.58385, 33.90792], [-117.58354, 33.90818], [-117.5835, 33.90816], [-117.58331, 33.90801], [-117.58316, 33.90784], [-117.5829, 33.90754], [-117.58289, 33.90749], [-117.58296, 33.90754], [-117.58312, 33.90759], [-117.58324, 33.90761], [-117.5834, 33.90761], [-117.58342, 33.90763], [-117.58365, 33.90757], [-117.58376, 33.90752], [-117.58409, 33.90744], [-117.58489, 33.90781], [-117.58627, 33.90811]]]} Open Access 1 453 Fairview Park 18816 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 5.215 Fairview Park 0 Local Park 2 4
215 215 214 {"type": "Polygon", "coordinates": [[[-116.19033, 33.67451], [-116.18815, 33.67451], [-116.18814, 33.6727], [-116.18825, 33.67269], [-116.18823, 33.67093], [-116.19033, 33.67094], [-116.19033, 33.67451]]]} Open Access 1 585 Bagdouma Park 15755 1061 Coachella, City of 87 City 2 City Agency 2 http://www.coachella.org/departments/public-works-department/parks-maintenance City 2 1061 Coachella, City of 85 City 2 City Agency 2   Riverside 10 19.434 Bagdouma Park 0 Local Park 2 4
253 253 252 {"type": "Polygon", "coordinates": [[[-117.6439, 33.87882], [-117.64373, 33.87913], [-117.64378, 33.8793], [-117.64325, 33.8791], [-117.64291, 33.87813], [-117.64282, 33.87707], [-117.64245, 33.87673], [-117.64226, 33.87545], [-117.64241, 33.87503], [-117.6425, 33.87503], [-117.6428, 33.87538], [-117.64305, 33.87624], [-117.64304, 33.87702], [-117.6435, 33.87842], [-117.64387, 33.8787], [-117.6439, 33.87882]]]} Open Access 1 703 Fresno Park 19112 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 5.323 Fresno Park 0 Local Park 2 4
350 350 349 {"type": "MultiPolygon", "coordinates": [[[[-117.00001, 33.75093], [-116.99805, 33.75095], [-116.99798, 33.75094], [-116.99796, 33.75088], [-116.99794, 33.74935], [-116.99795, 33.74933], [-116.99799, 33.7493], [-116.99803, 33.7493], [-116.99999, 33.74928], [-117.00001, 33.75093]]], [[[-116.99999, 33.74911], [-116.99803, 33.74912], [-116.99797, 33.74911], [-116.99795, 33.74908], [-116.99794, 33.74755], [-116.99795, 33.74752], [-116.998, 33.7475], [-116.99998, 33.74749], [-116.99999, 33.74911]]]]} Open Access 1 965 Gibbel Park 19285 1132 Hemet, City of 143 City 2 City Agency 2 http://www.cityofhemet.org/index.aspx?nid=95 City 2 1132 Hemet, City of 139 City 2 City Agency 2   Riverside 10 16.989 Gibbel Park 0 Local Park 2 4
431 431 430 {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} Open Access 1 48878 Goodhope Park 33599 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 3.022 Goodhope Park 0 Local Park 2 4
497 497 496 {"type": "Polygon", "coordinates": [[[-117.31082, 33.65409], [-117.31079, 33.65427], [-117.30502, 33.65344], [-117.30504, 33.65336], [-117.30568, 33.65345], [-117.30583, 33.65264], [-117.30709, 33.65186], [-117.30779, 33.65154], [-117.30788, 33.65166], [-117.30804, 33.65157], [-117.30845, 33.65132], [-117.30899, 33.65089], [-117.31082, 33.65409]]]} Open Access 1 48360 Summerly Community Park 32925 1389 Lake Elsinore, City of 187 City 2 City Agency 2 http://www.lake-elsinore.org/index.aspx?page=202 City 2 1389 Lake Elsinore, City of 183 City 2 City Agency 2 http://www.lake-elsinore.org/city-hall/community-services/parks-and-facilities/parks/summerly-park-2232#ad-image-3 Riverside 10 24.134 Summerly Community Park 2018 Local Park 2 4
499 499 498 {"type": "Polygon", "coordinates": [[[-117.44281, 33.92927], [-117.44007, 33.93082], [-117.44, 33.9307], [-117.4399, 33.93042], [-117.43981, 33.93026], [-117.43907, 33.92934], [-117.4391, 33.9293], [-117.44164, 33.92787], [-117.4417, 33.9279], [-117.44281, 33.92927]]]} Open Access 1 2014 Hunt Park 20152 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 13.779 Hunt Park 0 Local Park 2 4
510 510 509 {"type": "Polygon", "coordinates": [[[-117.00006, 33.73597], [-116.99795, 33.73602], [-116.99787, 33.73594], [-116.99784, 33.73368], [-116.99798, 33.73358], [-116.99829, 33.73353], [-116.99856, 33.73347], [-116.99886, 33.73338], [-116.99909, 33.73329], [-116.99932, 33.73318], [-116.99956, 33.73304], [-116.99994, 33.73276], [-117.00023, 33.73306], [-117.00035, 33.73324], [-117.00045, 33.73346], [-117.00049, 33.73372], [-117.00047, 33.73397], [-117.0004, 33.73417], [-117.0003, 33.73435], [-117.00012, 33.73457], [-117.00003, 33.7347], [-116.99995, 33.73487], [-116.99991, 33.73503], [-116.99988, 33.73524], [-116.9999, 33.73549], [-116.99994, 33.73565], [-117.00004, 33.73588], [-117.00006, 33.73597]]]} Open Access 1 1702 Mary Henley Park 21932 1132 Hemet, City of 143 City 2 City Agency 2 http://www.cityofhemet.org/index.aspx?nid=95 City 2 1132 Hemet, City of 139 City 2 City Agency 2   Riverside 10 16.139 Mary Henley Park 0 Local Park 2 4
539 539 538 {"type": "Polygon", "coordinates": [[[-117.26884, 33.97884], [-117.26877, 33.97891], [-117.26867, 33.97912], [-117.26867, 33.97921], [-117.26869, 33.97926], [-117.26861, 33.97934], [-117.26856, 33.97944], [-117.26852, 33.97949], [-117.26829, 33.97943], [-117.26791, 33.97943], [-117.26785, 33.9794], [-117.26774, 33.97913], [-117.26764, 33.97897], [-117.26754, 33.97876], [-117.26772, 33.97863], [-117.26778, 33.97864], [-117.26798, 33.97861], [-117.26804, 33.97883], [-117.26852, 33.9788], [-117.26884, 33.97884]]]} Open Access 1 1795 Hidden Springs Park 19913 1216 Moreno Valley, City of 15 City 2 City Agency 2 http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml City 2 1216 Moreno Valley, City of 15 City 2 City Agency 2   Riverside 10 1.73 Hidden Springs Park 0 Local Park 2 4
558 558 557 {"type": "Polygon", "coordinates": [[[-117.10871, 33.60376], [-117.10807, 33.60376], [-117.10803, 33.6038], [-117.10795, 33.60373], [-117.108, 33.60362], [-117.10791, 33.60312], [-117.10865, 33.60308], [-117.10871, 33.60312], [-117.10871, 33.60376]]]} Open Access 1 48385 Primrose Park 32949 2171 Valley-Wide Recreation and Park District 160 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/ Special District 4 2171 Valley-Wide Recreation and Park District 156 Special District 4 Recreation/Parks District 4 https://www.gorecreation.org/primrose-park Riverside 10 1.259 Primrose Park 0 Local Park 2 4
584 584 583 {"type": "Polygon", "coordinates": [[[-116.38667, 33.7023], [-116.3866, 33.7023], [-116.38658, 33.70202], [-116.38633, 33.70203], [-116.38633, 33.7023], [-116.38447, 33.7023], [-116.38441, 33.69954], [-116.38662, 33.69954], [-116.38665, 33.70043], [-116.38667, 33.7023]]]} Open Access 1 2198 Ironwood Park 20236 1240 Palm Desert, City of 215 City 2 City Agency 2 http://www.cityofpalmdesert.org/Index.aspx?page=174 City 2 1240 Palm Desert, City of 211 City 2 City Agency 2   Riverside 10 15.314 Ironwood Park 0 Local Park 2 4
593 593 592 {"type": "Polygon", "coordinates": [[[-117.34381, 34.00102], [-117.34008, 34.00101], [-117.34004, 34.00099], [-117.34002, 34.00096], [-117.34002, 33.9977], [-117.34004, 33.99767], [-117.34008, 33.99765], [-117.34377, 33.99765], [-117.34381, 34.00102]]]} Open Access 1 2017 Hunter Park 20153 1279 Riverside, City of 189 City 2 City Agency 2 http://www.riversideca.gov/park_rec/ City 2 1279 Riverside, City of 185 City 2 City Agency 2   Riverside 10 32.155 Hunter Park 0 Local Park 2 4
600 600 599 {"type": "Polygon", "coordinates": [[[-117.57342, 33.86906], [-117.57322, 33.87045], [-117.57284, 33.87041], [-117.57283, 33.87039], [-117.57278, 33.8704], [-117.57229, 33.87035], [-117.5725, 33.86899], [-117.57299, 33.86904], [-117.57299, 33.86906], [-117.57303, 33.86907], [-117.57305, 33.86902], [-117.57342, 33.86906]]]} Open Access 1 2051 Husted Park 20160 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 3.286 Husted Park 0 Local Park 2 4
607 607 606 {"type": "Polygon", "coordinates": [[[-116.20372, 33.73346], [-116.20136, 33.73345], [-116.20135, 33.73248], [-116.20244, 33.73249], [-116.20262, 33.73252], [-116.2029, 33.73262], [-116.20312, 33.73267], [-116.20332, 33.73268], [-116.20372, 33.73268], [-116.20372, 33.73346]]]} Open Access 1 2112 Cahuilla Park 16664 1145 Indio, City of 220 City 2 City Agency 2 http://www.indio.org/index.aspx?page=90 City 2 1145 Indio, City of 216 City 2 City Agency 2   Riverside 10 5.361 Cahuilla Park 0 Local Park 2 4
625 625 624 {"type": "Polygon", "coordinates": [[[-117.55597, 33.83411], [-117.55531, 33.83547], [-117.55479, 33.83646], [-117.55375, 33.83618], [-117.55329, 33.83601], [-117.55276, 33.83579], [-117.55424, 33.83354], [-117.55458, 33.83373], [-117.55476, 33.83382], [-117.55496, 33.83389], [-117.55532, 33.834], [-117.55597, 33.83411]]]} Open Access 1 2399 Jameson Park 20356 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 13.04 Jameson Park 0 Local Park 2 4
628 628 627 {"type": "Polygon", "coordinates": [[[-117.23715, 33.90138], [-117.23694, 33.90183], [-117.23693, 33.90257], [-117.237, 33.90264], [-117.23521, 33.90264], [-117.23515, 33.90258], [-117.23514, 33.90051], [-117.23541, 33.9008], [-117.23655, 33.9008], [-117.23661, 33.90095], [-117.23675, 33.90113], [-117.23694, 33.90127], [-117.23715, 33.90138]]]} Open Access 1 2466 JFK Veterans Memorial Park 20409 1216 Moreno Valley, City of 15 City 2 City Agency 2 http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml City 2 1216 Moreno Valley, City of 15 City 2 City Agency 2   Riverside 10 8.329 JFK Veterans Memorial Park 0 Local Park 2 4
664 664 663 {"type": "Polygon", "coordinates": [[[-117.59945, 33.85865], [-117.59934, 33.85933], [-117.59747, 33.85914], [-117.59758, 33.85844], [-117.59802, 33.85852], [-117.59872, 33.8586], [-117.59945, 33.85865]]]} Open Access 1 5052 Mangular Park 21745 1068 Corona, City of 65 City 2 City Agency 2 http://www.coronadwp.com/parkmaint/index.shtml City 2 1068 Corona, City of 63 City 2 City Agency 2   Riverside 10 3.259 Mangular Park 0 Local Park 2 4
686 686 685 {"type": "Polygon", "coordinates": [[[-117.3286, 33.66059], [-117.32833, 33.66191], [-117.32579, 33.66157], [-117.32607, 33.66022], [-117.3286, 33.66059]]]} Open Access 1 3497 Lake Point Park 28266 1389 Lake Elsinore, City of 187 City 2 City Agency 2 http://www.lake-elsinore.org/index.aspx?page=202 City 2 1389 Lake Elsinore, City of 183 City 2 City Agency 2   Riverside 10 8.839 Lake Point Park 0 Local Park 2 4

Next page

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