units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, AGNCY_LEV = 4, COUNTY = 10 and DES_TP = 14
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_WEB
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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]);