units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 9, DES_TP = 474 and MNG_AG_TYP = 8
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5925 | 5925 | 5924 | {"type": "Polygon", "coordinates": [[[-122.44138, 37.61408], [-122.44117, 37.61412], [-122.44069, 37.61392], [-122.44002, 37.61339], [-122.43948, 37.61261], [-122.43864, 37.61177], [-122.43763, 37.61092], [-122.43671, 37.61028], [-122.43634, 37.60975], [-122.43625, 37.60948], [-122.43585, 37.6092], [-122.43502, 37.60891], [-122.43444, 37.60826], [-122.43427, 37.60785], [-122.43386, 37.60742], [-122.43315, 37.60696], [-122.433, 37.60668], [-122.43269, 37.60643], [-122.43245, 37.60595], [-122.43182, 37.60556], [-122.43113, 37.60494], [-122.43007, 37.60428], [-122.429, 37.60304], [-122.42866, 37.60291], [-122.42866, 37.60265], [-122.42805, 37.60208], [-122.42785, 37.60169], [-122.42702, 37.60087], [-122.42702, 37.60064], [-122.42725, 37.60053], [-122.4273, 37.60029], [-122.42656, 37.59972], [-122.4263, 37.59931], [-122.4259, 37.59895], [-122.42521, 37.59867], [-122.42492, 37.59842], [-122.42474, 37.59792], [-122.42394, 37.59723], [-122.42377, 37.59698], [-122.42371, 37.59661], [-122.42328, 37.59636], [-122.42239, 37.59643], [-122.42224, 37.59631], [-122.42218, 37.59526], [-122.42167, 37.59434], [-122.41931, 37.59171], [-122.41899, 37.59171], [-122.41879, 37.5918], [-122.41859, 37.59207], [-122.41859, 37.59288], [-122.41844, 37.59299], [-122.41819, 37.59299], [-122.41781, 37.5926], [-122.41764, 37.59228], [-122.41761, 37.59203], [-122.41793, 37.5915], [-122.41796, 37.59125], [-122.41784, 37.59111], [-122.41727, 37.59093], [-122.41727, 37.59073], [-122.41752, 37.59036], [-122.41764, 37.58917], [-122.41689, 37.58837], [-122.41661, 37.58784], [-122.41638, 37.58773], [-122.41637, 37.58752], [-122.41597, 37.58718], [-122.41505, 37.58692], [-122.41502, 37.58608], [-122.41416, 37.58534], [-122.41381, 37.58532], [-122.41347, 37.58553], [-122.4131, 37.58562], [-122.41298, 37.58553], [-122.41307, 37.5851], [-122.41295, 37.58495], [-122.41269, 37.58493], [-122.41238, 37.58502], [-122.4122, 37.58496], [-122.41154, 37.58502], [-122.4114, 37.58493], [-122.41143, 37.58452], [-122.41238, 37.58431], [-122.41261, 37.58418], [-122.41261, 37.58397], [-122.412, 37.58335], [-122.4114, 37.58305], [-122.41117, 37.58267], [-122.41082, 37.58262], [-122.41054, 37.58271], [-122.41016, 37.58271], [-122.40996, 37.58234], [-122.41008, 37.58209], [-122.41054, 37.58179], [-122.41057, 37.58127], [-122.41045, 37.58074], [-122.41085, 37.58049], [-122.41224, 37.58006], [-122.41246, 37.5801], [-122.41284, 37.58042], [-122.41341, 37.58063], [-122.4141, 37.58076], [-122.41482, 37.58061], [-122.41689, 37.58061], [-122.41741, 37.58068], [-122.41738, 37.58088], [-122.41707, 37.58104], [-122.41675, 37.58109], [-122.41517, 37.582], [-122.41506, 37.58221], [-122.41548, 37.58267], [-122.41563, 37.58301], [-122.41615, 37.58329], [-122.41661, 37.58365], [-122.41713, 37.58381], [-122.41902, 37.58388], [-122.41899, 37.58404], [-122.41856, 37.58443], [-122.4183, 37.58503], [-122.41836, 37.58534], [-122.41845, 37.58557], [-122.41905, 37.58617], [-122.41946, 37.58672], [-122.41974, 37.5869], [-122.42037, 37.587], [-122.42063, 37.58713], [-122.42075, 37.58745], [-122.42101, 37.5877], [-122.42196, 37.58796], [-122.42262, 37.58802], [-122.42382, 37.58789], [-122.42432, 37.58761], [-122.4246, 37.58764], [-122.42414, 37.58853], [-122.42417, 37.58871], [-122.42472, 37.58892], [-122.42742, 37.58853], [-122.42794, 37.58862], [-122.42788, 37.58876], [-122.42742, 37.58894], [-122.42711, 37.58917], [-122.42636, 37.58949], [-122.42575, 37.59011], [-122.42552, 37.59057], [-122.42564, 37.59086], [-122.42587, 37.59112], [-122.42584, 37.5913], [-122.42558, 37.59148], [-122.42549, 37.59171], [-122.42552, 37.59247], [-122.42567, 37.59279], [-122.42587, 37.59297], [-122.42595, 37.59322], [-122.42633, 37.59354], [-122.42742, 37.59402], [-122.42805, 37.59439], [-122.42857, 37.5945], [-122.43027, 37.59432], [-122.43061, 37.5945], [-122.43044, 37.59494], [-122.43047, 37.59526], [-122.43099, 37.59567], [-122.43102, 37.59599], [-122.43093, 37.59613], [-122.43038, 37.59631], [-122.42926, 37.59638], [-122.42906, 37.59652], [-122.42895, 37.59691], [-122.42906, 37.59716], [-122.4305, 37.59796], [-122.43119, 37.59812], [-122.43277, 37.59881], [-122.4343, 37.59993], [-122.43427, 37.60014], [-122.43378, 37.60073], [-122.43378, 37.60119], [-122.43401, 37.60158], [-122.43424, 37.60169], [-122.43556, 37.60183], [-122.43594, 37.60201], [-122.43628, 37.6024], [-122.43634, 37.60286], [-122.43651, 37.60304], [-122.43692, 37.60298], [-122.43738, 37.60302], [-122.43801, 37.6033], [-122.43893, 37.60321], [-122.43953, 37.60353], [-122.43979, 37.60387], [-122.43994, 37.60426], [-122.44066, 37.6052], [-122.44109, 37.60561], [-122.44117, 37.60579], [-122.44115, 37.60632], [-122.44103, 37.60662], [-122.44022, 37.60728], [-122.44002, 37.60735], [-122.43942, 37.60694], [-122.43801, 37.60659], [-122.43754, 37.60625], [-122.43712, 37.60623], [-122.43654, 37.60654], [-122.43643, 37.60696], [-122.4366, 37.60737], [-122.4372, 37.60797], [-122.43781, 37.60831], [-122.43795, 37.60865], [-122.43821, 37.609], [-122.43844, 37.60994], [-122.44025, 37.61158], [-122.44083, 37.61243], [-122.44137, 37.61362], [-122.44138, 37.61408]]]} | Restricted Access 2 | 408 | San Francisco Watershed Lands | 24889 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 478.92 | San Francisco Watershed Lands | None 474 |
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]);