units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 543 and MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11422 | 11422 | 11421 | {"type": "Polygon", "coordinates": [[[-121.23657, 38.39513], [-121.23642, 38.3951], [-121.23642, 38.39505], [-121.23657, 38.39498], [-121.23657, 38.39513]]]} | Unknown Access 4 | 22242 | Harrison Larry L/Tonya A | 19699 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.036 | Harrison Larry L/Tonya A | None 1012 | |||
10615 | 10615 | 10614 | {"type": "Polygon", "coordinates": [[[-121.20472, 38.7035], [-121.2046, 38.70349], [-121.20457, 38.70342], [-121.20458, 38.70338], [-121.20455, 38.70317], [-121.20444, 38.70303], [-121.2044, 38.70283], [-121.20439, 38.70266], [-121.2044, 38.70262], [-121.20442, 38.70261], [-121.20446, 38.70223], [-121.20448, 38.7022], [-121.20452, 38.70221], [-121.20453, 38.70223], [-121.20449, 38.70252], [-121.20448, 38.70283], [-121.20455, 38.70305], [-121.20463, 38.70314], [-121.20463, 38.70331], [-121.20464, 38.70339], [-121.20472, 38.7035]]]} | Open Access 1 | 22294 | 9101 Sunset Ave | 15222 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.246 | 9101 Sunset Ave | None 934 | |||
2876 | 2876 | 2875 | {"type": "Polygon", "coordinates": [[[-121.25202, 38.40904], [-121.25157, 38.40901], [-121.25157, 38.40891], [-121.25154, 38.40884], [-121.25164, 38.40866], [-121.25175, 38.40863], [-121.25192, 38.40869], [-121.25202, 38.40883], [-121.25202, 38.40904]]]} | Unknown Access 4 | 22243 | Schnabel Tentative Parcel Map | 25185 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.366 | Schnabel Tentative Parcel Map | None 240 | |||
2870 | 2870 | 2869 | {"type": "Polygon", "coordinates": [[[-121.26253, 38.63482], [-121.26223, 38.63496], [-121.26189, 38.63458], [-121.26213, 38.63445], [-121.26232, 38.63458], [-121.26253, 38.63482]]]} | Open Access 1 | 22211 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.387 | County Of Sacramento | None 238 | |||
12673 | 12673 | 12672 | {"type": "Polygon", "coordinates": [[[-121.09228, 38.49266], [-121.09217, 38.49275], [-121.09165, 38.49255], [-121.09152, 38.49227], [-121.09165, 38.49217], [-121.09228, 38.49266]]]} | Open Access 1 | 29637 | Cosumnes River Parkway | 17676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.435 | Cosumnes River Parkway | 0 | Local Recreation Area 3 | 4 | |
11141 | 11141 | 11140 | {"type": "Polygon", "coordinates": [[[-121.2683, 38.7177], [-121.26769, 38.71781], [-121.26746, 38.71783], [-121.26736, 38.71789], [-121.26714, 38.71792], [-121.26714, 38.71772], [-121.26729, 38.71769], [-121.26752, 38.71753], [-121.2683, 38.71752], [-121.2683, 38.7177]]]} | Restricted Access 2 | 21443 | Nevinshire | 22705 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.662 | Nevinshire | None 973 | |||
11418 | 11418 | 11417 | {"type": "Polygon", "coordinates": [[[-121.20133, 38.43685], [-121.20134, 38.43694], [-121.20132, 38.43704], [-121.20014, 38.43829], [-121.20013, 38.4383], [-121.20006, 38.4383], [-121.20003, 38.43827], [-121.20001, 38.43824], [-121.20036, 38.4379], [-121.20048, 38.43773], [-121.20071, 38.43749], [-121.20119, 38.43684], [-121.20129, 38.43682], [-121.20133, 38.43685]]]} | Restricted Access 2 | 22230 | John H Friend | 20444 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.684 | John H Friend | None 1010 | |||
11129 | 11129 | 11128 | {"type": "Polygon", "coordinates": [[[-121.20151, 38.69567], [-121.20151, 38.6958], [-121.20146, 38.69582], [-121.20067, 38.69581], [-121.20049, 38.69583], [-121.20049, 38.69539], [-121.20076, 38.69541], [-121.20151, 38.69567]]]} | Open Access 1 | 21441 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.758 | County Of Sacramento | None 970 | |||
3103 | 3103 | 3102 | {"type": "Polygon", "coordinates": [[[-121.19386, 38.68632], [-121.1938, 38.68658], [-121.19368, 38.68675], [-121.19349, 38.68696], [-121.19364, 38.68726], [-121.19279, 38.68725], [-121.19296, 38.68688], [-121.19322, 38.68659], [-121.19337, 38.68648], [-121.19386, 38.68632]]]} | Open Access 1 | 21437 | Hennemen | 19819 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.241 | Hennemen | None 252 | |||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
3104 | 3104 | 3103 | {"type": "Polygon", "coordinates": [[[-121.21365, 38.69062], [-121.21364, 38.69096], [-121.21285, 38.69062], [-121.21281, 38.69064], [-121.21278, 38.69063], [-121.21279, 38.6906], [-121.21277, 38.69058], [-121.21265, 38.69053], [-121.21197, 38.69046], [-121.21179, 38.69018], [-121.21179, 38.68988], [-121.21132, 38.68988], [-121.21132, 38.68978], [-121.21179, 38.68979], [-121.21215, 38.69], [-121.21225, 38.69001], [-121.21238, 38.69011], [-121.21327, 38.69049], [-121.21365, 38.69062]]]} | Open Access 1 | 21439 | Country Rose Estates | 17703 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.779 | Country Rose Estates | None 253 | |||
6291 | 6291 | 6290 | {"type": "Polygon", "coordinates": [[[-121.24447, 38.2956], [-121.24433, 38.29571], [-121.24395, 38.2959], [-121.24332, 38.29626], [-121.24327, 38.29627], [-121.24321, 38.29625], [-121.24323, 38.29563], [-121.24327, 38.29546], [-121.24333, 38.29535], [-121.24343, 38.29529], [-121.24365, 38.29521], [-121.24382, 38.29521], [-121.24402, 38.29524], [-121.24425, 38.29534], [-121.24431, 38.29542], [-121.24444, 38.29556], [-121.24447, 38.2956]]]} | Open Access 1 | 48884 | Herald Park | 33605 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | https://regionalparks.saccounty.net/SpecialEventsReservations/Pages/HeraldPark.aspx | Sacramento 41 | 1.953 | Herald Park | 0 | Local Park 2 | 4 |
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.025 | Hood-Franklin Drainage | None 266 | |||
11398 | 11398 | 11397 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | 22206 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.065 | Sunrise Rec./parks District | 0 | Local Recreation Area 3 | 4 | |
11284 | 11284 | 11283 | {"type": "MultiPolygon", "coordinates": [[[[-121.23771, 38.39477], [-121.23757, 38.39462], [-121.23747, 38.39463], [-121.23734, 38.39473], [-121.23716, 38.39492], [-121.23692, 38.39511], [-121.23671, 38.39514], [-121.23657, 38.39513], [-121.23657, 38.39498], [-121.23684, 38.39482], [-121.2369, 38.39472], [-121.23691, 38.39464], [-121.23685, 38.3946], [-121.23657, 38.39463], [-121.23657, 38.39415], [-121.23771, 38.39416], [-121.23771, 38.39477]]], [[[-121.23771, 38.39567], [-121.23728, 38.39532], [-121.23731, 38.39527], [-121.2374, 38.39523], [-121.23758, 38.3952], [-121.23771, 38.39516], [-121.23771, 38.39567]]]]} | Unknown Access 4 | 21836 | Poole Tina/gary M | 23892 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.148 | Poole Tina/gary M | None 987 | |||
11395 | 11395 | 11394 | {"type": "Polygon", "coordinates": [[[-121.26439, 38.63395], [-121.26357, 38.63433], [-121.26303, 38.63368], [-121.26299, 38.63358], [-121.263, 38.63348], [-121.26304, 38.6334], [-121.26311, 38.63333], [-121.26365, 38.63302], [-121.26439, 38.63395]]]} | Open Access 1 | 22207 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.396 | County Of Sacramento | None 1004 | |||
11376 | 11376 | 11375 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71543], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | 22186 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.539 | Atreule Et Al Community Plan | None 1000 | |||
11396 | 11396 | 11395 | {"type": "Polygon", "coordinates": [[[-121.26213, 38.63445], [-121.26039, 38.63544], [-121.25986, 38.63483], [-121.26152, 38.63391], [-121.26213, 38.63445]]]} | Open Access 1 | 22209 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.612 | County Of Sacramento | None 1005 | |||
11420 | 11420 | 11419 | {"type": "Polygon", "coordinates": [[[-121.32403, 38.45886], [-121.32211, 38.45886], [-121.32212, 38.45801], [-121.32285, 38.45764], [-121.3229, 38.45763], [-121.32403, 38.45886]]]} | Open Access 1 | 22238 | Silver Leaf Park | 25490 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.643 | Silver Leaf Park | 0 | Local Park 2 | 4 | |
11411 | 11411 | 11410 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | 22248 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.291 | Lotus Pond Drainage | 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]);