units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 113 and SUID_NMA = 20000
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6318 | 6318 | 6317 | {"type": "MultiPolygon", "coordinates": [[[[-117.93357, 33.88633], [-117.933, 33.88668], [-117.93288, 33.88682], [-117.93263, 33.88739], [-117.93256, 33.88797], [-117.93253, 33.88836], [-117.93208, 33.88914], [-117.93207, 33.88926], [-117.93201, 33.88928], [-117.93188, 33.88889], [-117.93216, 33.88861], [-117.93231, 33.88829], [-117.9323, 33.88737], [-117.93246, 33.88709], [-117.93252, 33.88692], [-117.93257, 33.88672], [-117.93266, 33.88657], [-117.93324, 33.88623], [-117.93326, 33.88615], [-117.93357, 33.88633]]], [[[-117.94181, 33.88152], [-117.94161, 33.88282], [-117.94161, 33.88254], [-117.94157, 33.88235], [-117.94147, 33.88222], [-117.94133, 33.8822], [-117.94118, 33.88226], [-117.94091, 33.88248], [-117.94065, 33.88265], [-117.94039, 33.88276], [-117.94007, 33.88284], [-117.93997, 33.88292], [-117.93994, 33.88307], [-117.93983, 33.88311], [-117.93968, 33.88278], [-117.93914, 33.88273], [-117.93859, 33.88276], [-117.93839, 33.88284], [-117.93792, 33.88322], [-117.93777, 33.88347], [-117.93734, 33.88359], [-117.93704, 33.88372], [-117.93672, 33.88445], [-117.93656, 33.88441], [-117.93666, 33.88388], [-117.93654, 33.88381], [-117.93637, 33.8838], [-117.93618, 33.88387], [-117.936, 33.88402], [-117.93568, 33.88435], [-117.93526, 33.88471], [-117.93464, 33.88541], [-117.93404, 33.886], [-117.93402, 33.88612], [-117.93409, 33.88648], [-117.93342, 33.88608], [-117.93418, 33.88542], [-117.93422, 33.88514], [-117.9346, 33.88495], [-117.93478, 33.88471], [-117.93489, 33.88448], [-117.93504, 33.88431], [-117.93547, 33.88411], [-117.93563, 33.88398], [-117.93619, 33.88345], [-117.93624, 33.88337], [-117.93615, 33.88324], [-117.9362, 33.88317], [-117.9364, 33.88319], [-117.93665, 33.88329], [-117.93698, 33.88336], [-117.93722, 33.88332], [-117.9375, 33.8832], [-117.93761, 33.88304], [-117.93768, 33.88286], [-117.93758, 33.88273], [-117.93701, 33.88248], [-117.93706, 33.8824], [-117.93803, 33.88257], [-117.9383, 33.88238], [-117.93858, 33.88251], [-117.93931, 33.88238], [-117.93972, 33.88222], [-117.9399, 33.8824], [-117.94011, 33.88247], [-117.94038, 33.88243], [-117.94058, 33.88236], [-117.94076, 33.88224], [-117.94108, 33.88186], [-117.9414, 33.88159], [-117.94181, 33.88152]]]]} | Open Access 1 | 1849 | Hiltscher Park | 20000 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 13.257 | Hiltscher 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]);