units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where DES_TP = 2, MNG_AGENCY = 398 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency · 12 ✖
MNG_AGENCY 1
- Millbrae, City of · 12 ✖
DES_TP 1
- Local Park · 12 ✖
ACCESS_TYP 1
- Open Access 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1659 | 1659 | 1658 | {"type": "Polygon", "coordinates": [[[-122.39721, 37.59372], [-122.39652, 37.59394], [-122.39638, 37.594], [-122.39628, 37.59398], [-122.39625, 37.59395], [-122.39607, 37.59348], [-122.39603, 37.59323], [-122.39648, 37.59325], [-122.39668, 37.59314], [-122.39721, 37.59372]]]} | Open Access 1 | 14302 | Rotary Park | 24691 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 1.461 | Rotary Park | 1961 | Local Park 2 | 4 | |
8776 | 8776 | 8775 | {"type": "Polygon", "coordinates": [[[-122.40194, 37.59953], [-122.4014, 37.59984], [-122.40143, 37.5999], [-122.40009, 37.60067], [-122.40003, 37.60074], [-122.40003, 37.60079], [-122.40005, 37.60083], [-122.4001, 37.6009], [-122.39917, 37.60143], [-122.39834, 37.60052], [-122.40124, 37.59884], [-122.40194, 37.59953]]]} | Open Access 1 | 14300 | Central Park | 17054 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 8.686 | Central Park | 1969 | Local Park 2 | 4 | |
8787 | 8787 | 8786 | {"type": "Polygon", "coordinates": [[[-122.40918, 37.59933], [-122.40913, 37.5994], [-122.4085, 37.59926], [-122.40864, 37.59886], [-122.40894, 37.59893], [-122.40893, 37.59904], [-122.40903, 37.59922], [-122.40907, 37.59925], [-122.40917, 37.59926], [-122.40918, 37.59933]]]} | Open Access 1 | 14293 | Bill Mitchell Lions Park | 16107 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/lion-bill-mitchell-park | San Mateo 15 | 0.477 | Bill Mitchell Lions Park | 1977 | Local Park 2 | 4 |
8789 | 8789 | 8788 | {"type": "Polygon", "coordinates": [[[-122.39939, 37.59473], [-122.39896, 37.59497], [-122.39849, 37.59447], [-122.3984, 37.59452], [-122.39831, 37.59442], [-122.39818, 37.59449], [-122.39802, 37.59432], [-122.39813, 37.59425], [-122.39814, 37.59423], [-122.398, 37.59416], [-122.39788, 37.59423], [-122.39757, 37.594], [-122.39778, 37.59388], [-122.39767, 37.59375], [-122.39738, 37.59391], [-122.3973, 37.59382], [-122.39765, 37.59372], [-122.39801, 37.59326], [-122.39939, 37.59473]]]} | Open Access 1 | 14298 | Josephine Waugh/Soroptimist Park | 20502 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 2.83 | Josephine Waugh/Soroptimist Park | 1961 | Local Park 2 | 4 | |
8790 | 8790 | 8789 | {"type": "Polygon", "coordinates": [[[-122.4033, 37.59547], [-122.4029, 37.59587], [-122.40284, 37.59606], [-122.40316, 37.59665], [-122.40287, 37.59671], [-122.40226, 37.59656], [-122.4017, 37.59595], [-122.40259, 37.59545], [-122.40301, 37.59571], [-122.40327, 37.59545], [-122.4033, 37.59547]]]} | Open Access 1 | 14299 | Schultz Park | 25196 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 2.55 | Schultz Park | 1961 | Local Park 2 | 4 | |
8791 | 8791 | 8790 | {"type": "MultiPolygon", "coordinates": [[[[-122.39528, 37.59394], [-122.38939, 37.59734], [-122.38915, 37.59707], [-122.39089, 37.59607], [-122.3911, 37.59626], [-122.39165, 37.59597], [-122.39165, 37.59595], [-122.39145, 37.59575], [-122.39305, 37.59482], [-122.39471, 37.59366], [-122.39481, 37.59358], [-122.39484, 37.59357], [-122.39494, 37.59351], [-122.39528, 37.59394]]], [[[-122.40184, 37.59691], [-122.40145, 37.59714], [-122.40141, 37.59713], [-122.40108, 37.59693], [-122.40089, 37.59671], [-122.40093, 37.59665], [-122.40068, 37.59652], [-122.40053, 37.59642], [-122.4005, 37.59644], [-122.40022, 37.5962], [-122.39966, 37.59584], [-122.39922, 37.59541], [-122.39908, 37.59509], [-122.39951, 37.59487], [-122.40018, 37.59558], [-122.4007, 37.59603], [-122.40076, 37.59601], [-122.40079, 37.59603], [-122.40093, 37.59596], [-122.40184, 37.59691]]], [[[-122.40762, 37.59812], [-122.40671, 37.59864], [-122.40508, 37.59828], [-122.40481, 37.59844], [-122.40388, 37.59818], [-122.4032, 37.59794], [-122.4025, 37.59763], [-122.40167, 37.59719], [-122.40196, 37.59703], [-122.40249, 37.59715], [-122.40297, 37.59737], [-122.40346, 37.59757], [-122.40377, 37.59739], [-122.4038, 37.59741], [-122.40346, 37.5976], [-122.40346, 37.59762], [-122.40434, 37.59789], [-122.40487, 37.59743], [-122.40752, 37.598], [-122.40762, 37.59812]]]]} | Open Access 1 | 14301 | Spur Trail Park | 25755 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 18.129 | Spur Trail Park | 1975 | Local Park 2 | 4 | |
8792 | 8792 | 8791 | {"type": "Polygon", "coordinates": [[[-122.3999, 37.58571], [-122.39987, 37.58599], [-122.3996, 37.58686], [-122.39943, 37.58705], [-122.39939, 37.58702], [-122.39902, 37.58728], [-122.39888, 37.58699], [-122.39867, 37.58671], [-122.39849, 37.58655], [-122.39799, 37.58618], [-122.39778, 37.58598], [-122.39862, 37.58586], [-122.39976, 37.58546], [-122.3999, 37.58571]]]} | Open Access 1 | 14303 | Mills Estates Park | 32592 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/mills-estates-park | San Mateo 15 | 4.612 | Mills Estates Park | 1968 | Local Park 2 | 4 |
8793 | 8793 | 8792 | {"type": "Polygon", "coordinates": [[[-122.41738, 37.60205], [-122.41705, 37.60239], [-122.4167, 37.60265], [-122.41569, 37.6017], [-122.41576, 37.60149], [-122.41603, 37.60143], [-122.41604, 37.60136], [-122.41629, 37.60156], [-122.41655, 37.60165], [-122.41692, 37.60183], [-122.41692, 37.60186], [-122.41706, 37.60191], [-122.41709, 37.60189], [-122.41738, 37.60205]]]} | Open Access 1 | 14304 | Meadows Park | 22097 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 2.345 | Meadows Park | 1973 | Local Park 2 | 4 | |
8794 | 8794 | 8793 | {"type": "Polygon", "coordinates": [[[-122.40243, 37.60703], [-122.40183, 37.60732], [-122.40179, 37.60732], [-122.40159, 37.60726], [-122.40126, 37.60708], [-122.40111, 37.60697], [-122.4009, 37.60677], [-122.4018, 37.60631], [-122.40243, 37.60703]]]} | Open Access 1 | 14305 | Green Hills Park | 19463 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 2.016 | Green Hills Park | 1988 | Local Park 2 | 4 | |
8795 | 8795 | 8794 | {"type": "Polygon", "coordinates": [[[-122.38728, 37.60488], [-122.3869, 37.60509], [-122.38641, 37.60455], [-122.38679, 37.60433], [-122.38728, 37.60488]]]} | Open Access 1 | 14307 | Bayside Manor Park | 15895 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 0.76 | Bayside Manor Park | 2002 | Local Park 2 | 4 | |
8796 | 8796 | 8795 | {"type": "Polygon", "coordinates": [[[-122.3781, 37.60526], [-122.37758, 37.60546], [-122.37701, 37.60546], [-122.37638, 37.60529], [-122.3761, 37.60514], [-122.37588, 37.60499], [-122.37578, 37.60487], [-122.37554, 37.60465], [-122.37534, 37.60452], [-122.37481, 37.60411], [-122.37457, 37.60399], [-122.37435, 37.60378], [-122.37438, 37.6037], [-122.37667, 37.60469], [-122.37747, 37.60502], [-122.37771, 37.60507], [-122.3781, 37.60526]]]} | Open Access 1 | 14308 | Bay Front Park | 15872 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 4.105 | Bay Front Park | 1962 | Local Park 2 | 4 | |
8799 | 8799 | 8798 | {"type": "Polygon", "coordinates": [[[-122.39528, 37.61104], [-122.39513, 37.61115], [-122.39392, 37.61039], [-122.39406, 37.61024], [-122.39528, 37.61104]]]} | Open Access 1 | 14319 | Marina Vista Park | 32591 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/marina-vista-park | San Mateo 15 | 0.653 | Marina Vista Park | 1961 | 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]);