units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 4, MNG_AG_LEV = 3, MNG_AG_TYP = 7 and SUID_NMA = 29213
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- County Agency - Parks · 1 ✖
MNG_AGENCY 1
DES_TP 1
- Local Conservation Area · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8674 | 8674 | 8673 | {"type": "Polygon", "coordinates": [[[-122.29114, 37.46925], [-122.29093, 37.46943], [-122.29082, 37.4694], [-122.29059, 37.46956], [-122.29034, 37.46969], [-122.29, 37.46982], [-122.28961, 37.46991], [-122.28961, 37.46996], [-122.28843, 37.4702], [-122.28839, 37.47015], [-122.28761, 37.47031], [-122.28736, 37.4704], [-122.28718, 37.4705], [-122.287, 37.47063], [-122.28684, 37.4708], [-122.28675, 37.47094], [-122.28651, 37.47139], [-122.2864, 37.47155], [-122.28621, 37.47174], [-122.28522, 37.47255], [-122.28502, 37.47263], [-122.2849, 37.47284], [-122.28373, 37.47382], [-122.28342, 37.47404], [-122.28314, 37.4742], [-122.28283, 37.47433], [-122.28256, 37.47443], [-122.282, 37.47456], [-122.28165, 37.47459], [-122.2813, 37.4746], [-122.28101, 37.47459], [-122.28067, 37.47455], [-122.27903, 37.47418], [-122.2785, 37.47407], [-122.27825, 37.47405], [-122.27824, 37.47375], [-122.27823, 37.47374], [-122.27815, 37.4738], [-122.27819, 37.47358], [-122.27792, 37.47318], [-122.27796, 37.47309], [-122.2779, 37.47291], [-122.27776, 37.47276], [-122.27781, 37.4727], [-122.27728, 37.47212], [-122.27698, 37.47172], [-122.27677, 37.47183], [-122.27673, 37.4716], [-122.27629, 37.47062], [-122.27588, 37.47004], [-122.2759, 37.47002], [-122.27583, 37.46984], [-122.27566, 37.46966], [-122.27568, 37.4696], [-122.27546, 37.4696], [-122.27537, 37.46949], [-122.27532, 37.46935], [-122.27537, 37.46922], [-122.27525, 37.46917], [-122.27527, 37.469], [-122.27516, 37.46888], [-122.27531, 37.46879], [-122.27523, 37.46853], [-122.27511, 37.46841], [-122.27504, 37.46805], [-122.27514, 37.4677], [-122.27484, 37.46735], [-122.27469, 37.46711], [-122.2744, 37.46702], [-122.2739, 37.46676], [-122.27328, 37.4666], [-122.27289, 37.46636], [-122.27267, 37.46628], [-122.27233, 37.46623], [-122.27205, 37.46615], [-122.27402, 37.46458], [-122.2741, 37.46454], [-122.2742, 37.46444], [-122.27494, 37.46384], [-122.27494, 37.46382], [-122.27506, 37.46371], [-122.27525, 37.46338], [-122.27533, 37.46313], [-122.27537, 37.46308], [-122.27547, 37.46301], [-122.27554, 37.4629], [-122.27562, 37.46243], [-122.27568, 37.46224], [-122.27568, 37.46197], [-122.27571, 37.46192], [-122.27578, 37.4619], [-122.27616, 37.46193], [-122.27651, 37.46191], [-122.27715, 37.46212], [-122.27951, 37.4603], [-122.2848, 37.45612], [-122.28585, 37.45684], [-122.28481, 37.45767], [-122.28481, 37.45768], [-122.28722, 37.45927], [-122.28821, 37.45848], [-122.28862, 37.45963], [-122.28844, 37.46114], [-122.28936, 37.46292], [-122.29013, 37.46541], [-122.29022, 37.46755], [-122.29114, 37.46925]]]} | Open Access 1 | 13977 | Edgewood Park and Natural Preserve | 29213 | 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 | http://parks.smcgov.org/edgewood-park-natural-preserve | San Mateo 15 | 475.613 | Edgewood Park and Natural Preserve | 2000 | Local Conservation Area 4 | 2 |
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]);