units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where ACCESS_TYP = 1, AGNCY_TYP = 3 and MNG_AGENCY = 543 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 14
- Local Park 7
- Local Recreation Area 6
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Sacramento, County of · 25 ✖
ACCESS_TYP 1
- Open Access · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
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 | |||
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 |
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 | |||
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 | |
11386 | 11386 | 11385 | {"type": "Polygon", "coordinates": [[[-121.20158, 38.69514], [-121.20156, 38.69574], [-121.20155, 38.69578], [-121.20151, 38.69581], [-121.20151, 38.69567], [-121.20076, 38.69541], [-121.19937, 38.6953], [-121.19888, 38.69513], [-121.19834, 38.6949], [-121.19795, 38.69477], [-121.19761, 38.69473], [-121.19711, 38.69472], [-121.19713, 38.69437], [-121.19853, 38.6944], [-121.19854, 38.6945], [-121.19884, 38.69451], [-121.19885, 38.69441], [-121.19949, 38.69442], [-121.19948, 38.69492], [-121.2004, 38.69496], [-121.20158, 38.69514]]]} | Open Access 1 | 22192 | 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 | 5.168 | County Of Sacramento | None 1001 | |||
10591 | 10591 | 10590 | {"type": "Polygon", "coordinates": [[[-121.325, 38.58998], [-121.32489, 38.59], [-121.32456, 38.58892], [-121.32454, 38.58891], [-121.32255, 38.59098], [-121.32204, 38.59149], [-121.32194, 38.59124], [-121.32446, 38.58862], [-121.3242, 38.58776], [-121.32414, 38.58775], [-121.32412, 38.58766], [-121.32308, 38.58433], [-121.32305, 38.5841], [-121.32175, 38.57992], [-121.32185, 38.57986], [-121.325, 38.58998]]]} | Open Access 1 | 22215 | 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 | 5.396 | County Of Sacramento | None 933 | |||
4818 | 4818 | 4817 | {"type": "Polygon", "coordinates": [[[-121.29822, 38.56886], [-121.29831, 38.56987], [-121.29827, 38.56998], [-121.29811, 38.57016], [-121.29803, 38.57031], [-121.29801, 38.57042], [-121.29796, 38.57085], [-121.29785, 38.57059], [-121.29782, 38.57043], [-121.29777, 38.57032], [-121.29767, 38.57021], [-121.29744, 38.57006], [-121.29737, 38.56997], [-121.29734, 38.5699], [-121.29716, 38.5679], [-121.29813, 38.56784], [-121.29822, 38.56886]]]} | Open Access 1 | 48883 | Unknown park - Sacramento, County of | 33604 | 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 | 5.539 | 0 | Local Other or Unknown 14 | 4 | ||
11151 | 11151 | 11150 | {"type": "Polygon", "coordinates": [[[-121.20538, 38.65866], [-121.20428, 38.65916], [-121.20345, 38.65918], [-121.20385, 38.65822], [-121.20389, 38.65804], [-121.20397, 38.65732], [-121.20401, 38.65732], [-121.20406, 38.65728], [-121.20459, 38.65729], [-121.2053, 38.65726], [-121.20538, 38.65866]]]} | Open Access 1 | 21446 | Orangevale Recreation/park Dist | 23182 | 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 | 6.364 | Orangevale Rec./park Dist | 0 | Local Recreation Area 3 | 4 | |
11140 | 11140 | 11139 | {"type": "Polygon", "coordinates": [[[-121.33145, 38.71873], [-121.33142, 38.71879], [-121.33142, 38.71883], [-121.33145, 38.71887], [-121.33142, 38.7189], [-121.3314, 38.71911], [-121.33136, 38.71934], [-121.33134, 38.71943], [-121.33129, 38.71946], [-121.33127, 38.71951], [-121.33129, 38.71958], [-121.33118, 38.71982], [-121.33113, 38.7199], [-121.3311, 38.71991], [-121.33097, 38.72016], [-121.33083, 38.72055], [-121.33067, 38.72078], [-121.33057, 38.72077], [-121.33048, 38.72082], [-121.33047, 38.72085], [-121.33047, 38.7209], [-121.33043, 38.72091], [-121.33017, 38.72138], [-121.33011, 38.72139], [-121.33005, 38.72143], [-121.33003, 38.72148], [-121.33005, 38.72154], [-121.32969, 38.72203], [-121.32962, 38.72204], [-121.32956, 38.72209], [-121.32955, 38.72216], [-121.3296, 38.72223], [-121.32938, 38.72244], [-121.32905, 38.72285], [-121.32891, 38.7229], [-121.32899, 38.72315], [-121.32859, 38.72322], [-121.3282, 38.72325], [-121.32775, 38.72325], [-121.32767, 38.72323], [-121.32765, 38.72319], [-121.32765, 38.72284], [-121.32812, 38.72284], [-121.32841, 38.72278], [-121.32864, 38.72258], [-121.32892, 38.72215], [-121.32891, 38.72212], [-121.32897, 38.72207], [-121.32899, 38.72201], [-121.32902, 38.72201], [-121.32939, 38.72153], [-121.32938, 38.7215], [-121.32945, 38.72145], [-121.32946, 38.72138], [-121.3295, 38.72137], [-121.32985, 38.72089], [-121.32984, 38.72086], [-121.32991, 38.72081], [-121.32992, 38.72074], [-121.32996, 38.72073], [-121.33032, 38.72021], [-121.33064, 38.7198], [-121.3308, 38.71951], [-121.33089, 38.7192], [-121.33091, 38.71901], [-121.33091, 38.71878], [-121.33095, 38.71869], [-121.33093, 38.71864], [-121.3309, 38.71859], [-121.33094, 38.71855], [-121.33094, 38.71809], [-121.33142, 38.71808], [-121.33142, 38.7187], [-121.33145, 38.71873]]]} | Open Access 1 | 21442 | Parkway Greens | 23460 | 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 | 8.032 | Parkway Greens | 0 | Local Park 2 | 4 | |
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-121.35463, 38.5704], [-121.35403, 38.57048], [-121.35403, 38.57049], [-121.35418, 38.57064], [-121.35335, 38.57103], [-121.35193, 38.56789], [-121.3508, 38.56544], [-121.35129, 38.5652], [-121.35141, 38.56534], [-121.35162, 38.56568], [-121.35254, 38.56755], [-121.35262, 38.56769], [-121.35291, 38.56809], [-121.35322, 38.56887], [-121.35369, 38.5699], [-121.35378, 38.57004], [-121.354, 38.57024], [-121.35417, 38.57033], [-121.3544, 38.5704], [-121.35463, 38.5704]]]} | Open Access 1 | 22213 | 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 | 10.921 | County Of Sacramento | None 239 | |||
2959 | 2959 | 2958 | {"type": "Polygon", "coordinates": [[[-121.49409, 38.57564], [-121.49312, 38.57765], [-121.48768, 38.57619], [-121.48856, 38.57417], [-121.49409, 38.57564]]]} | Open Access 1 | 20463 | Capitol Park | 16837 | 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 | 29.711 | Capitol Park | 0 | Local Park 2 | 4 | |
16641 | 16641 | 16640 | {"type": "Polygon", "coordinates": [[[-121.16941, 38.69857], [-121.16888, 38.69857], [-121.16885, 38.69983], [-121.16707, 38.69983], [-121.16698, 38.69882], [-121.16667, 38.69756], [-121.16679, 38.69664], [-121.16671, 38.69636], [-121.16673, 38.69612], [-121.16755, 38.69261], [-121.16755, 38.69204], [-121.16816, 38.692], [-121.16938, 38.69204], [-121.16946, 38.69624], [-121.16941, 38.69857]]]} | Open Access 1 | 22260 | Folsom Lake State Recreation Area | 18970 | 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 | 42.957 | Folsom Lake SRA | 1956 | Local Recreation Area 3 | 4 | |
12721 | 12721 | 12720 | {"type": "Polygon", "coordinates": [[[-121.47555, 38.71878], [-121.47552, 38.72178], [-121.46828, 38.72174], [-121.46826, 38.72114], [-121.46717, 38.72113], [-121.46676, 38.72043], [-121.4667, 38.71688], [-121.46714, 38.71688], [-121.4703, 38.71814], [-121.47269, 38.71821], [-121.47338, 38.71804], [-121.47357, 38.71801], [-121.47382, 38.71806], [-121.47385, 38.71834], [-121.47392, 38.71846], [-121.47403, 38.71853], [-121.47462, 38.71871], [-121.47493, 38.71874], [-121.47515, 38.71868], [-121.47537, 38.71871], [-121.47555, 38.71878]]]} | Open Access 1 | 29740 | Ponderosa Farm Community Park | 23885 | 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 | 77.173 | Ponderosa Farm Community Park | 0 | Local Park 2 | 4 | |
11387 | 11387 | 11386 | {"type": "Polygon", "coordinates": [[[-121.21012, 38.71593], [-121.19786, 38.71505], [-121.19788, 38.71503], [-121.19789, 38.7142], [-121.19866, 38.71422], [-121.19889, 38.71491], [-121.1989, 38.71492], [-121.19896, 38.71447], [-121.19913, 38.71429], [-121.19965, 38.7143], [-121.19966, 38.71425], [-121.20007, 38.71425], [-121.20002, 38.71325], [-121.2011, 38.71327], [-121.20106, 38.71245], [-121.20702, 38.71259], [-121.20694, 38.71083], [-121.20884, 38.71088], [-121.20918, 38.7123], [-121.20934, 38.71225], [-121.20936, 38.71266], [-121.20928, 38.71267], [-121.20937, 38.71447], [-121.21003, 38.71449], [-121.21012, 38.71593]], [[-121.20323, 38.71287], [-121.20235, 38.71284], [-121.20238, 38.71341], [-121.20326, 38.71343], [-121.20323, 38.71287]]]} | Open Access 1 | 22197 | Indian Stone Corral | 20210 | 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 | 78.87 | Indian Stone Corral | None 1002 |
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]);