units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 608, DES_TP = 3 and MNG_AG_TYP = 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15647 | 15647 | 15646 | {"type": "Polygon", "coordinates": [[[-121.25003, 38.86325], [-121.24952, 38.86348], [-121.2489, 38.8636], [-121.2486, 38.86359], [-121.24843, 38.8637], [-121.24792, 38.8637], [-121.24769, 38.86374], [-121.24756, 38.86381], [-121.24745, 38.8639], [-121.24741, 38.86399], [-121.24745, 38.86413], [-121.24723, 38.86432], [-121.24699, 38.8643], [-121.24659, 38.86433], [-121.24615, 38.86412], [-121.24581, 38.86385], [-121.24532, 38.86369], [-121.24459, 38.86367], [-121.24442, 38.86363], [-121.24426, 38.86357], [-121.24413, 38.86349], [-121.24381, 38.86325], [-121.24359, 38.86296], [-121.24306, 38.86262], [-121.24157, 38.8622], [-121.24044, 38.86198], [-121.23971, 38.8619], [-121.23925, 38.86189], [-121.23858, 38.8618], [-121.23829, 38.86195], [-121.2381, 38.86196], [-121.23813, 38.86174], [-121.23867, 38.86148], [-121.2386, 38.86118], [-121.2381, 38.86084], [-121.23844, 38.86048], [-121.23862, 38.86035], [-121.23885, 38.86058], [-121.239, 38.8607], [-121.23927, 38.86084], [-121.23947, 38.8609], [-121.2398, 38.86096], [-121.24118, 38.86096], [-121.24165, 38.86093], [-121.24197, 38.86089], [-121.24232, 38.86081], [-121.24274, 38.86069], [-121.24284, 38.86063], [-121.24296, 38.8605], [-121.24301, 38.86035], [-121.24298, 38.8602], [-121.24251, 38.85942], [-121.24241, 38.85929], [-121.2423, 38.85919], [-121.24216, 38.8591], [-121.24191, 38.859], [-121.24163, 38.85895], [-121.24135, 38.85896], [-121.24117, 38.85901], [-121.24066, 38.85918], [-121.23929, 38.85944], [-121.23904, 38.85953], [-121.23883, 38.85967], [-121.23867, 38.85985], [-121.23857, 38.86006], [-121.23855, 38.86028], [-121.23835, 38.86042], [-121.23796, 38.86082], [-121.2378, 38.86092], [-121.23752, 38.86103], [-121.23728, 38.86105], [-121.23705, 38.86102], [-121.23684, 38.86092], [-121.23668, 38.86078], [-121.23658, 38.8606], [-121.23656, 38.86036], [-121.23683, 38.86035], [-121.23733, 38.86012], [-121.23788, 38.85934], [-121.23763, 38.85908], [-121.23607, 38.85939], [-121.23599, 38.85962], [-121.23576, 38.85962], [-121.23553, 38.85967], [-121.23537, 38.85943], [-121.23472, 38.85939], [-121.23311, 38.85904], [-121.23228, 38.85939], [-121.23208, 38.85925], [-121.23183, 38.85901], [-121.2328, 38.85856], [-121.23267, 38.85764], [-121.23174, 38.85761], [-121.23112, 38.85775], [-121.23107, 38.85758], [-121.23104, 38.85741], [-121.23191, 38.85728], [-121.23199, 38.85706], [-121.23223, 38.85664], [-121.23169, 38.85615], [-121.23187, 38.85604], [-121.23207, 38.85594], [-121.23229, 38.85622], [-121.23279, 38.85672], [-121.23307, 38.85692], [-121.23344, 38.85711], [-121.23391, 38.85726], [-121.23432, 38.85732], [-121.23512, 38.85734], [-121.23521, 38.85733], [-121.23528, 38.8573], [-121.23536, 38.85722], [-121.23539, 38.85716], [-121.23538, 38.85709], [-121.23535, 38.85703], [-121.23481, 38.85632], [-121.23467, 38.85619], [-121.23423, 38.85591], [-121.23508, 38.85539], [-121.23522, 38.85528], [-121.23538, 38.85508], [-121.23567, 38.85513], [-121.23598, 38.85512], [-121.23627, 38.85506], [-121.23654, 38.85495], [-121.2367, 38.85506], [-121.23689, 38.85512], [-121.23792, 38.85521], [-121.24, 38.85608], [-121.24078, 38.85632], [-121.24089, 38.85632], [-121.24099, 38.85628], [-121.24103, 38.85623], [-121.24106, 38.85615], [-121.24101, 38.85591], [-121.24095, 38.85571], [-121.24086, 38.85551], [-121.24075, 38.85533], [-121.24053, 38.85507], [-121.24037, 38.85492], [-121.23933, 38.85407], [-121.23913, 38.85395], [-121.23874, 38.85378], [-121.23825, 38.85351], [-121.23812, 38.85345], [-121.23798, 38.85342], [-121.23783, 38.85341], [-121.23768, 38.85342], [-121.23749, 38.85348], [-121.23633, 38.85424], [-121.23624, 38.85436], [-121.23622, 38.85445], [-121.23622, 38.85455], [-121.23629, 38.85467], [-121.23647, 38.85488], [-121.2363, 38.85496], [-121.23612, 38.85501], [-121.23593, 38.85504], [-121.23573, 38.85504], [-121.23575, 38.85473], [-121.23569, 38.85461], [-121.23562, 38.85455], [-121.235, 38.85415], [-121.23513, 38.85399], [-121.23527, 38.85378], [-121.23548, 38.85336], [-121.23561, 38.85316], [-121.23578, 38.85298], [-121.23608, 38.85274], [-121.23631, 38.85261], [-121.23656, 38.8525], [-121.23747, 38.85224], [-121.2379, 38.85208], [-121.23815, 38.85194], [-121.23839, 38.85179], [-121.23875, 38.85147], [-121.23918, 38.85168], [-121.23932, 38.8517], [-121.23945, 38.85166], [-121.23971, 38.85144], [-121.23989, 38.85131], [-121.24009, 38.85119], [-121.24037, 38.85105], [-121.24045, 38.85097], [-121.24047, 38.85091], [-121.24046, 38.85084], [-121.24029, 38.8505], [-121.24039, 38.85047], [-121.24052, 38.85049], [-121.24064, 38.85047], [-121.24071, 38.85048], [-121.24133, 38.85073], [-121.24149, 38.85081], [-121.24164, 38.8509], [-121.24191, 38.85114], [-121.24253, 38.85188], [-121.24293, 38.85227], [-121.24339, 38.85261], [-121.24434, 38.85321], [-121.2445, 38.85335], [-121.24463, 38.85352], [-121.24483, 38.85361], [-121.24499, 38.85373], [-121.24514, 38.85393], [-121.24522, 38.85407], [-121.24525, 38.85427], [-121.2452, 38.85441], [-121.24523, 38.8545], [-121.24527, 38.85455], [-121.24541, 38.85463], [-121.24564, 38.85484], [-121.2448, 38.8554], [-121.245, 38.85558], [-121.24507, 38.85574], [-121.24523, 38.85595], [-121.2455, 38.8561], [-121.24562, 38.85623], [-121.24569, 38.85634], [-121.24574, 38.85648], [-121.24577, 38.85662], [-121.24575, 38.85673], [-121.24589, 38.85676], [-121.24586, 38.85693], [-121.24604, 38.85738], [-121.24591, 38.85784], [-121.24604, 38.85812], [-121.24602, 38.85849], [-121.24603, 38.85874], [-121.24602, 38.85881], [-121.24587, 38.85898], [-121.24566, 38.85928], [-121.24516, 38.85959], [-121.24517, 38.86006], [-121.24648, 38.8618], [-121.24751, 38.86212], [-121.24796, 38.86207], [-121.24932, 38.86259], [-121.24984, 38.86311], [-121.25003, 38.86325]]]} | Restricted Access 2 | 20819 | City of Lincoln Golf Courses | 33072 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | Placer 35 | 239.299 | City of Lincoln GC | 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]);