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 = 16341
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12867 | 12867 | 12866 | {"type": "Polygon", "coordinates": [[[-117.92738, 33.88967], [-117.92683, 33.89063], [-117.9268, 33.89078], [-117.9268, 33.89083], [-117.92692, 33.89116], [-117.92694, 33.89128], [-117.92694, 33.8914], [-117.92694, 33.89153], [-117.92689, 33.89177], [-117.92688, 33.8929], [-117.9268, 33.89344], [-117.92642, 33.89211], [-117.9259, 33.89215], [-117.92583, 33.89233], [-117.92558, 33.89252], [-117.92554, 33.89382], [-117.92547, 33.89383], [-117.92548, 33.89448], [-117.92588, 33.89544], [-117.92617, 33.89571], [-117.92624, 33.89575], [-117.92629, 33.89584], [-117.92626, 33.89589], [-117.92608, 33.89602], [-117.9256, 33.89626], [-117.92524, 33.89651], [-117.92482, 33.89689], [-117.9246, 33.89687], [-117.92444, 33.89697], [-117.92431, 33.89691], [-117.92412, 33.89678], [-117.92401, 33.89662], [-117.92404, 33.89652], [-117.92401, 33.89637], [-117.9239, 33.89627], [-117.92377, 33.89618], [-117.92352, 33.89606], [-117.92318, 33.89582], [-117.92284, 33.89563], [-117.92272, 33.8956], [-117.92096, 33.89558], [-117.91994, 33.89559], [-117.91993, 33.89534], [-117.92275, 33.89432], [-117.92279, 33.89429], [-117.92282, 33.89425], [-117.9228, 33.8942], [-117.92274, 33.89416], [-117.92228, 33.89399], [-117.92209, 33.89397], [-117.92168, 33.89381], [-117.92178, 33.89266], [-117.92176, 33.8926], [-117.92172, 33.89256], [-117.92144, 33.89244], [-117.92184, 33.89187], [-117.92212, 33.89201], [-117.92275, 33.89172], [-117.9226, 33.89125], [-117.92258, 33.89109], [-117.92259, 33.89081], [-117.922, 33.89084], [-117.9218, 33.89086], [-117.92189, 33.89034], [-117.92192, 33.89024], [-117.92197, 33.89014], [-117.9221, 33.89001], [-117.92232, 33.88991], [-117.9221, 33.88951], [-117.92244, 33.88941], [-117.92227, 33.88891], [-117.92253, 33.88884], [-117.92242, 33.88814], [-117.92259, 33.88812], [-117.92256, 33.88756], [-117.92263, 33.88757], [-117.92278, 33.88765], [-117.92279, 33.88765], [-117.92283, 33.88749], [-117.92291, 33.88685], [-117.92298, 33.88687], [-117.92322, 33.88686], [-117.92433, 33.88686], [-117.92433, 33.88691], [-117.92435, 33.88692], [-117.92591, 33.8861], [-117.92602, 33.88643], [-117.92627, 33.88635], [-117.92729, 33.8893], [-117.92734, 33.88945], [-117.92738, 33.88967]]]} | Open Access 1 | 30309 | Brea Dam Park | 16341 | 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 | 105.528 | Brea Dam 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]);