units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 2 and SUID_NMA = 16183
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16191 | 16191 | 16190 | {"type": "MultiPolygon", "coordinates": [[[[-121.33096, 38.78617], [-121.33052, 38.78646], [-121.33031, 38.78629], [-121.33019, 38.78624], [-121.33002, 38.78623], [-121.32975, 38.78626], [-121.32967, 38.78625], [-121.32955, 38.78626], [-121.32951, 38.78624], [-121.32941, 38.7862], [-121.32908, 38.78617], [-121.3289, 38.7861], [-121.32886, 38.78612], [-121.32881, 38.78609], [-121.32877, 38.78602], [-121.32873, 38.78601], [-121.32873, 38.78513], [-121.32903, 38.78529], [-121.32944, 38.78538], [-121.33021, 38.78538], [-121.33067, 38.7856], [-121.33088, 38.78576], [-121.33096, 38.78595], [-121.33096, 38.78617]]], [[[-121.344, 38.79455], [-121.34327, 38.79478], [-121.3428, 38.7949], [-121.34244, 38.79496], [-121.34115, 38.79514], [-121.34068, 38.79517], [-121.34013, 38.79518], [-121.34012, 38.79475], [-121.33983, 38.79472], [-121.33961, 38.79465], [-121.33921, 38.7946], [-121.33896, 38.79456], [-121.33872, 38.79445], [-121.33852, 38.79431], [-121.33819, 38.79398], [-121.33813, 38.79379], [-121.33817, 38.7937], [-121.33812, 38.79364], [-121.33812, 38.79354], [-121.33779, 38.79329], [-121.33774, 38.79317], [-121.33748, 38.79307], [-121.33718, 38.79307], [-121.3373, 38.79295], [-121.33743, 38.79294], [-121.3378, 38.793], [-121.33782, 38.79304], [-121.33792, 38.79307], [-121.33801, 38.79305], [-121.33802, 38.79298], [-121.33773, 38.79247], [-121.33769, 38.79248], [-121.33755, 38.7924], [-121.33727, 38.79201], [-121.33727, 38.79174], [-121.33719, 38.79167], [-121.33679, 38.79137], [-121.33633, 38.79124], [-121.33559, 38.79124], [-121.33517, 38.79112], [-121.33498, 38.79096], [-121.33482, 38.79084], [-121.33482, 38.79077], [-121.3344, 38.79055], [-121.3343, 38.79046], [-121.33414, 38.79038], [-121.33403, 38.7903], [-121.33384, 38.79007], [-121.33354, 38.78987], [-121.33338, 38.78983], [-121.3332, 38.78973], [-121.33299, 38.78951], [-121.33273, 38.78949], [-121.33265, 38.7895], [-121.33216, 38.78943], [-121.33206, 38.78939], [-121.33186, 38.78946], [-121.33124, 38.78922], [-121.33126, 38.78903], [-121.33132, 38.78898], [-121.33145, 38.78891], [-121.33151, 38.78877], [-121.33144, 38.78861], [-121.33138, 38.78823], [-121.33121, 38.78791], [-121.33127, 38.78787], [-121.33129, 38.78779], [-121.33105, 38.78762], [-121.33097, 38.78751], [-121.33086, 38.78743], [-121.33066, 38.78699], [-121.33065, 38.78695], [-121.33056, 38.7867], [-121.33095, 38.78645], [-121.33095, 38.78657], [-121.33106, 38.78671], [-121.33162, 38.78658], [-121.33168, 38.78652], [-121.33157, 38.78635], [-121.33163, 38.78626], [-121.33174, 38.78624], [-121.33186, 38.78618], [-121.33198, 38.78606], [-121.33205, 38.78603], [-121.33198, 38.78622], [-121.33182, 38.78645], [-121.3319, 38.7866], [-121.33193, 38.78672], [-121.33183, 38.78675], [-121.33152, 38.78676], [-121.33149, 38.78687], [-121.33132, 38.78699], [-121.33131, 38.78704], [-121.33147, 38.78716], [-121.332, 38.78745], [-121.33202, 38.78752], [-121.3321, 38.78755], [-121.33218, 38.78755], [-121.33229, 38.78749], [-121.3324, 38.78726], [-121.33254, 38.78716], [-121.33275, 38.78714], [-121.33291, 38.7872], [-121.33308, 38.78736], [-121.33313, 38.78768], [-121.33298, 38.78786], [-121.33238, 38.78827], [-121.3323, 38.78844], [-121.33232, 38.78855], [-121.33257, 38.78873], [-121.33321, 38.78898], [-121.3335, 38.78905], [-121.33367, 38.78913], [-121.33382, 38.78927], [-121.33403, 38.78925], [-121.33451, 38.78928], [-121.33462, 38.78933], [-121.33469, 38.78942], [-121.33458, 38.78978], [-121.33467, 38.79003], [-121.33492, 38.79024], [-121.33494, 38.79023], [-121.33519, 38.78892], [-121.33527, 38.78895], [-121.33537, 38.78884], [-121.33515, 38.78844], [-121.33545, 38.78814], [-121.33549, 38.78812], [-121.33555, 38.78813], [-121.33571, 38.78823], [-121.3359, 38.78831], [-121.33632, 38.78846], [-121.33662, 38.78863], [-121.3368, 38.78871], [-121.33707, 38.78879], [-121.3374, 38.78884], [-121.33743, 38.78887], [-121.33744, 38.78901], [-121.33748, 38.78913], [-121.33759, 38.78932], [-121.33778, 38.78949], [-121.3379, 38.78957], [-121.33806, 38.78965], [-121.33834, 38.78971], [-121.33859, 38.78973], [-121.33885, 38.78969], [-121.33921, 38.78959], [-121.33937, 38.78957], [-121.33946, 38.78958], [-121.33949, 38.78963], [-121.33949, 38.79017], [-121.33905, 38.79018], [-121.33906, 38.79099], [-121.33944, 38.791], [-121.3394, 38.79104], [-121.33938, 38.7911], [-121.33939, 38.79116], [-121.33943, 38.79121], [-121.33906, 38.79145], [-121.33906, 38.79173], [-121.34011, 38.79174], [-121.34012, 38.79303], [-121.34096, 38.79326], [-121.34094, 38.79355], [-121.34114, 38.79372], [-121.34133, 38.79379], [-121.34156, 38.7938], [-121.34185, 38.79366], [-121.34193, 38.79355], [-121.34321, 38.79411], [-121.3436, 38.79433], [-121.34385, 38.79429], [-121.344, 38.79455]]]]} | Open Access 1 | 29446 | Blue Oaks Open Space | 16183 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 69.837 | Blue Oaks 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]);