superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACRES = "0.707"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
376 | 376 | 375 | {"type": "MultiPolygon", "coordinates": [[[[-117.77787, 33.66018], [-117.77767, 33.66024], [-117.77753, 33.66007], [-117.77771, 33.66001], [-117.77781, 33.66014], [-117.77787, 33.66018]]], [[[-117.77865, 33.66076], [-117.77852, 33.66089], [-117.77851, 33.6608], [-117.77834, 33.66068], [-117.77808, 33.66045], [-117.77791, 33.66033], [-117.77806, 33.66028], [-117.77813, 33.66029], [-117.77831, 33.66048], [-117.77864, 33.66072], [-117.77865, 33.66076]]], [[[-117.77919, 33.66114], [-117.77911, 33.66122], [-117.77891, 33.66107], [-117.7789, 33.66103], [-117.77875, 33.66092], [-117.7788, 33.66087], [-117.77886, 33.66087], [-117.77918, 33.66109], [-117.77919, 33.66114]]], [[[-117.77973, 33.66152], [-117.77964, 33.66161], [-117.77944, 33.66145], [-117.77944, 33.6614], [-117.77928, 33.66129], [-117.77933, 33.66125], [-117.7794, 33.66124], [-117.77972, 33.66147], [-117.77973, 33.66152]]]]} | Restricted Access 2 | HOA Community Park | 31987 | 6010 | Kelsey Lane Maintenance Association 1007 | Private 7 | Home Owners Association 15 | Private 14 | 0.707 | HOA Community Park | |||
5037 | 5037 | 5036 | {"type": "Polygon", "coordinates": [[[-121.75445, 36.22079], [-121.75378, 36.22097], [-121.75356, 36.22094], [-121.7535, 36.2208], [-121.75377, 36.22063], [-121.75412, 36.22022], [-121.7541, 36.22039], [-121.75416, 36.22056], [-121.75428, 36.2207], [-121.75445, 36.22079]]]} | Restricted Access 2 | Henry Miller Library | 19825 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.707 | Henry Miller Library | ||
6957 | 6957 | 6956 | {"type": "Polygon", "coordinates": [[[-117.87971, 33.65598], [-117.87969, 33.65616], [-117.87963, 33.6562], [-117.87928, 33.65615], [-117.87891, 33.65616], [-117.8791, 33.65598], [-117.87918, 33.65596], [-117.87922, 33.65593], [-117.87928, 33.6558], [-117.87952, 33.65556], [-117.87959, 33.65556], [-117.87966, 33.65568], [-117.87971, 33.6558], [-117.87971, 33.65598]]]} | Open Access 1 | Mesa Birch Park | 22172 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.707 | Mesa Birch Park | ||
8080 | 8080 | 8079 | {"type": "Polygon", "coordinates": [[[-118.32957, 33.33984], [-118.32948, 33.34015], [-118.32943, 33.3402], [-118.32883, 33.34047], [-118.32889, 33.3403], [-118.32897, 33.34012], [-118.32909, 33.33992], [-118.32925, 33.33971], [-118.32946, 33.33974], [-118.32957, 33.33984]]]} | Open Access 1 | People's Park | 23590 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | http://www.cityofavalon.com/ | City 2 | 0.707 | People's Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);