units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where AGNCY_LEV = 2, MNG_AGENCY = 425 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 4
- Local Recreation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 11 ✖
MNG_AGENCY 1
- Corte Madera, Town of · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1845 | 1845 | 1844 | {"type": "Polygon", "coordinates": [[[-122.50067, 37.9218], [-122.49945, 37.92181], [-122.49936, 37.9201], [-122.50047, 37.91971], [-122.50066, 37.92009], [-122.50067, 37.9218]]]} | Open Access 1 | 14087 | San Clemente Park | 24850 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 5.785 | San Clemente Park | 0 | Local Park 2 | 4 | |
1908 | 1908 | 1907 | {"type": "Polygon", "coordinates": [[[-122.52168, 37.93833], [-122.52146, 37.93845], [-122.52134, 37.938], [-122.52124, 37.93801], [-122.52119, 37.9379], [-122.52087, 37.93787], [-122.52102, 37.93776], [-122.52144, 37.93755], [-122.52168, 37.93833]]]} | Open Access 1 | 16356 | Higgins Dock | 19926 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 0.624 | Higgins Dock | None 156 | |||
2159 | 2159 | 2158 | {"type": "Polygon", "coordinates": [[[-122.5122, 37.93636], [-122.50745, 37.93685], [-122.50733, 37.93585], [-122.50733, 37.93514], [-122.50753, 37.93394], [-122.50773, 37.93298], [-122.50798, 37.93199], [-122.50819, 37.9308], [-122.50832, 37.93034], [-122.50839, 37.92998], [-122.50843, 37.92956], [-122.50862, 37.92877], [-122.50865, 37.92853], [-122.50876, 37.92835], [-122.50901, 37.92814], [-122.50954, 37.92788], [-122.50987, 37.92778], [-122.5106, 37.92744], [-122.51067, 37.9274], [-122.51066, 37.9273], [-122.51068, 37.92728], [-122.51062, 37.9269], [-122.51051, 37.92633], [-122.51056, 37.9263], [-122.51068, 37.92631], [-122.51084, 37.92759], [-122.51106, 37.9289], [-122.5122, 37.93636]]]} | Restricted Access 2 | 16168 | Muzzi Marsh | 22617 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 77.169 | Muzzi Marsh | None 177 | |||
4137 | 4137 | 4136 | {"type": "Polygon", "coordinates": [[[-122.53246, 37.93159], [-122.5326, 37.93208], [-122.53259, 37.93213], [-122.5325, 37.93248], [-122.53243, 37.93266], [-122.53232, 37.93283], [-122.53211, 37.9331], [-122.53199, 37.9332], [-122.53195, 37.93315], [-122.53174, 37.93329], [-122.5318, 37.93337], [-122.53158, 37.93351], [-122.53118, 37.93369], [-122.53094, 37.93377], [-122.53069, 37.93383], [-122.52738, 37.9342], [-122.5266, 37.93425], [-122.51873, 37.93505], [-122.51868, 37.93482], [-122.51906, 37.93475], [-122.52061, 37.9346], [-122.5212, 37.93452], [-122.52175, 37.93448], [-122.53016, 37.93363], [-122.53014, 37.93351], [-122.53063, 37.93344], [-122.53109, 37.93329], [-122.53114, 37.93336], [-122.53144, 37.93322], [-122.53168, 37.93306], [-122.53172, 37.93308], [-122.53205, 37.93271], [-122.53221, 37.93243], [-122.53226, 37.93229], [-122.53232, 37.932], [-122.53232, 37.93185], [-122.5323, 37.93161], [-122.53246, 37.93159]]]} | Open Access 1 | 47193 | Corte Madera Bike Trail | 30887 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 10.039 | Corte Madera Bike Trail | 0 | Local Recreation Area 3 | 4 | |
8694 | 8694 | 8693 | {"type": "Polygon", "coordinates": [[[-122.50561, 37.91608], [-122.50538, 37.91614], [-122.50525, 37.91622], [-122.50518, 37.91631], [-122.50514, 37.91647], [-122.50398, 37.9167], [-122.50342, 37.91679], [-122.50269, 37.91538], [-122.50211, 37.91461], [-122.50194, 37.91442], [-122.50148, 37.91379], [-122.50255, 37.91364], [-122.50502, 37.91498], [-122.50518, 37.91505], [-122.50547, 37.91583], [-122.50551, 37.91583], [-122.50561, 37.91608]]]} | Open Access 1 | 14088 | Granada Park | 19419 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 15.652 | Granada Park | 0 | Local Park 2 | 4 | |
9101 | 9101 | 9100 | {"type": "Polygon", "coordinates": [[[-122.52993, 37.9261], [-122.52956, 37.92625], [-122.52956, 37.92628], [-122.52931, 37.92637], [-122.52891, 37.92591], [-122.52876, 37.92566], [-122.52974, 37.92583], [-122.52993, 37.9261]]]} | Open Access 1 | 15085 | Menke Park | 22156 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 1.03 | Menke Park | 0 | Local Park 2 | 4 | |
9608 | 9608 | 9607 | {"type": "MultiPolygon", "coordinates": [[[[-122.52079, 37.93171], [-122.52061, 37.93211], [-122.5206, 37.93211], [-122.52057, 37.93201], [-122.52054, 37.93195], [-122.52041, 37.93184], [-122.52019, 37.93177], [-122.52, 37.93177], [-122.51983, 37.93183], [-122.51972, 37.93193], [-122.51966, 37.93202], [-122.51956, 37.93234], [-122.51946, 37.93243], [-122.51866, 37.9325], [-122.51856, 37.93247], [-122.51851, 37.93239], [-122.51846, 37.93213], [-122.51848, 37.93206], [-122.51855, 37.93203], [-122.51874, 37.932], [-122.51896, 37.93191], [-122.51907, 37.93183], [-122.51914, 37.93175], [-122.51922, 37.93157], [-122.51923, 37.93143], [-122.51917, 37.93099], [-122.5192, 37.93066], [-122.51927, 37.93033], [-122.51925, 37.93019], [-122.51919, 37.93005], [-122.51911, 37.92995], [-122.51903, 37.92987], [-122.51877, 37.92972], [-122.51874, 37.92965], [-122.51875, 37.92961], [-122.51886, 37.92952], [-122.51898, 37.92939], [-122.51915, 37.92914], [-122.51925, 37.92895], [-122.51934, 37.92865], [-122.51936, 37.92863], [-122.51941, 37.92862], [-122.52015, 37.92866], [-122.52019, 37.92867], [-122.52022, 37.92871], [-122.52023, 37.92874], [-122.52011, 37.92908], [-122.51989, 37.9296], [-122.51985, 37.92971], [-122.51982, 37.92992], [-122.51984, 37.93013], [-122.51992, 37.93042], [-122.52038, 37.93129], [-122.52054, 37.9315], [-122.52079, 37.93171]]], [[[-122.52294, 37.93336], [-122.52292, 37.93325], [-122.5229, 37.93319], [-122.52286, 37.93313], [-122.5228, 37.93308], [-122.52261, 37.93301], [-122.52249, 37.933], [-122.52236, 37.93301], [-122.52218, 37.9331], [-122.52208, 37.93318], [-122.52203, 37.93326], [-122.52201, 37.93332], [-122.52201, 37.93341], [-122.52208, 37.93362], [-122.52207, 37.93367], [-122.52205, 37.93372], [-122.52198, 37.93377], [-122.52187, 37.93379], [-122.52175, 37.93378], [-122.52165, 37.93373], [-122.52161, 37.93368], [-122.52159, 37.93362], [-122.52155, 37.93312], [-122.52157, 37.93277], [-122.5216, 37.93259], [-122.52165, 37.93239], [-122.5217, 37.93231], [-122.52181, 37.93223], [-122.52193, 37.9322], [-122.52204, 37.9322], [-122.52216, 37.93223], [-122.52336, 37.9329], [-122.52351, 37.93301], [-122.52358, 37.93312], [-122.52362, 37.93333], [-122.52361, 37.93343], [-122.52353, 37.93354], [-122.52342, 37.93361], [-122.52319, 37.93365], [-122.52309, 37.93364], [-122.52298, 37.9336], [-122.52295, 37.93357], [-122.52293, 37.93352], [-122.52294, 37.93336]]]]} | Open Access 1 | 16164 | Madera Gardens Lagoons | 21651 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 13.425 | Madera Gardens Lagoons | None 814 | |||
9610 | 9610 | 9609 | {"type": "Polygon", "coordinates": [[[-122.51578, 37.93447], [-122.51567, 37.93481], [-122.51546, 37.93574], [-122.51546, 37.9358], [-122.51567, 37.93605], [-122.51514, 37.93636], [-122.51465, 37.9367], [-122.5141, 37.93719], [-122.51372, 37.93759], [-122.51345, 37.93792], [-122.51322, 37.9383], [-122.5131, 37.93865], [-122.51297, 37.93799], [-122.51263, 37.93588], [-122.51159, 37.92886], [-122.51137, 37.92754], [-122.51163, 37.92751], [-122.51171, 37.92758], [-122.51164, 37.92782], [-122.51162, 37.92803], [-122.51163, 37.92814], [-122.51181, 37.9292], [-122.51206, 37.93053], [-122.51209, 37.93066], [-122.51219, 37.9309], [-122.51226, 37.93101], [-122.5124, 37.93117], [-122.51252, 37.93127], [-122.51279, 37.93144], [-122.51308, 37.93157], [-122.51341, 37.93165], [-122.51357, 37.93168], [-122.5139, 37.9317], [-122.51498, 37.93163], [-122.51524, 37.93167], [-122.51541, 37.93172], [-122.5155, 37.93177], [-122.51556, 37.93183], [-122.51559, 37.93191], [-122.51588, 37.93331], [-122.51589, 37.93378], [-122.51585, 37.93413], [-122.51578, 37.93447]]]} | Restricted Access 2 | 16166 | Shorebird Marsh | 25419 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 46.096 | Shorebird Marsh | None 816 | |||
9631 | 9631 | 9630 | {"type": "MultiPolygon", "coordinates": [[[[-122.49968, 37.91526], [-122.49957, 37.9154], [-122.49932, 37.91576], [-122.49916, 37.91588], [-122.49906, 37.91593], [-122.49891, 37.91597], [-122.49852, 37.91597], [-122.49851, 37.91522], [-122.49868, 37.91521], [-122.49867, 37.91419], [-122.49879, 37.91418], [-122.49878, 37.914], [-122.49852, 37.914], [-122.49847, 37.91206], [-122.49888, 37.91206], [-122.49889, 37.91264], [-122.49892, 37.91281], [-122.49903, 37.91304], [-122.49921, 37.91323], [-122.4992, 37.91327], [-122.49912, 37.91339], [-122.4991, 37.91345], [-122.49911, 37.91352], [-122.4992, 37.91367], [-122.49942, 37.91387], [-122.49949, 37.91404], [-122.4995, 37.9142], [-122.49947, 37.91428], [-122.49941, 37.91433], [-122.49929, 37.91438], [-122.49923, 37.91446], [-122.49924, 37.9145], [-122.4993, 37.91456], [-122.49926, 37.91466], [-122.49933, 37.91509], [-122.49968, 37.91526]]], [[[-122.50128, 37.9134], [-122.50117, 37.91342], [-122.50104, 37.91299], [-122.50052, 37.91311], [-122.50029, 37.91295], [-122.50006, 37.91317], [-122.49969, 37.91291], [-122.49957, 37.91261], [-122.49956, 37.9122], [-122.49937, 37.91211], [-122.49906, 37.91211], [-122.49906, 37.91206], [-122.50091, 37.91204], [-122.50128, 37.9134]]]]} | Open Access 1 | 16242 | Corte Madera Open Space 001 | 17661 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 9.926 | Corte Madera OS 001 | None 819 | |||
9633 | 9633 | 9632 | {"type": "Polygon", "coordinates": [[[-122.50693, 37.91553], [-122.50672, 37.91559], [-122.50657, 37.91514], [-122.50657, 37.91506], [-122.5066, 37.91498], [-122.50693, 37.91553]]]} | Open Access 1 | 16244 | Skunk Hollow Park | 25531 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 0.217 | Skunk Hollow Park | 0 | Local Park 2 | 4 | |
13801 | 13801 | 13800 | {"type": "Polygon", "coordinates": [[[-122.52642, 37.92563], [-122.52626, 37.9274], [-122.52607, 37.92774], [-122.52598, 37.92826], [-122.52591, 37.92838], [-122.5258, 37.92848], [-122.52543, 37.92875], [-122.52519, 37.92887], [-122.52467, 37.92904], [-122.52463, 37.92737], [-122.52236, 37.92737], [-122.52236, 37.92612], [-122.52358, 37.92617], [-122.52364, 37.92551], [-122.52642, 37.92563]]]} | Open Access 1 | 36370 | Corte Madera holding 1 | 17659 | 1070 | Corte Madera, Town of 431 | City 2 | City Agency 2 | http://www.ci.corte-madera.ca.us/199/Parks-Recreation | City 2 | 1070 | Corte Madera, Town of 425 | City 2 | City Agency 2 | Marin 23 | 20.201 | Corte Madera holding 1 | 0 | Local Other or Unknown 14 | 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]);