units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LAYER = 10 and MNG_AGENCY = 358
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15972 | 15972 | 15971 | {"type": "Polygon", "coordinates": [[[-122.03205, 38.21576], [-122.03199, 38.2159], [-122.03163, 38.21621], [-122.03151, 38.21621], [-122.0312, 38.21632], [-122.02996, 38.21683], [-122.02982, 38.21715], [-122.02989, 38.21743], [-122.03, 38.21828], [-122.02988, 38.21849], [-122.03008, 38.21854], [-122.02997, 38.21896], [-122.02979, 38.21912], [-122.02965, 38.21923], [-122.0293, 38.21942], [-122.02899, 38.21912], [-122.02876, 38.21895], [-122.02842, 38.21862], [-122.02802, 38.21838], [-122.02759, 38.21816], [-122.02704, 38.218], [-122.02616, 38.21841], [-122.02546, 38.21854], [-122.02498, 38.2186], [-122.0247, 38.21905], [-122.02456, 38.21939], [-122.02449, 38.21949], [-122.02424, 38.21965], [-122.02444, 38.21995], [-122.0246, 38.22035], [-122.02464, 38.22068], [-122.02503, 38.22075], [-122.02535, 38.22074], [-122.02631, 38.2206], [-122.02662, 38.22052], [-122.02702, 38.22081], [-122.02695, 38.22124], [-122.02682, 38.22172], [-122.02666, 38.22202], [-122.02642, 38.22235], [-122.02612, 38.22229], [-122.02602, 38.22201], [-122.02602, 38.22161], [-122.02594, 38.22134], [-122.02578, 38.2212], [-122.02545, 38.22117], [-122.02506, 38.22117], [-122.02465, 38.22132], [-122.02394, 38.22167], [-122.02374, 38.22182], [-122.02316, 38.22212], [-122.02297, 38.22213], [-122.02257, 38.22221], [-122.02236, 38.22267], [-122.02214, 38.22292], [-122.02183, 38.22353], [-122.02184, 38.22393], [-122.02184, 38.22458], [-122.02197, 38.22501], [-122.02223, 38.22511], [-122.02252, 38.22533], [-122.02299, 38.22561], [-122.02322, 38.22563], [-122.02358, 38.22595], [-122.02342, 38.22609], [-122.02316, 38.22615], [-122.02292, 38.2261], [-122.02254, 38.22589], [-122.02178, 38.22575], [-122.02146, 38.22582], [-122.02121, 38.22602], [-122.02104, 38.22631], [-122.0211, 38.22692], [-122.02113, 38.22742], [-122.02102, 38.22784], [-122.02082, 38.228], [-122.02048, 38.22815], [-122.01981, 38.22829], [-122.01943, 38.22827], [-122.01908, 38.22809], [-122.01902, 38.22767], [-122.01914, 38.22729], [-122.01945, 38.22684], [-122.01948, 38.22656], [-122.01984, 38.22618], [-122.0202, 38.22587], [-122.02035, 38.22571], [-122.02052, 38.22534], [-122.01997, 38.22483], [-122.01969, 38.22454], [-122.01937, 38.22414], [-122.01921, 38.22369], [-122.01907, 38.22316], [-122.01898, 38.22308], [-122.01867, 38.22305], [-122.01791, 38.2228], [-122.01747, 38.22286], [-122.01737, 38.22295], [-122.01697, 38.22313], [-122.01672, 38.22319], [-122.01659, 38.22342], [-122.01653, 38.2236], [-122.01658, 38.22396], [-122.01683, 38.22407], [-122.01709, 38.22409], [-122.01756, 38.22419], [-122.01773, 38.22449], [-122.01769, 38.22496], [-122.01767, 38.22536], [-122.01778, 38.22552], [-122.01793, 38.22587], [-122.01795, 38.2262], [-122.01779, 38.2263], [-122.01618, 38.22606], [-122.01579, 38.22595], [-122.01546, 38.22574], [-122.0151, 38.22524], [-122.01477, 38.22523], [-122.01482, 38.22521], [-122.01484, 38.22468], [-122.01437, 38.2236], [-122.0141, 38.2234], [-122.01411, 38.22336], [-122.01403, 38.22316], [-122.0139, 38.22309], [-122.01369, 38.22307], [-122.01342, 38.22311], [-122.0126, 38.22025], [-122.01138, 38.21489], [-122.00995, 38.20984], [-122.00725, 38.2096], [-122.0092, 38.20838], [-122.01085, 38.20677], [-122.01103, 38.20618], [-122.01111, 38.20527], [-122.0107, 38.20449], [-122.01077, 38.20419], [-122.00984, 38.2012], [-122.00988, 38.20067], [-122.00984, 38.20046], [-122.00968, 38.20013], [-122.00919, 38.19981], [-122.00887, 38.19871], [-122.00914, 38.19868], [-122.01003, 38.19839], [-122.01131, 38.19751], [-122.01221, 38.1968], [-122.01242, 38.19647], [-122.01243, 38.19644], [-122.01245, 38.19643], [-122.01261, 38.19616], [-122.01264, 38.19587], [-122.01299, 38.19559], [-122.01476, 38.19522], [-122.01842, 38.19498], [-122.02227, 38.19512], [-122.02309, 38.1953], [-122.02456, 38.19596], [-122.02561, 38.1966], [-122.02651, 38.19755], [-122.02732, 38.19869], [-122.02729, 38.19956], [-122.02677, 38.2008], [-122.027, 38.20186], [-122.02653, 38.20294], [-122.02575, 38.20342], [-122.02566, 38.2037], [-122.02575, 38.20399], [-122.0261, 38.20441], [-122.02659, 38.20487], [-122.02697, 38.20519], [-122.0281, 38.20569], [-122.02938, 38.20615], [-122.02998, 38.2067], [-122.03045, 38.20725], [-122.03045, 38.20729], [-122.03074, 38.20743], [-122.03134, 38.20828], [-122.03036, 38.20808], [-122.02981, 38.20872], [-122.02978, 38.20901], [-122.02961, 38.2092], [-122.02961, 38.20931], [-122.02978, 38.20947], [-122.03013, 38.20961], [-122.03027, 38.21036], [-122.03036, 38.21048], [-122.03036, 38.21073], [-122.03065, 38.21137], [-122.03076, 38.21167], [-122.03074, 38.21201], [-122.03001, 38.21281], [-122.03001, 38.21359], [-122.03062, 38.21482], [-122.0314, 38.2149], [-122.03205, 38.21576]]]} | Open Access 1 | 308 | Rush Ranch Open Space | 12546 | 3081 | Solano Land Trust 361 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/ | Non Governmental Organization 10 | 3081 | Solano Land Trust 358 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.solanolandtrust.org/RushRanch.aspx | Solano 26 | 1177.494 | Rush Ranch OS | 1987 | Private Recreation or Education 65 | 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]);