units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2, LABEL_NAME = "Glenbrook Park", MNG_AGENCY = 743 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12907 | 12907 | 12906 | {"type": "Polygon", "coordinates": [[[-117.7209, 33.59291], [-117.72081, 33.59296], [-117.72074, 33.5929], [-117.72064, 33.59285], [-117.72052, 33.59284], [-117.72037, 33.59287], [-117.7202, 33.593], [-117.72011, 33.59314], [-117.72008, 33.59325], [-117.71995, 33.59322], [-117.7198, 33.59314], [-117.71971, 33.59316], [-117.71969, 33.59313], [-117.71965, 33.59309], [-117.71953, 33.59307], [-117.71952, 33.593], [-117.71928, 33.5929], [-117.71917, 33.59305], [-117.71916, 33.5931], [-117.71903, 33.59308], [-117.71904, 33.59299], [-117.7188, 33.59293], [-117.71866, 33.59304], [-117.71854, 33.59303], [-117.71848, 33.59291], [-117.71826, 33.59286], [-117.71824, 33.59287], [-117.71822, 33.5929], [-117.71809, 33.59288], [-117.71799, 33.59291], [-117.7178, 33.59288], [-117.71769, 33.59299], [-117.71761, 33.59296], [-117.71755, 33.59297], [-117.71751, 33.59291], [-117.71726, 33.59286], [-117.71721, 33.59287], [-117.7172, 33.5929], [-117.71706, 33.59286], [-117.71707, 33.59282], [-117.717, 33.59278], [-117.7167, 33.59287], [-117.71664, 33.59271], [-117.71648, 33.59248], [-117.7165, 33.59244], [-117.71655, 33.5924], [-117.71663, 33.59236], [-117.7177, 33.59242], [-117.7183, 33.59247], [-117.71835, 33.59246], [-117.71842, 33.59242], [-117.71844, 33.59234], [-117.71881, 33.59225], [-117.71884, 33.59231], [-117.71889, 33.59233], [-117.71917, 33.59241], [-117.71922, 33.59244], [-117.72019, 33.59272], [-117.72038, 33.59275], [-117.72061, 33.59274], [-117.72066, 33.5927], [-117.72067, 33.59267], [-117.72065, 33.59263], [-117.72068, 33.59263], [-117.7209, 33.59291]]]} | Open Access 1 | 30360 | Glenbrook Park | 19326 | 1004 | Aliso Viejo, City of 758 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | Orange 3 | 5.068 | Glenbrook Park | 0 | 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]);