units_with_maps

Table actions

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

9 rows where ACCESS_TYP = 1, COUNTY = 10 and DES_TP = 14

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 9 ✖
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
4485 4485 4484 {"type": "Polygon", "coordinates": [[[-116.23302, 33.58134], [-116.23293, 33.58128], [-116.23136, 33.57741], [-116.23092, 33.57648], [-116.22951, 33.57441], [-116.22812, 33.57509], [-116.22717, 33.57368], [-116.22436, 33.5737], [-116.22436, 33.57461], [-116.22274, 33.57463], [-116.22139, 33.57376], [-116.22098, 33.57302], [-116.22093, 33.57256], [-116.22053, 33.57243], [-116.22029, 33.57202], [-116.21854, 33.57148], [-116.21604, 33.57082], [-116.21605, 33.56939], [-116.22448, 33.56938], [-116.22417, 33.57223], [-116.22418, 33.57224], [-116.22904, 33.56937], [-116.233, 33.56936], [-116.23299, 33.57257], [-116.23302, 33.58134]]]} Open Access 1 4461 Unnamed site - Riverside County Regional Park and Open Space District 28656 2123 Riverside County Regional Park and Open Space District 262 Special District 4 Recreation/Parks District 4 http://www.riversidecountyparks.org/ Special District 4 2123 Riverside County Regional Park and Open Space District 258 Special District 4 Recreation/Parks District 4   Riverside 10 187.128   0 Local Other or Unknown 14 4
4611 4611 4610 {"type": "Polygon", "coordinates": [[[-116.61537, 33.98365], [-116.61085, 33.98366], [-116.61082, 33.98821], [-116.60649, 33.98822], [-116.60648, 33.98541], [-116.60215, 33.98543], [-116.60214, 33.98822], [-116.60433, 33.98822], [-116.60433, 33.99003], [-116.59774, 33.99004], [-116.59775, 33.98278], [-116.61537, 33.98276], [-116.61537, 33.98365]], [[-116.59886, 33.98636], [-116.59885, 33.98823], [-116.59995, 33.98822], [-116.59995, 33.98637], [-116.59886, 33.98636]]]} Open Access 1 35753 Unnamed site - Riverside County Regional Park and Open Space District 28656 2123 Riverside County Regional Park and Open Space District 262 Special District 4 Recreation/Parks District 4 http://www.riversidecountyparks.org/ Special District 4 2123 Riverside County Regional Park and Open Space District 258 Special District 4 Recreation/Parks District 4   Riverside 10 185.049   0 Local Other or Unknown 14 4
4811 4811 4810 {"type": "MultiPolygon", "coordinates": [[[[-116.17648, 33.65882], [-116.17551, 33.65885], [-116.17552, 33.65917], [-116.1746, 33.65917], [-116.17461, 33.65886], [-116.17358, 33.65883], [-116.17359, 33.6586], [-116.17464, 33.65859], [-116.17464, 33.65831], [-116.17549, 33.6583], [-116.1755, 33.65862], [-116.17648, 33.65862], [-116.17648, 33.65882]]], [[[-116.17574, 33.66166], [-116.17574, 33.66187], [-116.1754, 33.66187], [-116.17504, 33.6621], [-116.17496, 33.66203], [-116.17489, 33.66202], [-116.17482, 33.66204], [-116.17481, 33.66149], [-116.17492, 33.66149], [-116.17498, 33.66147], [-116.17504, 33.66142], [-116.17539, 33.66166], [-116.17574, 33.66166]]], [[[-116.19303, 33.68161], [-116.19296, 33.68172], [-116.19289, 33.68177], [-116.19292, 33.68184], [-116.1928, 33.68189], [-116.19267, 33.68191], [-116.19261, 33.68184], [-116.19246, 33.68182], [-116.19233, 33.68172], [-116.19228, 33.68156], [-116.19214, 33.68149], [-116.19227, 33.68132], [-116.19231, 33.68132], [-116.19246, 33.68121], [-116.19258, 33.68118], [-116.19266, 33.68118], [-116.1927, 33.68112], [-116.19283, 33.68117], [-116.19292, 33.68123], [-116.19293, 33.68128], [-116.19297, 33.68133], [-116.19303, 33.6815], [-116.19303, 33.68161]]]]} Open Access 1 48659 Unknown park - Coachella, City of 33406 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 5.202   0 Local Other or Unknown 14 4
4815 4815 4814 {"type": "Polygon", "coordinates": [[[-116.07451, 33.56924], [-116.07349, 33.56924], [-116.07349, 33.56872], [-116.07451, 33.56872], [-116.07451, 33.56924]]]} Open Access 1 48766 Unknown Park - Riverside, County of 33493 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 1.339   0 Local Other or Unknown 14 4
4816 4816 4815 {"type": "Polygon", "coordinates": [[[-117.01983, 33.78712], [-117.01846, 33.78712], [-117.01837, 33.78705], [-117.01838, 33.78608], [-117.01843, 33.78604], [-117.019, 33.78604], [-117.01925, 33.78607], [-117.01936, 33.78603], [-117.01943, 33.78595], [-117.01981, 33.78608], [-117.01983, 33.78712]]]} Open Access 1 48837 Unknown park - San Jacinto, City of 33557 1416 San Jacinto, City of 222 City 2 City Agency 2 http://www.ci.san-jacinto.ca.us/residents/parks.html City 2 1416 San Jacinto, City of 218 City 2 City Agency 2   Riverside 10 3.986   0 Local Other or Unknown 14 4
5279 5279 5278 {"type": "Polygon", "coordinates": [[[-117.25814, 33.7139], [-117.25811, 33.71948], [-117.25803, 33.72838], [-117.24077, 33.72856], [-117.24065, 33.72142], [-117.24062, 33.71414], [-117.25808, 33.71387], [-117.25809, 33.7139], [-117.25814, 33.7139]]]} Open Access 1 2650 Kabian Park Property 20539 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 640.487 Kabian Park Property 0 Local Other or Unknown 14 4
6042 6042 6041 {"type": "Polygon", "coordinates": [[[-117.65215, 33.91871], [-117.64965, 33.91869], [-117.64963, 33.91329], [-117.64196, 33.91325], [-117.6368, 33.91461], [-117.63649, 33.91401], [-117.63211, 33.91406], [-117.63198, 33.92449], [-117.61542, 33.92423], [-117.6155, 33.9172], [-117.61201, 33.91687], [-117.61099, 33.91712], [-117.61093, 33.91], [-117.61042, 33.90998], [-117.60852, 33.90661], [-117.60981, 33.90566], [-117.61023, 33.90544], [-117.61403, 33.90399], [-117.61585, 33.90723], [-117.61654, 33.90805], [-117.62002, 33.90681], [-117.61703, 33.90146], [-117.62021, 33.90047], [-117.62321, 33.90627], [-117.62773, 33.90538], [-117.62828, 33.90487], [-117.62877, 33.90524], [-117.62922, 33.90485], [-117.62938, 33.90451], [-117.63377, 33.90252], [-117.63468, 33.90175], [-117.63411, 33.90051], [-117.6344, 33.90024], [-117.63575, 33.89949], [-117.6367, 33.89833], [-117.63715, 33.89744], [-117.63777, 33.89583], [-117.63815, 33.89533], [-117.63787, 33.89465], [-117.63809, 33.89455], [-117.64133, 33.89494], [-117.6414, 33.89486], [-117.64357, 33.89614], [-117.64346, 33.89661], [-117.64359, 33.89693], [-117.64413, 33.89697], [-117.64444, 33.89741], [-117.64431, 33.8977], [-117.64438, 33.89793], [-117.6446, 33.89808], [-117.64367, 33.90155], [-117.64126, 33.90291], [-117.64084, 33.90235], [-117.64034, 33.90266], [-117.64073, 33.90329], [-117.63463, 33.90713], [-117.6359, 33.90998], [-117.64167, 33.90822], [-117.64723, 33.90655], [-117.6477, 33.90653], [-117.64788, 33.90706], [-117.64792, 33.90749], [-117.64857, 33.90928], [-117.64873, 33.90925], [-117.65215, 33.91871]]]} Open Access 1 47356 Prado Flood Control Basin 31073 2105 Orange County Water District 768 Special District 4 Water District 13 http://www.ocwd.com/ Special District 4 2105 Orange County Water District 749 Special District 4 Water District 13   Riverside 10 1464.541 Prado Flood Control Basin 0 Local Other or Unknown 14 4
8010 8010 8009 {"type": "MultiPolygon", "coordinates": [[[[-116.02639, 33.51813], [-116.02637, 33.5256], [-116.00908, 33.52564], [-116.00908, 33.51812], [-116.02639, 33.51813]]], [[[-115.9917, 33.52561], [-115.97426, 33.52554], [-115.97415, 33.51817], [-115.99159, 33.51815], [-115.9917, 33.52561]]], [[[-116.08721, 33.51054], [-116.08721, 33.51421], [-116.08313, 33.51422], [-116.08312, 33.5179], [-116.07905, 33.51792], [-116.07904, 33.51054], [-116.06996, 33.51054], [-116.06116, 33.51058], [-116.06111, 33.50026], [-116.06106, 33.49907], [-116.04367, 33.4991], [-116.04385, 33.4845], [-116.02647, 33.48448], [-116.02633, 33.49919], [-116.00918, 33.49928], [-116.00907, 33.48449], [-115.99116, 33.48451], [-115.99116, 33.49919], [-115.9738, 33.49918], [-115.97404, 33.5108], [-115.95654, 33.51085], [-115.95674, 33.52541], [-115.94386, 33.52537], [-115.9438, 33.52174], [-115.9395, 33.52173], [-115.93932, 33.51085], [-115.95652, 33.51085], [-115.95651, 33.50987], [-115.9563, 33.5002], [-115.95643, 33.49917], [-115.93907, 33.49918], [-115.93919, 33.4846], [-115.94781, 33.48458], [-115.94784, 33.48133], [-115.95216, 33.48126], [-115.95214, 33.48458], [-115.95644, 33.48457], [-115.95644, 33.49916], [-115.97378, 33.49918], [-115.97379, 33.49917], [-115.97371, 33.48456], [-115.95645, 33.48456], [-115.95658, 33.47012], [-115.93925, 33.47013], [-115.93931, 33.45556], [-115.9393, 33.45555], [-115.92196, 33.45559], [-115.92197, 33.44092], [-115.90467, 33.44096], [-115.90465, 33.45563], [-115.88728, 33.45568], [-115.88727, 33.441], [-115.87582, 33.44116], [-115.86951, 33.44116], [-115.86945, 33.42685], [-115.87438, 33.42687], [-115.88723, 33.42686], [-115.88728, 33.44099], [-115.90466, 33.44096], [-115.9047, 33.42684], [-115.9221, 33.4268], [-115.92198, 33.44092], [-115.93937, 33.44093], [-115.9393, 33.45555], [-115.95671, 33.45554], [-115.95674, 33.45552], [-115.95683, 33.44096], [-115.93939, 33.44093], [-115.93946, 33.42674], [-115.95693, 33.42668], [-115.95683, 33.44096], [-115.97422, 33.44094], [-115.97424, 33.44093], [-115.97442, 33.42663], [-115.98341, 33.4266], [-115.99201, 33.42654], [-115.9918, 33.44093], [-116.00081, 33.44091], [-116.00913, 33.44086], [-116.00921, 33.42648], [-116.0265, 33.42635], [-116.02646, 33.44084], [-116.04392, 33.44081], [-116.04391, 33.45541], [-116.05245, 33.45538], [-116.05247, 33.46264], [-116.06106, 33.4626], [-116.06111, 33.46984], [-116.07886, 33.46979], [-116.07885, 33.48439], [-116.08713, 33.48429], [-116.08717, 33.49528], [-116.08304, 33.4953], [-116.08305, 33.49895], [-116.07892, 33.49896], [-116.079, 33.50032], [-116.07905, 33.51053], [-116.08721, 33.51054]], [[-115.99114, 33.48451], [-115.99135, 33.4701], [-115.97388, 33.47012], [-115.97372, 33.48455], [-115.99114, 33.48451]], [[-115.97388, 33.47012], [-115.9741, 33.45549], [-115.95674, 33.45553], [-115.95672, 33.45555], [-115.95658, 33.47012], [-115.97388, 33.47012]], [[-116.0091, 33.47005], [-116.00912, 33.45545], [-115.99162, 33.45548], [-115.99136, 33.4701], [-116.00084, 33.47011], [-116.0091, 33.47005]], [[-116.04381, 33.46994], [-116.04391, 33.45541], [-116.02647, 33.45544], [-116.02647, 33.47003], [-116.04381, 33.46994]], [[-116.06115, 33.48444], [-116.06111, 33.46984], [-116.04382, 33.46994], [-116.04386, 33.4845], [-116.06115, 33.48444]], [[-116.07885, 33.48441], [-116.06116, 33.48445], [-116.06107, 33.49906], [-116.07892, 33.49895], [-116.07885, 33.48441]], [[-116.02646, 33.48448], [-116.02646, 33.47004], [-116.00911, 33.47006], [-116.00908, 33.48449], [-116.02646, 33.48448]], [[-115.9918, 33.44093], [-115.97424, 33.44095], [-115.97411, 33.45548], [-115.99161, 33.45547], [-115.99181, 33.44094], [-115.9918, 33.44093]], [[-116.02646, 33.44086], [-116.02645, 33.44085], [-116.00914, 33.44087], [-116.00912, 33.45545], [-116.02646, 33.45544], [-116.02646, 33.44086]]], [[[-116.04379, 33.52553], [-116.04379, 33.52917], [-116.03943, 33.52918], [-116.03943, 33.52555], [-116.04379, 33.52553]]], [[[-116.07904, 33.5253], [-116.07902, 33.52898], [-116.07016, 33.52902], [-116.07016, 33.5327], [-116.06574, 33.53272], [-116.06571, 33.52536], [-116.07904, 33.5253]]]]} Open Access 1 12966 Salton Sea - Irrigation District 4595 2048 Imperial Irrigation District 379 Special District 4 Irrigation District 17 http://www.iid.com/ Special District 4 2048 Imperial Irrigation District 374 Special District 4 Irrigation District 16   Riverside 10 16954.91 Salton Sea - Irrigation District 0 Local Other or Unknown 14 4
10537 10537 10536 {"type": "Polygon", "coordinates": [[[-117.11988, 33.71789], [-117.11539, 33.71793], [-117.11537, 33.72508], [-117.11986, 33.72504], [-117.11979, 33.72862], [-117.1023, 33.72895], [-117.10226, 33.72172], [-117.10216, 33.7145], [-117.10576, 33.71446], [-117.10651, 33.71438], [-117.11099, 33.71433], [-117.11139, 33.71453], [-117.11318, 33.71473], [-117.11586, 33.71436], [-117.11982, 33.71433], [-117.11988, 33.71789]]]} Open Access 1 18750 Double Butte Park Property 18237 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 560.311 Double Butte Park Property 0 Local Other or Unknown 14 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]);