units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_WEB = "http://riverpartners.org/" and MNG_AGENCY = 1064
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14355 | 14355 | 14354 | {"type": "Polygon", "coordinates": [[[-121.17744, 37.60579], [-121.17736, 37.60597], [-121.17728, 37.60603], [-121.17707, 37.60609], [-121.17683, 37.60609], [-121.17638, 37.60601], [-121.17508, 37.60553], [-121.17465, 37.60545], [-121.17401, 37.60516], [-121.17283, 37.60475], [-121.17251, 37.60448], [-121.17234, 37.6044], [-121.17206, 37.60435], [-121.17177, 37.60439], [-121.17086, 37.60473], [-121.17049, 37.6049], [-121.17019, 37.60519], [-121.16969, 37.60581], [-121.1695, 37.60618], [-121.16863, 37.60742], [-121.16844, 37.6078], [-121.16796, 37.60817], [-121.16769, 37.60844], [-121.16758, 37.60865], [-121.16732, 37.60892], [-121.16726, 37.60907], [-121.16728, 37.60932], [-121.1673, 37.60955], [-121.16742, 37.60995], [-121.16742, 37.61022], [-121.16763, 37.61074], [-121.16786, 37.61118], [-121.1679, 37.61136], [-121.16788, 37.61154], [-121.16771, 37.61217], [-121.16759, 37.61235], [-121.16688, 37.61303], [-121.16643, 37.61334], [-121.16539, 37.61363], [-121.16516, 37.61373], [-121.16448, 37.61394], [-121.16402, 37.61399], [-121.16278, 37.61398], [-121.1619, 37.61413], [-121.16134, 37.61416], [-121.16111, 37.61414], [-121.16066, 37.61425], [-121.15967, 37.61467], [-121.15928, 37.61479], [-121.15911, 37.61486], [-121.15837, 37.61491], [-121.15756, 37.61477], [-121.15682, 37.61452], [-121.15635, 37.61428], [-121.15595, 37.61386], [-121.15585, 37.61372], [-121.15568, 37.61321], [-121.15546, 37.61282], [-121.15547, 37.61239], [-121.15558, 37.61194], [-121.15581, 37.6115], [-121.15604, 37.61123], [-121.15614, 37.61105], [-121.15635, 37.61048], [-121.15635, 37.61003], [-121.15628, 37.6096], [-121.15597, 37.60913], [-121.15557, 37.60884], [-121.15536, 37.60874], [-121.15464, 37.60861], [-121.15396, 37.60852], [-121.15295, 37.60827], [-121.15273, 37.60819], [-121.15192, 37.608], [-121.15154, 37.60787], [-121.15092, 37.60758], [-121.15053, 37.60732], [-121.15018, 37.60695], [-121.14939, 37.60647], [-121.14898, 37.60628], [-121.14848, 37.60623], [-121.14793, 37.60619], [-121.14748, 37.60626], [-121.1461, 37.60659], [-121.14503, 37.60678], [-121.14455, 37.60704], [-121.14432, 37.60712], [-121.14397, 37.60717], [-121.14341, 37.60717], [-121.14319, 37.60704], [-121.14287, 37.60673], [-121.14288, 37.60613], [-121.1427, 37.6056], [-121.14267, 37.6047], [-121.14276, 37.60462], [-121.14265, 37.60447], [-121.14223, 37.60327], [-121.14179, 37.60253], [-121.14155, 37.60185], [-121.14132, 37.60157], [-121.14117, 37.60149], [-121.14161, 37.60116], [-121.14239, 37.60117], [-121.14285, 37.60069], [-121.14466, 37.60018], [-121.14498, 37.59964], [-121.14542, 37.59926], [-121.14584, 37.59841], [-121.14576, 37.59774], [-121.14606, 37.59758], [-121.14585, 37.597], [-121.14515, 37.59634], [-121.14305, 37.59483], [-121.1465, 37.59484], [-121.1467, 37.59413], [-121.14689, 37.59386], [-121.14728, 37.5919], [-121.1472, 37.5908], [-121.1471, 37.58988], [-121.14712, 37.58915], [-121.14673, 37.58759], [-121.17067, 37.58736], [-121.17111, 37.58795], [-121.17124, 37.5883], [-121.1713, 37.58952], [-121.17113, 37.59029], [-121.17109, 37.59083], [-121.17103, 37.59088], [-121.17117, 37.59159], [-121.17141, 37.59209], [-121.17147, 37.59236], [-121.17164, 37.59278], [-121.17214, 37.5932], [-121.17245, 37.59326], [-121.1729, 37.59326], [-121.17347, 37.59336], [-121.17421, 37.59337], [-121.17562, 37.59347], [-121.17577, 37.59351], [-121.17612, 37.59381], [-121.17626, 37.59399], [-121.17636, 37.59417], [-121.17641, 37.59435], [-121.17641, 37.59444], [-121.17627, 37.59513], [-121.17565, 37.59593], [-121.17544, 37.59606], [-121.17464, 37.59642], [-121.17385, 37.59664], [-121.17304, 37.59675], [-121.17214, 37.59681], [-121.17191, 37.59686], [-121.17131, 37.59692], [-121.17056, 37.59717], [-121.17016, 37.59742], [-121.17, 37.59761], [-121.16988, 37.59779], [-121.16976, 37.59812], [-121.16975, 37.59851], [-121.16983, 37.59886], [-121.17021, 37.59941], [-121.1704, 37.59958], [-121.17061, 37.59971], [-121.17139, 37.60008], [-121.17162, 37.60015], [-121.17224, 37.60024], [-121.1725, 37.60025], [-121.17309, 37.6001], [-121.17366, 37.60001], [-121.1739, 37.59991], [-121.17469, 37.59949], [-121.17526, 37.59914], [-121.17637, 37.5983], [-121.17671, 37.59814], [-121.17688, 37.59809], [-121.17726, 37.59809], [-121.17781, 37.59825], [-121.17798, 37.59833], [-121.17849, 37.59868], [-121.17862, 37.59885], [-121.17887, 37.59931], [-121.17888, 37.59949], [-121.17886, 37.59958], [-121.17875, 37.59975], [-121.17855, 37.59991], [-121.17805, 37.60022], [-121.17728, 37.60091], [-121.1769, 37.60131], [-121.17668, 37.60147], [-121.17653, 37.60163], [-121.17608, 37.60243], [-121.17604, 37.60261], [-121.17607, 37.60298], [-121.17602, 37.60302], [-121.17608, 37.6031], [-121.17598, 37.60346], [-121.17623, 37.60417], [-121.17632, 37.60435], [-121.17687, 37.60511], [-121.17725, 37.60551], [-121.17739, 37.60555], [-121.17736, 37.60561], [-121.17744, 37.60579]]]} | Restricted Access 2 | 44406 | Dos Rios Ranch | 18230 | 3205 | River Partners 1110 | Non Profit 6 | Non Profit - Conservation 12 | http://riverpartners.org/ | Non Governmental Organization 10 | 3205 | River Partners 1064 | Non Profit 6 | Non Profit - Conservation 12 | Stanislaus 2 | 1563.144 | Dos Rios Ranch | 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]);