units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where MNG_AGENCY = 28 and MNG_AG_TYP = 7 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 2
ACCESS_TYP 2
MNG_AG_TYP 1
- County Agency - Parks · 5 ✖
MNG_AGENCY 1
- San Mateo County Parks and Recreation Dept., County of · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181 | 181 | 180 | {"type": "Polygon", "coordinates": [[[-122.49305, 37.56961], [-122.48546, 37.57318], [-122.48238, 37.57518], [-122.48238, 37.5752], [-122.48578, 37.57789], [-122.48314, 37.5798], [-122.48265, 37.57957], [-122.48195, 37.57839], [-122.4812, 37.5785], [-122.48118, 37.57847], [-122.48102, 37.5785], [-122.481, 37.57846], [-122.48036, 37.57855], [-122.47994, 37.57956], [-122.48006, 37.57981], [-122.47919, 37.57994], [-122.4786, 37.58015], [-122.47767, 37.58015], [-122.47712, 37.58], [-122.47679, 37.58021], [-122.47668, 37.58021], [-122.47658, 37.58026], [-122.47604, 37.58089], [-122.47595, 37.58083], [-122.47647, 37.58023], [-122.47644, 37.58014], [-122.47473, 37.57919], [-122.4744, 37.57919], [-122.47403, 37.57936], [-122.47405, 37.57941], [-122.47384, 37.5795], [-122.47392, 37.57924], [-122.47382, 37.57911], [-122.47377, 37.5791], [-122.47281, 37.57956], [-122.47288, 37.57996], [-122.47348, 37.58032], [-122.47376, 37.58001], [-122.47416, 37.58031], [-122.4742, 37.58053], [-122.47443, 37.58065], [-122.47458, 37.58085], [-122.47517, 37.58105], [-122.47552, 37.58131], [-122.47551, 37.5815], [-122.47513, 37.58196], [-122.47446, 37.58158], [-122.47447, 37.58155], [-122.47273, 37.58059], [-122.47231, 37.58024], [-122.46848, 37.58207], [-122.46308, 37.5846], [-122.46295, 37.58445], [-122.46286, 37.58449], [-122.45977, 37.58449], [-122.45942, 37.56638], [-122.46834, 37.56631], [-122.46827, 37.56264], [-122.48708, 37.56253], [-122.48732, 37.5697], [-122.49305, 37.56961]], [[-122.46846, 37.57002], [-122.47795, 37.56987], [-122.47791, 37.5662], [-122.46835, 37.56631], [-122.46846, 37.57002]]]} | Open Access 1 | 499 | San Pedro Valley Park | 11490 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | https://parks.smcgov.org/san-pedro-valley-park | San Mateo 15 | 1051.78 | San Pedro Valley Park | 2000 | Local Park 2 | 4 |
14209 | 14209 | 14208 | {"type": "Polygon", "coordinates": [[[-122.49515, 37.58657], [-122.49386, 37.58803], [-122.49373, 37.58789], [-122.49356, 37.58775], [-122.49138, 37.58627], [-122.4911, 37.58614], [-122.49084, 37.58606], [-122.49175, 37.58498], [-122.49198, 37.58497], [-122.49232, 37.5852], [-122.49249, 37.58522], [-122.49283, 37.58504], [-122.49319, 37.5854], [-122.49394, 37.58538], [-122.49413, 37.58585], [-122.49424, 37.58594], [-122.4943, 37.58589], [-122.49442, 37.58597], [-122.49458, 37.58628], [-122.49515, 37.58657]]]} | Open Access 1 | 44075 | Sanchez Adobe County Park | 25006 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 15.786 | Sanchez Adobe County Park | 0 | Local Park 2 | 4 | |
4227 | 4227 | 4226 | {"type": "Polygon", "coordinates": [[[-122.40045, 37.34619], [-122.40067, 37.34684], [-122.40105, 37.3505], [-122.40014, 37.35661], [-122.39968, 37.35684], [-122.39925, 37.35665], [-122.39846, 37.35659], [-122.39805, 37.35668], [-122.39805, 37.35669], [-122.3983, 37.35727], [-122.39762, 37.35724], [-122.39754, 37.35599], [-122.39872, 37.35471], [-122.39938, 37.35358], [-122.39954, 37.35151], [-122.39785, 37.34917], [-122.39775, 37.34869], [-122.39816, 37.34885], [-122.39834, 37.34887], [-122.39847, 37.34885], [-122.39858, 37.3488], [-122.39867, 37.34873], [-122.39873, 37.34864], [-122.39876, 37.34851], [-122.39872, 37.34735], [-122.39877, 37.34718], [-122.3989, 37.34698], [-122.39893, 37.34689], [-122.39889, 37.34672], [-122.39882, 37.34654], [-122.39848, 37.34602], [-122.39837, 37.34593], [-122.39824, 37.34586], [-122.39809, 37.34583], [-122.39794, 37.34583], [-122.39832, 37.34564], [-122.40045, 37.34619]]]} | No Public Access 3 | 47809 | Tunitas Creek Beach | 31691 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 51.984 | Tunitas Creek Beach | 0 | Local Park 2 | 4 | |
9345 | 9345 | 9344 | {"type": "Polygon", "coordinates": [[[-122.29842, 37.5564], [-122.2981, 37.55659], [-122.29806, 37.55653], [-122.29799, 37.55649], [-122.29791, 37.55648], [-122.29782, 37.55651], [-122.29745, 37.55611], [-122.2975, 37.55607], [-122.29753, 37.556], [-122.29751, 37.55594], [-122.29746, 37.55589], [-122.29777, 37.55571], [-122.29842, 37.5564]]]} | Open Access 1 | 15612 | Washington Playground | 27284 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 1.049 | Washington Playground | 1962 | Local Recreation Area 3 | 4 | |
6479 | 6479 | 6478 | {"type": "Polygon", "coordinates": [[[-122.29433, 37.40059], [-122.29434, 37.40064], [-122.2943, 37.40069], [-122.29425, 37.40071], [-122.29419, 37.4007], [-122.29261, 37.39985], [-122.29249, 37.39983], [-122.29237, 37.39987], [-122.29233, 37.39991], [-122.2923, 37.39997], [-122.29231, 37.40004], [-122.29239, 37.40028], [-122.29239, 37.40034], [-122.29236, 37.40041], [-122.29226, 37.40048], [-122.29182, 37.40065], [-122.29163, 37.40066], [-122.29029, 37.40053], [-122.29015, 37.40054], [-122.28998, 37.4006], [-122.2897, 37.4008], [-122.28955, 37.40087], [-122.28878, 37.40099], [-122.28799, 37.4013], [-122.28783, 37.40133], [-122.28768, 37.40133], [-122.28618, 37.40112], [-122.28594, 37.40115], [-122.28572, 37.40125], [-122.28558, 37.40141], [-122.28552, 37.40156], [-122.28552, 37.40175], [-122.28559, 37.4019], [-122.28569, 37.402], [-122.2858, 37.40208], [-122.28594, 37.40214], [-122.28612, 37.40218], [-122.28623, 37.40223], [-122.2865, 37.40249], [-122.28686, 37.40266], [-122.28705, 37.40278], [-122.28713, 37.40285], [-122.28715, 37.40292], [-122.28711, 37.40298], [-122.28703, 37.40301], [-122.28698, 37.403], [-122.28641, 37.40276], [-122.28632, 37.4027], [-122.28617, 37.40257], [-122.28603, 37.40251], [-122.28586, 37.4025], [-122.28561, 37.40257], [-122.28542, 37.40259], [-122.28518, 37.40258], [-122.28498, 37.40252], [-122.2845, 37.40228], [-122.28362, 37.40191], [-122.28344, 37.40177], [-122.28325, 37.40152], [-122.28317, 37.40146], [-122.28305, 37.40141], [-122.28291, 37.40138], [-122.28249, 37.40136], [-122.2822, 37.40132], [-122.28105, 37.40101], [-122.28073, 37.40095], [-122.2805, 37.40094], [-122.28028, 37.40096], [-122.27908, 37.40118], [-122.27899, 37.40122], [-122.27888, 37.40132], [-122.27868, 37.40161], [-122.27859, 37.40167], [-122.2785, 37.4017], [-122.2781, 37.4017], [-122.27762, 37.40182], [-122.2773, 37.40188], [-122.27604, 37.40203], [-122.2758, 37.40212], [-122.2757, 37.4022], [-122.2756, 37.40229], [-122.27493, 37.40311], [-122.27487, 37.40324], [-122.27486, 37.40335], [-122.27496, 37.40369], [-122.27503, 37.40381], [-122.2751, 37.4039], [-122.27524, 37.40401], [-122.27536, 37.40414], [-122.27618, 37.40531], [-122.27622, 37.40544], [-122.27622, 37.40559], [-122.27617, 37.40581], [-122.27611, 37.40595], [-122.27599, 37.40605], [-122.27583, 37.4061], [-122.27529, 37.40613], [-122.27469, 37.4062], [-122.27459, 37.40618], [-122.2745, 37.40612], [-122.27439, 37.40608], [-122.27399, 37.40601], [-122.27382, 37.406], [-122.27361, 37.40605], [-122.27339, 37.40619], [-122.27325, 37.40619], [-122.27313, 37.40623], [-122.27304, 37.40633], [-122.27299, 37.40648], [-122.27289, 37.40665], [-122.27287, 37.40674], [-122.2729, 37.4069], [-122.273, 37.40706], [-122.27303, 37.40714], [-122.27301, 37.40722], [-122.27296, 37.40732], [-122.27292, 37.40745], [-122.27293, 37.40756], [-122.27298, 37.40773], [-122.27298, 37.40786], [-122.27294, 37.408], [-122.27288, 37.4081], [-122.27274, 37.40824], [-122.27254, 37.40833], [-122.27238, 37.40835], [-122.27196, 37.40836], [-122.27173, 37.40843], [-122.27101, 37.40894], [-122.27096, 37.409], [-122.27093, 37.40907], [-122.27095, 37.40918], [-122.27101, 37.40927], [-122.27111, 37.40935], [-122.27126, 37.40941], [-122.2717, 37.40947], [-122.27223, 37.40962], [-122.27281, 37.40967], [-122.273, 37.40967], [-122.27338, 37.40957], [-122.27366, 37.40944], [-122.27374, 37.40927], [-122.2738, 37.40899], [-122.27387, 37.40887], [-122.27393, 37.40874], [-122.27398, 37.40851], [-122.27404, 37.40846], [-122.27412, 37.40843], [-122.27418, 37.40868], [-122.27452, 37.40924], [-122.27436, 37.40948], [-122.27423, 37.40975], [-122.27332, 37.41057], [-122.27292, 37.41073], [-122.27242, 37.41101], [-122.2717, 37.41132], [-122.27133, 37.41205], [-122.27114, 37.41229], [-122.27064, 37.41259], [-122.27012, 37.41332], [-122.26991, 37.41349], [-122.26976, 37.41367], [-122.26907, 37.41421], [-122.26893, 37.41462], [-122.26892, 37.41489], [-122.26875, 37.41514], [-122.26825, 37.41523], [-122.26768, 37.4155], [-122.26752, 37.41525], [-122.26702, 37.41486], [-122.26687, 37.41429], [-122.26626, 37.41283], [-122.26612, 37.41186], [-122.26526, 37.41177], [-122.26238, 37.4121], [-122.26198, 37.41242], [-122.25881, 37.40921], [-122.25887, 37.40914], [-122.25898, 37.40887], [-122.25917, 37.40883], [-122.25933, 37.40875], [-122.2594, 37.40854], [-122.25967, 37.40845], [-122.25969, 37.40831], [-122.25975, 37.40819], [-122.25993, 37.40805], [-122.2594, 37.40758], [-122.25875, 37.40744], [-122.25793, 37.4083], [-122.25689, 37.40722], [-122.25682, 37.40701], [-122.2568, 37.40665], [-122.25677, 37.40653], [-122.25669, 37.40638], [-122.25655, 37.40621], [-122.25653, 37.40612], [-122.25678, 37.40586], [-122.25684, 37.40573], [-122.25683, 37.40564], [-122.25677, 37.40554], [-122.25668, 37.40546], [-122.25656, 37.40541], [-122.25649, 37.40535], [-122.25646, 37.40527], [-122.25643, 37.40505], [-122.25646, 37.40492], [-122.25661, 37.40469], [-122.25671, 37.40436], [-122.25696, 37.40404], [-122.25754, 37.40385], [-122.2577, 37.40375], [-122.25816, 37.40316], [-122.25823, 37.40311], [-122.25843, 37.40302], [-122.25852, 37.40294], [-122.25856, 37.40286], [-122.25869, 37.40247], [-122.25878, 37.40236], [-122.25894, 37.40227], [-122.25906, 37.40214], [-122.25926, 37.40201], [-122.25943, 37.40184], [-122.25954, 37.40179], [-122.25967, 37.40174], [-122.25975, 37.4017], [-122.25984, 37.4016], [-122.25992, 37.40147], [-122.26008, 37.40138], [-122.26022, 37.40128], [-122.26037, 37.40126], [-122.26044, 37.40122], [-122.2605, 37.40117], [-122.26054, 37.4011], [-122.26055, 37.40101], [-122.26061, 37.40092], [-122.26064, 37.40084], [-122.2607, 37.40079], [-122.26073, 37.40073], [-122.26074, 37.4006], [-122.26078, 37.40051], [-122.26086, 37.40036], [-122.26089, 37.40023], [-122.26106, 37.40004], [-122.26125, 37.39971], [-122.26129, 37.39962], [-122.26137, 37.39921], [-122.26136, 37.39908], [-122.26133, 37.39896], [-122.26133, 37.39886], [-122.2616, 37.39836], [-122.26162, 37.39826], [-122.26158, 37.39816], [-122.2615, 37.39808], [-122.26139, 37.39803], [-122.26129, 37.39802], [-122.26209, 37.3974], [-122.26307, 37.39714], [-122.26399, 37.39673], [-122.26543, 37.39703], [-122.26623, 37.39711], [-122.26808, 37.39759], [-122.27159, 37.39299], [-122.27888, 37.39139], [-122.2824, 37.39306], [-122.2823, 37.39315], [-122.28231, 37.39337], [-122.28226, 37.39352], [-122.28232, 37.39368], [-122.28244, 37.39374], [-122.28269, 37.39375], [-122.28303, 37.39403], [-122.28379, 37.39411], [-122.28413, 37.394], [-122.28422, 37.39392], [-122.29248, 37.39783], [-122.29236, 37.39799], [-122.29231, 37.39817], [-122.29232, 37.39835], [-122.29255, 37.39872], [-122.29266, 37.39881], [-122.29275, 37.39898], [-122.29289, 37.39915], [-122.29368, 37.39981], [-122.29398, 37.40029], [-122.29433, 37.40059]]]} | Open Access 1 | 2273 | Wunderlich Park | 11495 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | https://parks.smcgov.org/wunderlich-park | San Mateo 15 | 932.422 | Wunderlich Park | 2000 | Local Park 2 | 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]);