units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_ID = 2046, DES_TP = 3 and MNG_AGENCY = 757
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Helix Water District · 1 ✖
DES_TP 1
- Local Recreation Area · 1 ✖
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16230 | 16230 | 16229 | {"type": "Polygon", "coordinates": [[[-116.74867, 32.97823], [-116.74862, 32.97841], [-116.74844, 32.97867], [-116.74821, 32.97891], [-116.74824, 32.97908], [-116.74828, 32.97918], [-116.74829, 32.97928], [-116.74823, 32.97933], [-116.74799, 32.97942], [-116.7478, 32.97955], [-116.74767, 32.97973], [-116.74753, 32.97986], [-116.74738, 32.97992], [-116.74721, 32.98003], [-116.7468, 32.98041], [-116.74638, 32.98091], [-116.74623, 32.98147], [-116.74615, 32.98162], [-116.74614, 32.98182], [-116.74612, 32.98197], [-116.74597, 32.98246], [-116.74599, 32.98258], [-116.74613, 32.98283], [-116.74629, 32.98324], [-116.74626, 32.98332], [-116.74595, 32.98353], [-116.74571, 32.9836], [-116.74546, 32.98361], [-116.74523, 32.98368], [-116.74512, 32.98375], [-116.74505, 32.98385], [-116.7451, 32.98396], [-116.74525, 32.98412], [-116.74571, 32.98447], [-116.74592, 32.98458], [-116.7461, 32.98463], [-116.7463, 32.98478], [-116.74627, 32.98489], [-116.74617, 32.98497], [-116.74602, 32.98498], [-116.74573, 32.98493], [-116.74547, 32.98492], [-116.74516, 32.985], [-116.74481, 32.98512], [-116.7446, 32.98531], [-116.74455, 32.98543], [-116.74455, 32.98561], [-116.74459, 32.9858], [-116.74466, 32.98592], [-116.7447, 32.98608], [-116.74465, 32.98615], [-116.74452, 32.98624], [-116.74444, 32.98633], [-116.74446, 32.98655], [-116.74449, 32.9866], [-116.74446, 32.98665], [-116.74448, 32.98675], [-116.74444, 32.98685], [-116.7443, 32.98687], [-116.74413, 32.98686], [-116.74399, 32.98682], [-116.74383, 32.98685], [-116.74372, 32.98691], [-116.74363, 32.98703], [-116.74358, 32.98713], [-116.74327, 32.98732], [-116.7431, 32.9875], [-116.74297, 32.98775], [-116.74298, 32.98807], [-116.74312, 32.98817], [-116.74326, 32.98823], [-116.7435, 32.98827], [-116.74388, 32.98823], [-116.744, 32.98824], [-116.74404, 32.98835], [-116.744, 32.98843], [-116.74375, 32.98853], [-116.74362, 32.98861], [-116.74357, 32.98877], [-116.74356, 32.98886], [-116.74346, 32.98894], [-116.74345, 32.98907], [-116.74358, 32.98918], [-116.7438, 32.98921], [-116.74413, 32.98941], [-116.74428, 32.98953], [-116.74441, 32.98968], [-116.74449, 32.98992], [-116.74454, 32.9901], [-116.74475, 32.99029], [-116.74489, 32.99045], [-116.74493, 32.99052], [-116.74491, 32.99057], [-116.74486, 32.9906], [-116.7447, 32.99056], [-116.74436, 32.99053], [-116.74404, 32.99042], [-116.7439, 32.99043], [-116.74367, 32.99054], [-116.74339, 32.99054], [-116.74318, 32.99061], [-116.74303, 32.99072], [-116.74305, 32.99082], [-116.74306, 32.99109], [-116.74288, 32.9912], [-116.74282, 32.99137], [-116.74272, 32.99149], [-116.74269, 32.99151], [-116.74243, 32.99133], [-116.74223, 32.99126], [-116.74193, 32.99125], [-116.74185, 32.9913], [-116.7418, 32.9914], [-116.7418, 32.99145], [-116.74182, 32.9916], [-116.74193, 32.99175], [-116.74195, 32.99184], [-116.74194, 32.99188], [-116.74187, 32.99191], [-116.74168, 32.9919], [-116.74126, 32.99197], [-116.7411, 32.99201], [-116.74099, 32.99209], [-116.74091, 32.99218], [-116.74083, 32.9924], [-116.74075, 32.99248], [-116.74042, 32.99256], [-116.74035, 32.9926], [-116.74014, 32.9927], [-116.74001, 32.99279], [-116.74, 32.99294], [-116.73997, 32.99305], [-116.73989, 32.99313], [-116.73985, 32.99325], [-116.73985, 32.99345], [-116.73992, 32.99367], [-116.74008, 32.99379], [-116.74029, 32.9939], [-116.74046, 32.99407], [-116.74063, 32.99416], [-116.74076, 32.99425], [-116.74077, 32.99429], [-116.74066, 32.99431], [-116.74042, 32.9943], [-116.74034, 32.99436], [-116.74015, 32.9944], [-116.74007, 32.99436], [-116.73992, 32.99435], [-116.73979, 32.9944], [-116.73972, 32.99439], [-116.73934, 32.99427], [-116.73925, 32.9941], [-116.73911, 32.99398], [-116.73882, 32.99389], [-116.7387, 32.99389], [-116.73857, 32.99394], [-116.73852, 32.99403], [-116.73848, 32.99418], [-116.73849, 32.99433], [-116.73844, 32.9944], [-116.73837, 32.99442], [-116.73831, 32.9944], [-116.73803, 32.99428], [-116.73791, 32.99424], [-116.73742, 32.99427], [-116.73711, 32.99436], [-116.73659, 32.9946], [-116.7364, 32.99478], [-116.7363, 32.99492], [-116.7363, 32.99505], [-116.73646, 32.99524], [-116.73647, 32.9953], [-116.73615, 32.99533], [-116.7356, 32.99523], [-116.73531, 32.99521], [-116.73474, 32.99515], [-116.73448, 32.99517], [-116.73429, 32.99527], [-116.734, 32.99536], [-116.73379, 32.99551], [-116.7336, 32.99573], [-116.7335, 32.99595], [-116.73349, 32.99622], [-116.73352, 32.99634], [-116.73361, 32.99644], [-116.73366, 32.99653], [-116.73363, 32.99659], [-116.73326, 32.99675], [-116.73313, 32.99685], [-116.73305, 32.997], [-116.73287, 32.99716], [-116.73271, 32.99737], [-116.73265, 32.99751], [-116.73261, 32.99774], [-116.7324, 32.99811], [-116.73234, 32.99855], [-116.73231, 32.99862], [-116.73215, 32.99876], [-116.73211, 32.99884], [-116.73209, 32.99891], [-116.73206, 32.99898], [-116.73197, 32.99907], [-116.7318, 32.99915], [-116.73168, 32.99925], [-116.73158, 32.99939], [-116.73155, 32.99957], [-116.73156, 32.99986], [-116.73149, 32.99995], [-116.7312, 33.00004], [-116.73109, 33.00013], [-116.73093, 33.00058], [-116.73079, 33.00067], [-116.73053, 33.00078], [-116.73048, 33.00087], [-116.73045, 33.00109], [-116.7304, 33.00118], [-116.73017, 33.00136], [-116.73014, 33.00146], [-116.73012, 33.00165], [-116.73014, 33.00186], [-116.73006, 33.00205], [-116.72991, 33.0023], [-116.72964, 33.00254], [-116.72948, 33.0026], [-116.72922, 33.00274], [-116.72913, 33.00282], [-116.72898, 33.0029], [-116.72884, 33.00314], [-116.72875, 33.00318], [-116.72863, 33.00318], [-116.72851, 33.00327], [-116.72835, 33.00341], [-116.72832, 33.00352], [-116.72827, 33.00356], [-116.72793, 33.0036], [-116.72782, 33.00371], [-116.72748, 33.00398], [-116.72733, 33.00434], [-116.7273, 33.00437], [-116.72723, 33.00437], [-116.72718, 33.00432], [-116.72714, 33.00426], [-116.72713, 33.00378], [-116.72721, 33.00368], [-116.72728, 33.00363], [-116.72737, 33.00359], [-116.72744, 33.00353], [-116.72768, 33.00326], [-116.72826, 33.00296], [-116.72849, 33.00275], [-116.7285, 33.00268], [-116.72868, 33.00257], [-116.72878, 33.00247], [-116.72929, 33.00167], [-116.72929, 33.00137], [-116.72933, 33.00129], [-116.72951, 33.00114], [-116.72956, 33.00102], [-116.7298, 33.00069], [-116.72984, 33.00057], [-116.72985, 33.00022], [-116.73012, 33.00004], [-116.73036, 32.9996], [-116.73039, 32.99946], [-116.73048, 32.99921], [-116.73049, 32.99908], [-116.73048, 32.99896], [-116.73045, 32.99889], [-116.73045, 32.99878], [-116.73049, 32.99871], [-116.73062, 32.9986], [-116.73076, 32.99844], [-116.73089, 32.99811], [-116.73096, 32.99781], [-116.73122, 32.99707], [-116.73123, 32.99664], [-116.73131, 32.99645], [-116.73126, 32.99626], [-116.73131, 32.99606], [-116.73143, 32.99582], [-116.73148, 32.99554], [-116.73147, 32.99544], [-116.73138, 32.99519], [-116.73139, 32.99511], [-116.73131, 32.99491], [-116.73134, 32.99484], [-116.73152, 32.99475], [-116.73186, 32.9947], [-116.73222, 32.99459], [-116.73252, 32.9944], [-116.73274, 32.99423], [-116.73303, 32.99398], [-116.73344, 32.99357], [-116.7335, 32.99332], [-116.73357, 32.99327], [-116.7338, 32.99317], [-116.7339, 32.9931], [-116.73406, 32.99281], [-116.73414, 32.99263], [-116.73419, 32.99256], [-116.73427, 32.99252], [-116.73437, 32.9925], [-116.73451, 32.99243], [-116.73466, 32.99232], [-116.73476, 32.9922], [-116.73477, 32.99193], [-116.73483, 32.99185], [-116.73517, 32.99163], [-116.73535, 32.99148], [-116.73542, 32.99138], [-116.73538, 32.9913], [-116.73524, 32.99116], [-116.73519, 32.99103], [-116.73516, 32.99086], [-116.7351, 32.99072], [-116.73499, 32.99059], [-116.73487, 32.99051], [-116.73465, 32.99039], [-116.73451, 32.99035], [-116.73429, 32.99024], [-116.73409, 32.99018], [-116.73371, 32.99028], [-116.73351, 32.99025], [-116.73332, 32.99025], [-116.7331, 32.99014], [-116.7326, 32.98995], [-116.73223, 32.98985], [-116.73213, 32.98978], [-116.73181, 32.98947], [-116.73161, 32.98932], [-116.73131, 32.98921], [-116.73118, 32.98921], [-116.73104, 32.98926], [-116.73094, 32.98935], [-116.73087, 32.98945], [-116.73069, 32.9899], [-116.73061, 32.98999], [-116.73056, 32.99], [-116.73039, 32.98997], [-116.73009, 32.98997], [-116.72997, 32.98993], [-116.72993, 32.98988], [-116.72993, 32.98981], [-116.72999, 32.98968], [-116.73039, 32.98944], [-116.73052, 32.98926], [-116.73053, 32.98916], [-116.73052, 32.98903], [-116.73054, 32.98898], [-116.73247, 32.98887], [-116.73283, 32.98903], [-116.733, 32.98904], [-116.73318, 32.989], [-116.73326, 32.989], [-116.73352, 32.98888], [-116.73383, 32.98879], [-116.73413, 32.98877], [-116.73619, 32.98873], [-116.73631, 32.98874], [-116.73645, 32.98881], [-116.73651, 32.98887], [-116.73706, 32.98898], [-116.73738, 32.98915], [-116.73747, 32.98918], [-116.73754, 32.98917], [-116.7379, 32.98902], [-116.73783, 32.98873], [-116.73786, 32.9885], [-116.73794, 32.98836], [-116.73794, 32.98828], [-116.73787, 32.9882], [-116.73785, 32.98813], [-116.73778, 32.98808], [-116.73753, 32.98802], [-116.73721, 32.98778], [-116.73718, 32.9877], [-116.73717, 32.9876], [-116.73705, 32.98753], [-116.73702, 32.98747], [-116.73702, 32.98743], [-116.73709, 32.98738], [-116.73713, 32.98733], [-116.73713, 32.98722], [-116.73718, 32.98719], [-116.73755, 32.98719], [-116.73794, 32.98714], [-116.73837, 32.98686], [-116.73846, 32.98674], [-116.73848, 32.9866], [-116.73858, 32.98652], [-116.73879, 32.98639], [-116.73914, 32.98606], [-116.73916, 32.98594], [-116.73913, 32.98582], [-116.73923, 32.98574], [-116.73936, 32.98567], [-116.7396, 32.98547], [-116.73978, 32.9852], [-116.73987, 32.98495], [-116.7399, 32.98475], [-116.73997, 32.98468], [-116.74006, 32.98465], [-116.74016, 32.98451], [-116.74015, 32.98442], [-116.74019, 32.98431], [-116.74026, 32.98425], [-116.74077, 32.98395], [-116.74101, 32.98365], [-116.74113, 32.98323], [-116.74121, 32.98316], [-116.74167, 32.98295], [-116.74185, 32.98279], [-116.74194, 32.98269], [-116.74198, 32.98261], [-116.74225, 32.98234], [-116.74232, 32.98224], [-116.74237, 32.98209], [-116.74232, 32.98193], [-116.74197, 32.98164], [-116.74174, 32.98149], [-116.74158, 32.98145], [-116.74149, 32.9813], [-116.7413, 32.9812], [-116.74112, 32.98117], [-116.74099, 32.98119], [-116.7409, 32.98118], [-116.7404, 32.98072], [-116.74008, 32.98055], [-116.74002, 32.98049], [-116.74002, 32.98042], [-116.74007, 32.98029], [-116.74018, 32.98016], [-116.74018, 32.98007], [-116.74012, 32.97994], [-116.74002, 32.97984], [-116.73988, 32.97976], [-116.73967, 32.97974], [-116.73956, 32.97777], [-116.74282, 32.97769], [-116.74287, 32.97775], [-116.74298, 32.97784], [-116.74338, 32.97802], [-116.74375, 32.97802], [-116.74386, 32.97806], [-116.74393, 32.97813], [-116.74399, 32.97814], [-116.74415, 32.97814], [-116.74429, 32.9781], [-116.74442, 32.97809], [-116.7445, 32.97814], [-116.74466, 32.97841], [-116.74469, 32.97855], [-116.74491, 32.97879], [-116.74505, 32.97885], [-116.74519, 32.97886], [-116.7456, 32.9788], [-116.74576, 32.97879], [-116.74587, 32.97885], [-116.74605, 32.97902], [-116.74616, 32.97909], [-116.74628, 32.97911], [-116.74647, 32.97911], [-116.74674, 32.97907], [-116.74708, 32.97896], [-116.7476, 32.97863], [-116.74802, 32.97847], [-116.74813, 32.97836], [-116.74835, 32.97823], [-116.74849, 32.97818], [-116.74859, 32.97819], [-116.74867, 32.97823]]]} | Open Access 1 | 45134 | Helix Water District Open Space | 31526 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2046 | Helix Water District 757 | Special District 4 | Water District 13 | San Diego 4 | 318.048 | Helix Water District OS | 0 | Local Recreation Area 3 | 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]);