units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_NAME = 938 and DES_TP = 16
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9926 | 9926 | 9925 | {"type": "MultiPolygon", "coordinates": [[[[-122.24863, 37.40116], [-122.24858, 37.40128], [-122.24857, 37.40138], [-122.2485, 37.40152], [-122.24845, 37.40167], [-122.24843, 37.40184], [-122.24838, 37.40196], [-122.24814, 37.40227], [-122.248, 37.40263], [-122.24802, 37.40288], [-122.24775, 37.40305], [-122.24701, 37.40248], [-122.24627, 37.40217], [-122.24622, 37.40169], [-122.24555, 37.40159], [-122.24558, 37.40139], [-122.24559, 37.40123], [-122.24568, 37.40119], [-122.2457, 37.40102], [-122.24567, 37.40079], [-122.24557, 37.40042], [-122.24546, 37.40022], [-122.24524, 37.39994], [-122.24512, 37.39983], [-122.24499, 37.39966], [-122.24488, 37.39948], [-122.24475, 37.39923], [-122.24472, 37.39914], [-122.24469, 37.39889], [-122.24471, 37.3988], [-122.24475, 37.39874], [-122.24485, 37.39867], [-122.24494, 37.39863], [-122.24508, 37.39861], [-122.24518, 37.39855], [-122.24521, 37.3985], [-122.24532, 37.39847], [-122.24545, 37.39847], [-122.24599, 37.39871], [-122.24622, 37.39874], [-122.24635, 37.39886], [-122.24674, 37.39905], [-122.2469, 37.39916], [-122.24718, 37.39927], [-122.24757, 37.39946], [-122.24777, 37.3996], [-122.24793, 37.39978], [-122.2483, 37.40012], [-122.24839, 37.40026], [-122.24857, 37.40076], [-122.24863, 37.40116]]], [[[-122.24529, 37.40123], [-122.24527, 37.40141], [-122.24523, 37.40157], [-122.24487, 37.40162], [-122.24438, 37.40227], [-122.24487, 37.40246], [-122.24445, 37.40353], [-122.24437, 37.40389], [-122.24434, 37.40427], [-122.24438, 37.40469], [-122.24449, 37.40511], [-122.24525, 37.40675], [-122.24532, 37.40694], [-122.24535, 37.40714], [-122.24536, 37.40739], [-122.24531, 37.40764], [-122.24524, 37.40782], [-122.24516, 37.40798], [-122.24504, 37.40815], [-122.24477, 37.40841], [-122.2445, 37.40859], [-122.24344, 37.40915], [-122.24206, 37.41025], [-122.24059, 37.41156], [-122.23918, 37.41055], [-122.23716, 37.41093], [-122.23668, 37.41129], [-122.23635, 37.41141], [-122.23611, 37.4113], [-122.23599, 37.41092], [-122.2355, 37.41083], [-122.2349, 37.4106], [-122.23481, 37.41057], [-122.23472, 37.41053], [-122.23464, 37.41052], [-122.23463, 37.41051], [-122.23448, 37.41019], [-122.23354, 37.41013], [-122.23311, 37.41], [-122.23218, 37.41013], [-122.23167, 37.41053], [-122.23147, 37.41094], [-122.23116, 37.4112], [-122.2308, 37.41132], [-122.22947, 37.41164], [-122.22907, 37.41168], [-122.22818, 37.41115], [-122.22785, 37.41111], [-122.22753, 37.41117], [-122.22722, 37.41137], [-122.22683, 37.41146], [-122.22633, 37.4118], [-122.22613, 37.41218], [-122.22603, 37.41253], [-122.22307, 37.41289], [-122.22287, 37.41276], [-122.22282, 37.41269], [-122.2228, 37.41261], [-122.2227, 37.41248], [-122.22264, 37.41244], [-122.22259, 37.41233], [-122.22251, 37.41226], [-122.22211, 37.41161], [-122.22178, 37.41133], [-122.2216, 37.41122], [-122.22134, 37.4111], [-122.22116, 37.41105], [-122.22079, 37.411], [-122.22043, 37.41093], [-122.22015, 37.41084], [-122.21996, 37.41075], [-122.21978, 37.41065], [-122.21962, 37.41051], [-122.21952, 37.41038], [-122.21951, 37.41032], [-122.21941, 37.41018], [-122.21936, 37.41002], [-122.2193, 37.40994], [-122.21931, 37.40974], [-122.21917, 37.40951], [-122.21903, 37.40916], [-122.21891, 37.40896], [-122.21881, 37.40888], [-122.21867, 37.40881], [-122.21866, 37.40879], [-122.21854, 37.40855], [-122.21848, 37.40832], [-122.21839, 37.40815], [-122.21836, 37.40809], [-122.21836, 37.40803], [-122.21832, 37.40793], [-122.21811, 37.40767], [-122.21803, 37.40754], [-122.21793, 37.40742], [-122.21785, 37.40734], [-122.21767, 37.40722], [-122.21751, 37.40715], [-122.21734, 37.40711], [-122.21679, 37.40702], [-122.21655, 37.40693], [-122.2165, 37.40689], [-122.21626, 37.4068], [-122.21587, 37.40658], [-122.21592, 37.40631], [-122.21379, 37.40504], [-122.21035, 37.40363], [-122.20976, 37.40446], [-122.20482, 37.40185], [-122.20647, 37.40132], [-122.21002, 37.40039], [-122.21896, 37.39775], [-122.23376, 37.39344], [-122.23394, 37.39365], [-122.23369, 37.3937], [-122.2336, 37.39371], [-122.23356, 37.39391], [-122.2337, 37.39394], [-122.23375, 37.39398], [-122.23374, 37.39409], [-122.23345, 37.39409], [-122.23344, 37.39411], [-122.23353, 37.3943], [-122.23406, 37.39415], [-122.23417, 37.39436], [-122.23403, 37.39459], [-122.23412, 37.39473], [-122.23366, 37.39494], [-122.23376, 37.3951], [-122.23397, 37.39505], [-122.23397, 37.39538], [-122.23421, 37.39545], [-122.23423, 37.39555], [-122.23411, 37.39557], [-122.23405, 37.39576], [-122.23442, 37.39592], [-122.23433, 37.39605], [-122.23414, 37.39596], [-122.23399, 37.39597], [-122.23393, 37.39614], [-122.23425, 37.39626], [-122.23428, 37.39637], [-122.2344, 37.39645], [-122.23427, 37.39658], [-122.23411, 37.39655], [-122.23369, 37.39674], [-122.23354, 37.39662], [-122.23344, 37.39663], [-122.23335, 37.39678], [-122.23345, 37.39688], [-122.23335, 37.39694], [-122.23312, 37.397], [-122.23317, 37.39726], [-122.23339, 37.39724], [-122.2336, 37.3971], [-122.23427, 37.39735], [-122.23451, 37.39735], [-122.235, 37.39731], [-122.23527, 37.39734], [-122.23561, 37.39733], [-122.23578, 37.39712], [-122.23579, 37.39676], [-122.23621, 37.39646], [-122.23653, 37.39604], [-122.23747, 37.39598], [-122.23778, 37.39551], [-122.23809, 37.39599], [-122.23812, 37.396], [-122.238, 37.39605], [-122.23796, 37.39633], [-122.23787, 37.39651], [-122.23766, 37.39678], [-122.23773, 37.39703], [-122.23752, 37.39773], [-122.23775, 37.39814], [-122.23789, 37.39864], [-122.23783, 37.39914], [-122.23828, 37.39983], [-122.23844, 37.39983], [-122.23851, 37.39948], [-122.23892, 37.39915], [-122.23929, 37.39907], [-122.23952, 37.39911], [-122.23977, 37.39905], [-122.24024, 37.3987], [-122.2405, 37.39863], [-122.24071, 37.39855], [-122.24084, 37.39854], [-122.24138, 37.39859], [-122.24144, 37.39866], [-122.24181, 37.39875], [-122.24211, 37.39911], [-122.24239, 37.39914], [-122.2426, 37.3987], [-122.24249, 37.39866], [-122.24231, 37.39851], [-122.24235, 37.39835], [-122.24252, 37.39837], [-122.2441, 37.39833], [-122.24412, 37.39879], [-122.24417, 37.39884], [-122.24421, 37.39911], [-122.2443, 37.39936], [-122.24436, 37.39949], [-122.24443, 37.39955], [-122.2446, 37.40001], [-122.24471, 37.40011], [-122.24511, 37.40077], [-122.24521, 37.40105], [-122.24529, 37.40116], [-122.24529, 37.40123]]]]} | Restricted Access 2 | 17067 | Jasper Ridge Reserve | 20369 | 3346 | Stanford University 938 | Non Profit 6 | Non Profit - Education 34 | http://jrbp.stanford.edu/ | Non Governmental Organization 10 | 3346 | Stanford University 911 | Non Profit 6 | Non Profit - Education 32 | San Mateo 15 | 1095.659 | Jasper Ridge Reserve | 0 | Private Conservation 16 | 2 |
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]);