units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACRES = "2.944"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13718 | 13718 | 13717 | {"type": "MultiPolygon", "coordinates": [[[[-117.79757, 33.68517], [-117.79737, 33.68538], [-117.7968, 33.68499], [-117.797, 33.68478], [-117.79757, 33.68517]]], [[[-117.79923, 33.69094], [-117.79815, 33.69104], [-117.79804, 33.69013], [-117.79871, 33.69009], [-117.79915, 33.69018], [-117.79923, 33.69094]]]]} | Restricted Access 2 | 36125 | HOA Community Park | 31874 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 2.944 | HOA Community Park | 0 | Private Recreation or Education 65 | 4 | |
13923 | 13923 | 13922 | {"type": "MultiPolygon", "coordinates": [[[[-116.93123, 33.79803], [-116.93092, 33.79811], [-116.93094, 33.79821], [-116.931, 33.79833], [-116.93119, 33.79858], [-116.93115, 33.79861], [-116.93049, 33.79779], [-116.9302, 33.79793], [-116.93018, 33.79789], [-116.93046, 33.79774], [-116.93028, 33.79746], [-116.93018, 33.79727], [-116.93001, 33.79686], [-116.92972, 33.79579], [-116.92996, 33.7958], [-116.93001, 33.79586], [-116.93, 33.79598], [-116.92994, 33.79617], [-116.92998, 33.79626], [-116.93007, 33.79632], [-116.93005, 33.79662], [-116.93029, 33.79664], [-116.93039, 33.79668], [-116.93048, 33.79673], [-116.93053, 33.79681], [-116.93066, 33.79711], [-116.93074, 33.79732], [-116.93081, 33.79763], [-116.93086, 33.79795], [-116.93121, 33.79793], [-116.93123, 33.79803]]], [[[-116.93157, 33.79599], [-116.93105, 33.7962], [-116.93088, 33.79609], [-116.93074, 33.79602], [-116.93059, 33.79597], [-116.93031, 33.79591], [-116.93023, 33.79618], [-116.9302, 33.79618], [-116.93014, 33.79611], [-116.93017, 33.79587], [-116.93025, 33.79582], [-116.93148, 33.79593], [-116.93155, 33.79597], [-116.93157, 33.79599]]]]} | Open Access 1 | 48838 | Soboba Springs Park | 33558 | 1416 | San Jacinto, City of 222 | City 2 | City Agency 2 | http://www.ci.san-jacinto.ca.us/residents/parks.html | City 2 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/community/parks_facilities/parks/soboba_springs_park | Riverside 10 | 2.944 | Soboba Springs 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]);