units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where ACCESS_TYP = 2 and MNG_AGENCY = 543
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Sacramento, County of · 3 ✖
AGNCY_TYP 1 ✖
ACCESS_TYP 1
- Restricted Access · 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11419 | 11419 | 11418 | {"type": "MultiPolygon", "coordinates": [[[[-121.17476, 38.47876], [-121.1741, 38.47839], [-121.17414, 38.47832], [-121.17425, 38.47823], [-121.1744, 38.47819], [-121.17462, 38.47819], [-121.1747, 38.47821], [-121.17479, 38.47825], [-121.17487, 38.47832], [-121.17491, 38.47838], [-121.17494, 38.47845], [-121.17494, 38.47852], [-121.17492, 38.47859], [-121.17488, 38.47866], [-121.17476, 38.47876]]], [[[-121.18136, 38.48039], [-121.17757, 38.48451], [-121.17626, 38.48377], [-121.17616, 38.48373], [-121.1764, 38.48358], [-121.17654, 38.48355], [-121.1767, 38.48368], [-121.17694, 38.48382], [-121.17721, 38.48387], [-121.17772, 38.48405], [-121.17783, 38.48404], [-121.17789, 38.4839], [-121.17787, 38.48367], [-121.17769, 38.48322], [-121.1774, 38.48282], [-121.17692, 38.48233], [-121.17676, 38.48229], [-121.17665, 38.4824], [-121.17654, 38.48285], [-121.17645, 38.48293], [-121.17635, 38.4829], [-121.17613, 38.48274], [-121.17599, 38.48253], [-121.17581, 38.48233], [-121.17552, 38.48218], [-121.17543, 38.48206], [-121.17538, 38.48181], [-121.17528, 38.48159], [-121.17534, 38.48144], [-121.17562, 38.48154], [-121.17575, 38.4815], [-121.17586, 38.4815], [-121.17602, 38.48147], [-121.17606, 38.48133], [-121.1764, 38.48101], [-121.17652, 38.48078], [-121.17658, 38.48057], [-121.17699, 38.48017], [-121.17716, 38.47992], [-121.17721, 38.47974], [-121.17708, 38.47969], [-121.17694, 38.47958], [-121.1769, 38.47949], [-121.17689, 38.47938], [-121.17685, 38.47928], [-121.17671, 38.4792], [-121.17666, 38.47914], [-121.17662, 38.47906], [-121.17661, 38.47899], [-121.17662, 38.47891], [-121.17666, 38.47882], [-121.17673, 38.47874], [-121.17688, 38.47867], [-121.17704, 38.47866], [-121.17717, 38.4787], [-121.17727, 38.47877], [-121.1774, 38.47883], [-121.17747, 38.4789], [-121.17752, 38.47901], [-121.17769, 38.47923], [-121.17773, 38.47937], [-121.17772, 38.47949], [-121.17809, 38.47959], [-121.17837, 38.47932], [-121.17837, 38.47916], [-121.17828, 38.479], [-121.17802, 38.47876], [-121.1773, 38.47844], [-121.1772, 38.47833], [-121.17719, 38.47824], [-121.17704, 38.47828], [-121.1768, 38.47827], [-121.17663, 38.47821], [-121.1765, 38.47812], [-121.17641, 38.47801], [-121.17635, 38.47791], [-121.17632, 38.47778], [-121.17632, 38.47771], [-121.17635, 38.47764], [-121.17648, 38.47752], [-121.17741, 38.47806], [-121.17733, 38.47817], [-121.1774, 38.47817], [-121.17763, 38.47827], [-121.18136, 38.48039]]]]} | Restricted Access 2 | 22235 | Silva Et Al | 25480 | 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 | 41.21 | Silva Et Al | None 1011 | |||
11421 | 11421 | 11420 | {"type": "Polygon", "coordinates": [[[-121.28865, 38.49607], [-121.27955, 38.49606], [-121.27946, 38.48155], [-121.28863, 38.48158], [-121.28865, 38.49607]]]} | Restricted Access 2 | 22240 | Vernal Pool Prairie Preserve Area | 27000 | 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 | 317.004 | Vernal Pool Prairie Preserve Area | 0 | Local Conservation Area 4 | 2 | |
15700 | 15700 | 15699 | {"type": "MultiPolygon", "coordinates": [[[[-121.39794, 38.718], [-121.39794, 38.71803], [-121.39732, 38.718], [-121.39658, 38.71802], [-121.39577, 38.71793], [-121.39554, 38.71792], [-121.39551, 38.71787], [-121.39552, 38.71785], [-121.39555, 38.71784], [-121.39583, 38.71783], [-121.39606, 38.71779], [-121.39641, 38.71779], [-121.39656, 38.7178], [-121.39671, 38.71785], [-121.39676, 38.7179], [-121.39686, 38.71795], [-121.39728, 38.71796], [-121.39737, 38.71794], [-121.39749, 38.71784], [-121.39758, 38.71779], [-121.3976, 38.71781], [-121.39758, 38.71783], [-121.39748, 38.71789], [-121.39744, 38.71795], [-121.39783, 38.71794], [-121.39783, 38.71791], [-121.39779, 38.71786], [-121.39778, 38.71783], [-121.39781, 38.71782], [-121.39785, 38.71784], [-121.39789, 38.71788], [-121.39794, 38.718]]], [[[-121.39618, 38.71991], [-121.39616, 38.72016], [-121.39605, 38.72016], [-121.39597, 38.72018], [-121.39591, 38.72022], [-121.39584, 38.72035], [-121.3958, 38.72036], [-121.39565, 38.72036], [-121.39555, 38.7204], [-121.39556, 38.72018], [-121.39566, 38.72015], [-121.39571, 38.72], [-121.39583, 38.71988], [-121.39595, 38.71984], [-121.39608, 38.71986], [-121.39618, 38.71991]]], [[[-121.39818, 38.72268], [-121.39814, 38.72274], [-121.39806, 38.72275], [-121.39799, 38.72272], [-121.39741, 38.72221], [-121.39721, 38.72206], [-121.39692, 38.72206], [-121.39681, 38.72208], [-121.39667, 38.72208], [-121.39636, 38.72209], [-121.3963, 38.72213], [-121.39624, 38.72223], [-121.39618, 38.72225], [-121.39614, 38.72225], [-121.39614, 38.72214], [-121.39627, 38.72204], [-121.39642, 38.722], [-121.39678, 38.72199], [-121.397, 38.72193], [-121.39712, 38.72193], [-121.39716, 38.7219], [-121.39732, 38.72192], [-121.39736, 38.72188], [-121.39735, 38.7218], [-121.3974, 38.7218], [-121.39766, 38.72198], [-121.39765, 38.72205], [-121.39772, 38.72225], [-121.39781, 38.72236], [-121.39793, 38.72246], [-121.39806, 38.72253], [-121.39815, 38.72262], [-121.39818, 38.72268]]], [[[-121.39707, 38.71962], [-121.39706, 38.71979], [-121.39699, 38.71992], [-121.39686, 38.72003], [-121.3967, 38.7201], [-121.39652, 38.72011], [-121.39623, 38.7201], [-121.39627, 38.71989], [-121.39643, 38.71978], [-121.39654, 38.71961], [-121.39661, 38.71955], [-121.39665, 38.71954], [-121.39669, 38.71956], [-121.3967, 38.71969], [-121.39676, 38.71971], [-121.39683, 38.71966], [-121.39686, 38.71961], [-121.3969, 38.7196], [-121.39707, 38.71962]]], [[[-121.39714, 38.72282], [-121.39707, 38.72291], [-121.39709, 38.72297], [-121.39705, 38.72298], [-121.39697, 38.72297], [-121.39696, 38.72294], [-121.39698, 38.72291], [-121.39703, 38.72287], [-121.39705, 38.7228], [-121.39711, 38.72278], [-121.39714, 38.72282]]], [[[-121.39748, 38.71779], [-121.39746, 38.71783], [-121.39735, 38.71791], [-121.39728, 38.71789], [-121.39722, 38.7178], [-121.3973, 38.71778], [-121.39748, 38.71779]]], [[[-121.39777, 38.72167], [-121.39772, 38.72182], [-121.39774, 38.72194], [-121.39773, 38.72196], [-121.39751, 38.72182], [-121.39744, 38.72169], [-121.39747, 38.72165], [-121.39749, 38.72157], [-121.39747, 38.72152], [-121.39743, 38.72147], [-121.39759, 38.72147], [-121.39758, 38.72153], [-121.39763, 38.72157], [-121.39766, 38.72157], [-121.3977, 38.7215], [-121.39772, 38.72151], [-121.39777, 38.72167]]], [[[-121.39838, 38.7181], [-121.39828, 38.71814], [-121.39808, 38.71811], [-121.39802, 38.71806], [-121.39799, 38.71795], [-121.39803, 38.71791], [-121.3982, 38.71785], [-121.39827, 38.71781], [-121.39836, 38.71786], [-121.39833, 38.71791], [-121.39838, 38.7181]], [[-121.39827, 38.71793], [-121.39823, 38.71793], [-121.3981, 38.71799], [-121.39807, 38.71801], [-121.39808, 38.71804], [-121.39814, 38.71808], [-121.39829, 38.71808], [-121.3983, 38.71806], [-121.3983, 38.71802], [-121.39827, 38.71793]]], [[[-121.39856, 38.71876], [-121.39851, 38.71878], [-121.39844, 38.71876], [-121.39837, 38.71876], [-121.39836, 38.71877], [-121.39837, 38.71878], [-121.39847, 38.71879], [-121.39849, 38.7188], [-121.39849, 38.71882], [-121.39834, 38.71882], [-121.39826, 38.71884], [-121.39821, 38.71882], [-121.39814, 38.71876], [-121.39799, 38.71874], [-121.39799, 38.71871], [-121.39807, 38.71868], [-121.39808, 38.71864], [-121.39807, 38.71857], [-121.3981, 38.71854], [-121.39828, 38.71856], [-121.39835, 38.71854], [-121.39841, 38.71868], [-121.39856, 38.71873], [-121.39856, 38.71876]]], [[[-121.39831, 38.71842], [-121.3983, 38.71845], [-121.39827, 38.71847], [-121.39812, 38.71846], [-121.39806, 38.71841], [-121.39809, 38.71835], [-121.39812, 38.71833], [-121.39817, 38.71832], [-121.39825, 38.71834], [-121.39831, 38.71842]]], [[[-121.39929, 38.71634], [-121.3993, 38.7164], [-121.39929, 38.7165], [-121.39912, 38.71679], [-121.39902, 38.7169], [-121.39895, 38.71708], [-121.39891, 38.71713], [-121.39875, 38.71725], [-121.3987, 38.7173], [-121.39851, 38.71762], [-121.3985, 38.71769], [-121.39844, 38.71774], [-121.3984, 38.7178], [-121.39832, 38.71779], [-121.39832, 38.71776], [-121.3984, 38.7176], [-121.39865, 38.71724], [-121.39869, 38.71712], [-121.39881, 38.71706], [-121.39899, 38.71683], [-121.39904, 38.7168], [-121.39918, 38.71658], [-121.39922, 38.71649], [-121.39924, 38.71633], [-121.39929, 38.71634]]], [[[-121.39855, 38.71891], [-121.39854, 38.71895], [-121.39849, 38.71897], [-121.39844, 38.71895], [-121.39837, 38.71895], [-121.39834, 38.71892], [-121.39836, 38.71889], [-121.3985, 38.71887], [-121.39852, 38.71887], [-121.39855, 38.71891]]], [[[-121.399, 38.71916], [-121.39899, 38.7193], [-121.39893, 38.71943], [-121.39888, 38.71974], [-121.39877, 38.72018], [-121.39878, 38.72047], [-121.39876, 38.72053], [-121.39867, 38.72068], [-121.39863, 38.72089], [-121.39857, 38.72103], [-121.39855, 38.72112], [-121.3985, 38.72116], [-121.39845, 38.72114], [-121.39842, 38.72111], [-121.39842, 38.72097], [-121.39847, 38.72082], [-121.3985, 38.72065], [-121.39847, 38.7206], [-121.39853, 38.72028], [-121.39864, 38.71992], [-121.39871, 38.71981], [-121.3988, 38.71951], [-121.39879, 38.71916], [-121.39885, 38.71911], [-121.39894, 38.71911], [-121.399, 38.71916]]], [[[-121.40081, 38.71464], [-121.40058, 38.71479], [-121.40051, 38.71481], [-121.40037, 38.71487], [-121.40032, 38.71491], [-121.40027, 38.71504], [-121.4002, 38.71514], [-121.39991, 38.71531], [-121.3999, 38.71535], [-121.40001, 38.71548], [-121.39996, 38.71553], [-121.39964, 38.71561], [-121.39948, 38.71568], [-121.39943, 38.71572], [-121.39939, 38.71579], [-121.39938, 38.71583], [-121.39939, 38.71588], [-121.39952, 38.71594], [-121.39954, 38.71599], [-121.39951, 38.71607], [-121.39939, 38.71624], [-121.39933, 38.71628], [-121.39928, 38.71625], [-121.39927, 38.71623], [-121.39943, 38.71603], [-121.3994, 38.71598], [-121.39927, 38.71596], [-121.39924, 38.71594], [-121.39922, 38.7159], [-121.39923, 38.7158], [-121.39939, 38.71563], [-121.3995, 38.71556], [-121.39981, 38.7155], [-121.39985, 38.71546], [-121.39972, 38.71525], [-121.39962, 38.71525], [-121.39965, 38.71522], [-121.3997, 38.71521], [-121.39969, 38.71515], [-121.39971, 38.71513], [-121.39977, 38.71509], [-121.40009, 38.71507], [-121.40012, 38.71504], [-121.40018, 38.7149], [-121.40026, 38.71479], [-121.40037, 38.71472], [-121.40055, 38.71466], [-121.40071, 38.71457], [-121.4008, 38.71462], [-121.40081, 38.71464]]], [[[-121.40096, 38.71443], [-121.4009, 38.71456], [-121.40083, 38.71459], [-121.40079, 38.71456], [-121.40079, 38.71453], [-121.40085, 38.71449], [-121.40086, 38.71443], [-121.40096, 38.71443]]]]} | Restricted Access 2 | 21434 | Antelope Greens Golf Course | 28301 | 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.742 | Antelope Greens GC | 0 | Local Recreation Area 3 | 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]);