units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 101 and UNIT_NAME = "Otay Valley Regional Park"
This data as json, copyable, CSV (advanced)
These facets timed out: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16302 | 16302 | 16301 | {"type": "MultiPolygon", "coordinates": [[[[-116.91232, 32.61566], [-116.91095, 32.61568], [-116.91078, 32.61199], [-116.91216, 32.61202], [-116.91232, 32.61566]]], [[[-116.92778, 32.59728], [-116.92778, 32.60065], [-116.92354, 32.60066], [-116.92353, 32.60446], [-116.91928, 32.60446], [-116.91927, 32.59916], [-116.91929, 32.59695], [-116.92727, 32.59688], [-116.92727, 32.59728], [-116.92778, 32.59728]]], [[[-117.01006, 32.5909], [-117.01004, 32.591], [-117.01004, 32.59112], [-117.00954, 32.59112], [-117.00907, 32.59125], [-117.00888, 32.59122], [-117.00852, 32.59242], [-117.0079, 32.59229], [-117.00821, 32.59118], [-117.00749, 32.59106], [-117.00674, 32.59097], [-117.00673, 32.5933], [-117.00575, 32.59319], [-117.00519, 32.59186], [-117.00499, 32.5913], [-117.00654, 32.59136], [-117.00653, 32.59076], [-117.01006, 32.5909]]], [[[-117.00998, 32.57781], [-117.00992, 32.57971], [-117.00881, 32.57966], [-117.0088, 32.57777], [-117.00998, 32.57781]]], [[[-117.04076, 32.58623], [-117.04076, 32.58745], [-117.03739, 32.58748], [-117.03758, 32.58632], [-117.03796, 32.58675], [-117.04076, 32.58623]]], [[[-117.04924, 32.58651], [-117.04737, 32.58651], [-117.04737, 32.58542], [-117.0474, 32.58535], [-117.04789, 32.58533], [-117.04863, 32.58602], [-117.04894, 32.58578], [-117.04924, 32.58577], [-117.04924, 32.58651]]], [[[-117.05639, 32.58743], [-117.05004, 32.58738], [-117.05005, 32.58643], [-117.05174, 32.5869], [-117.05397, 32.58692], [-117.05549, 32.58712], [-117.05639, 32.58743]]], [[[-117.0608, 32.58744], [-117.06077, 32.5878], [-117.06076, 32.58781], [-117.06057, 32.58744], [-117.0608, 32.58744]]], [[[-117.06677, 32.58746], [-117.06677, 32.58881], [-117.06244, 32.5888], [-117.06243, 32.58871], [-117.06125, 32.58863], [-117.06121, 32.58857], [-117.06114, 32.58842], [-117.0611, 32.58825], [-117.06109, 32.58778], [-117.06112, 32.58761], [-117.06118, 32.58744], [-117.06677, 32.58746]]], [[[-117.07163, 32.58838], [-117.07163, 32.5884], [-117.07115, 32.5884], [-117.07115, 32.58747], [-117.07134, 32.58747], [-117.07135, 32.58748], [-117.07146, 32.58789], [-117.07163, 32.58838]]], [[[-117.08349, 32.58715], [-117.08349, 32.58795], [-117.08132, 32.58885], [-117.07725, 32.58886], [-117.07724, 32.5875], [-117.07475, 32.5875], [-117.07475, 32.58693], [-117.07542, 32.5865], [-117.07542, 32.5863], [-117.07608, 32.58629], [-117.07607, 32.5852], [-117.07476, 32.5852], [-117.07476, 32.58448], [-117.07508, 32.58448], [-117.07508, 32.58432], [-117.07576, 32.5843], [-117.07577, 32.58432], [-117.07626, 32.58432], [-117.07627, 32.58423], [-117.07709, 32.58411], [-117.07748, 32.58407], [-117.07749, 32.58404], [-117.07804, 32.58404], [-117.07806, 32.58472], [-117.07866, 32.58472], [-117.07868, 32.58632], [-117.07973, 32.58632], [-117.07973, 32.58659], [-117.07981, 32.5866], [-117.07981, 32.58717], [-117.08035, 32.58717], [-117.08073, 32.58726], [-117.08126, 32.58729], [-117.08165, 32.58722], [-117.08268, 32.58714], [-117.08349, 32.58715]]]]} | Open Access 1 | 485 | Otay Valley Regional Park | 10739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 246.744 | Otay Valley RP | 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]);