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, MNG_AGENCY = 125 and UNIT_NAME = "Ganesha Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10819 | 10819 | 10818 | {"type": "MultiPolygon", "coordinates": [[[[-117.76386, 34.07472], [-117.76357, 34.07497], [-117.76349, 34.0748], [-117.76309, 34.07504], [-117.76286, 34.07513], [-117.76221, 34.07512], [-117.76128, 34.07537], [-117.7607, 34.07539], [-117.76013, 34.07511], [-117.76003, 34.075], [-117.76005, 34.07497], [-117.75955, 34.07441], [-117.75953, 34.07405], [-117.75944, 34.07375], [-117.75933, 34.07354], [-117.75923, 34.07339], [-117.75889, 34.07303], [-117.75882, 34.07293], [-117.75877, 34.07277], [-117.75877, 34.07268], [-117.7588, 34.07257], [-117.7589, 34.07242], [-117.75933, 34.07201], [-117.75947, 34.07179], [-117.75954, 34.0716], [-117.75962, 34.07156], [-117.76058, 34.07146], [-117.76085, 34.07136], [-117.76115, 34.07128], [-117.76152, 34.07122], [-117.76178, 34.0712], [-117.76238, 34.07119], [-117.76239, 34.07133], [-117.76341, 34.07135], [-117.76336, 34.07216], [-117.76284, 34.07249], [-117.76247, 34.07247], [-117.76218, 34.07233], [-117.76216, 34.07234], [-117.76234, 34.0728], [-117.76264, 34.07401], [-117.76255, 34.07419], [-117.76313, 34.07436], [-117.76363, 34.07457], [-117.76386, 34.07472]]], [[[-117.76676, 34.08086], [-117.76673, 34.08091], [-117.76667, 34.08092], [-117.76648, 34.08083], [-117.76636, 34.08075], [-117.76578, 34.07998], [-117.7656, 34.07983], [-117.76543, 34.07971], [-117.76521, 34.0796], [-117.76449, 34.07933], [-117.76417, 34.07919], [-117.76182, 34.07796], [-117.76159, 34.07786], [-117.76122, 34.07766], [-117.76092, 34.0777], [-117.76022, 34.07773], [-117.7599, 34.07783], [-117.75978, 34.07724], [-117.75968, 34.0765], [-117.75961, 34.07572], [-117.75957, 34.07472], [-117.75989, 34.07507], [-117.75992, 34.07506], [-117.76005, 34.0752], [-117.76066, 34.0755], [-117.76129, 34.07548], [-117.7622, 34.07523], [-117.76289, 34.07524], [-117.76316, 34.07514], [-117.76343, 34.07497], [-117.76351, 34.07516], [-117.76401, 34.07476], [-117.76414, 34.07484], [-117.764, 34.07514], [-117.76323, 34.07571], [-117.76274, 34.07597], [-117.76221, 34.07692], [-117.76246, 34.07725], [-117.76304, 34.07841], [-117.76315, 34.07852], [-117.76325, 34.07856], [-117.76335, 34.07857], [-117.76343, 34.07856], [-117.76368, 34.07848], [-117.76377, 34.07848], [-117.76384, 34.07851], [-117.76391, 34.07858], [-117.76394, 34.0787], [-117.76398, 34.07877], [-117.76405, 34.07883], [-117.76414, 34.07888], [-117.7642, 34.07895], [-117.76424, 34.07902], [-117.76424, 34.07911], [-117.76436, 34.07911], [-117.76436, 34.07898], [-117.76452, 34.07893], [-117.76468, 34.07908], [-117.76519, 34.07903], [-117.7653, 34.07915], [-117.76567, 34.07919], [-117.76576, 34.07908], [-117.76588, 34.07915], [-117.76617, 34.07924], [-117.76635, 34.07984], [-117.76675, 34.08009], [-117.76676, 34.08086]]]]} | Open Access 1 | 20551 | Ganesha Park | 19185 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 60.795 | Ganesha 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]);