units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LABEL_NAME = "Otay Valley RP" and MNG_AGENCY = 101
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 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.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 0 | Local Park 2 | 4 |
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]);