trees
3,247 rows where qSpecies_id = 22 sorted by qLegalStatus_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id ▼ | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8776 | 264714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
8835 | 225756 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004264.93448 | 2101628.47099 | 37.7509128342656 | -122.428094014849 | (37.7509128342656, -122.428094014849) | 2 | 4 | 5 | 28862 | 22 | |||
8872 | 80804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6015534.52104 | 2104634.07686 | 37.759796756532 | -122.389332239092 | (37.759796756532, -122.389332239092) | 10 | 3 | 8 | 28856 | 29 | |||
8933 | 6551 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1275 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6017377.10796 | 2097187.95737 | 37.7394532248805 | -122.382441492395 | (37.7394532248805, -122.382441492395) | 10 | 3 | 8 | 58 | 1 | ||
8934 | 226205 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 597 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007988.11272 | 2097011.03319 | 37.7384443240492 | -122.414892104787 | (37.7384443240492, -122.414892104787) | 2 | 7 | 7 | 28859 | 2 | |||
8956 | 5249 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1135 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1990 12:00:00 AM | 6 | 3X3 | 6001356.9176 | 2112269.0905 | 37.7799643946727 | -122.438912650424 | (37.7799643946727, -122.438912650424) | 15 | 5 | 11 | 29490 | 41 | ||
9046 | 225629 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007636.88846 | 2098165.70559 | 37.7415950574792 | -122.416188226626 | (37.7415950574792, -122.416188226626) | 2 | 7 | 7 | 28859 | 2 | |||
9099 | 150279 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | Width 4ft | 6012534.4253 | 2106906.60715 | 37.7658698369607 | -122.399867741107 | (37.7658698369607, -122.399867741107) | 14 | 3 | 8 | 28856 | 20 | ||
9164 | 264712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
9176 | 176544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.468531792305 | (37.7096104062721, -122.468531792305) | 9 | 8 | 4 | 64 | 24 | |||
9388 | 84237 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 382-384 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988116.70798 | 2113371.1409 | 37.7822281155783 | -122.484796757861 | (37.7822281155783, -122.484796757861) | 11 | 6 | 2 | 55 | 26 | |||
9427 | 225683 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90X Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007564.88173 | 2098170.09854 | 37.74160307044 | -122.416437513288 | (37.74160307044, -122.416437513288) | 2 | 7 | 7 | 28859 | 2 | |||
9489 | 219078 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993714.36027 | 2087390.34861 | 37.7112158768855 | -122.463545422096 | (37.7112158768855, -122.463545422096) | 9 | 8 | 4 | 64 | 24 | |||
9565 | 225681 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007523.22988 | 2098173.25973 | 37.7416094079456 | -122.416581755567 | (37.7416094079456, -122.416581755567) | 2 | 7 | 7 | 28859 | 2 | |||
9701 | 50525 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 278 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2020 12:00:00 AM | 3 | Permit Number 785437 | 6013437.34066 | 2105807.45901 | 37.7629021146671 | -122.396667663687 | (37.7629021146671, -122.396667663687) | 14 | 3 | 8 | 28856 | 29 | ||
9774 | 264715 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
9806 | 81718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014951.7156 | 2104031.36678 | 37.7581095159642 | -122.39130576085 | (37.7581095159642, -122.39130576085) | 10 | 3 | 8 | 28856 | 29 | |||
9938 | 200875 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011598.7362 | 2106957.8779 | 37.7659584061817 | -122.403107719273 | (37.7659584061817, -122.403107719273) | 8 | 3 | 8 | 28853 | 20 | |||
9979 | 6601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016563.26404 | 2097911.91125 | 37.7413960662634 | -122.385305868181 | (37.7413960662634, -122.385305868181) | 10 | 3 | 8 | 58 | 1 | ||
10270 | 58254 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 588 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2014 12:00:00 AM | 12 | Permit Number 772841 | 6014358.43843 | 2104381.36252 | 37.7590375848275 | -122.393382076919 | (37.7590375848275, -122.393382076919) | 10 | 3 | 8 | 28856 | 29 | ||
10304 | 71422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009722.2927 | 2120212.6608 | 37.8022479122752 | -122.410534048105 | (37.8022479122752, -122.410534048105) | 3 | 1 | 10 | 308 | 23 | |||
10315 | 264711 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
10467 | 47093 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2527 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | Permit Number 45075 | 5996913.4055 | 2110751.4542 | 37.7755435471962 | -122.454175015215 | (37.7755435471962, -122.454175015215) | 15 | 6 | 2 | 54 | 16 | |
10470 | 128936 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2618 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003606.06388 | 2117505.00365 | 37.7944685972958 | -122.431505746802 | (37.7944685972958, -122.431505746802) | 13 | 9 | 1 | 29490 | 27 | |||
10664 | 260923 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2019 12:00:00 AM | 3 | 5990807.95481 | 2114868.4417 | 37.7864956605801 | -122.475595709543 | (37.7864956605801, -122.475595709543) | 11 | 6 | 1 | 54 | 33 | |||
10689 | 120012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 379 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5986824.09694 | 2113410.67303 | 37.7822612914883 | -122.489271461219 | (37.7822612914883, -122.489271461219) | 11 | 6 | 2 | 55 | 26 | |||
10696 | 225642 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007246.85833 | 2097787.65271 | 37.7405350697311 | -122.417510034876 | (37.7405350697311, -122.417510034876) | 2 | 7 | 7 | 28859 | 2 | |||
10889 | 228271 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003334.18679 | 2107439.76679 | 37.7668165595729 | -122.43172749535 | (37.7668165595729, -122.43172749535) | 15 | 5 | 5 | 28862 | 3 | |||
10917 | 73960 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.460179309136 | (37.7084764663958, -122.460179309136) | 9 | 8 | 6 | 28861 | 25 | |||
11023 | 6550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1225X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2013 12:00:00 AM | 3 | 4x4 | 6017625.4418446 | 2096995.6120179 | 37.7389387975003 | -122.381569480835 | (37.7389387975003, -122.381569480835) | 10 | 3 | 8 | 58 | 1 | ||
11133 | 261245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 40 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006991 | 2095570 | 37.7344314860328 | -122.418237504879 | (37.7344314860328, -122.418237504879) | 2 | 7 | 7 | 28859 | 2 | ||||
11165 | 225764 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 592 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003626.8723 | 2104846.99451 | 37.7597140171093 | -122.430530121768 | (37.7597140171093, -122.430530121768) | 2 | 4 | 5 | 28862 | 3 | |||
11197 | 19797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
11262 | 258169 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 148 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6010466.36455 | 2093776.54364 | 37.7297020458087 | -122.406095661025 | (37.7297020458087, -122.406095661025) | 10 | 3 | 7 | 309 | 28 | ||
11683 | 150282 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012538.56716 | 2106816.55078 | 37.7656227931865 | -122.399847090876 | (37.7656227931865, -122.399847090876) | 14 | 3 | 8 | 28856 | 20 | |||
11687 | 95013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.405649829104 | (37.7118779294401, -122.405649829104) | 9 | 7 | 8 | 309 | 39 | ||||
11840 | 190512 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6015812.43568 | 2113078.6641 | 37.7829991439482 | -122.38896064551 | (37.7829991439482, -122.38896064551) | 6 | 2 | 9 | 28856 | 6 | |||
11854 | 72418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3878 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5996349.46796 | 2114952.54152 | 37.7870462658131 | -122.456429650633 | (37.7870462658131, -122.456429650633) | 11 | 6 | 1 | 54 | 31 | |||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
12006 | 17808 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004382.775 | 2115429.5647 | 37.7888139592602 | -122.4286702126 | (37.7888139592602, -122.4286702126) | 13 | 9 | 11 | 28858 | 27 | |||
12103 | 192453 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015095.71997 | 2102505.07691 | 37.7539266405026 | -122.390701069299 | (37.7539266405026, -122.390701069299) | 10 | 3 | 8 | 28856 | 29 | |||
12146 | 80632 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 261-263 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013772.88089 | 2105882.21581 | 37.7631260494579 | -122.395512375704 | (37.7631260494579, -122.395512375704) | 14 | 3 | 8 | 28856 | 29 | |||
12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
12208 | 190492 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6015312.24709 | 2113599.76666 | 37.7844022356283 | -122.390727534552 | (37.7844022356283, -122.390727534552) | 6 | 2 | 9 | 28856 | 6 | |||
12292 | 74182 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994679.00139 | 2086362.08429 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | 9 | 8 | 6 | 28861 | 25 | |||
12414 | 225687 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 26 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009954.93782 | 2099199.55423 | 37.7445638490343 | -122.408246060928 | (37.7445638490343, -122.408246060928) | 2 | 7 | 7 | 28859 | 2 | |||
12449 | 80636 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 261-263 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013774.02904 | 2105871.68608 | 37.7630972009925 | -122.395507666864 | (37.7630972009925, -122.395507666864) | 14 | 3 | 8 | 28856 | 29 | |||
12559 | 30713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 3 | Permit Number 34618 | 6005868.3438 | 2109981.6465 | 37.7739392736408 | -122.42314294996 | (37.7739392736408, -122.42314294996) | 7 | 9 | 11 | 28852 | 10 | |
12704 | 72671 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 203 04th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5994585.61762 | 2114114.79768 | 37.7846446297113 | -122.462471346717 | (37.7846446297113, -122.462471346717) | 11 | 6 | 2 | 54 | 11 | |||
12711 | 190451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016356.86171 | 2098066.94132 | 37.7418103263734 | -122.386030346736 | (37.7418103263734, -122.386030346736) | 10 | 3 | 8 | 58 | 1 | |||
12736 | 219124 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 70 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001597.50006 | 2094955.90851 | 37.7324402629898 | -122.436840624998 | (37.7324402629898, -122.436840624998) | 9 | 7 | 5 | 63 | 40 | |||
12820 | 226199 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008874.37746 | 2096929.55374 | 37.7382703591781 | -122.411822063942 | (37.7382703591781, -122.411822063942) | 10 | 7 | 7 | 28859 | 2 | |||
12826 | 19801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
12858 | 128984 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006377.26428 | 2110951.50272 | 37.7766309716791 | -122.421451397362 | (37.7766309716791, -122.421451397362) | 7 | 9 | 11 | 28852 | 10 | |||
12872 | 225999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | 15 | 5 | 5 | 29492 | 9 | |||
12946 | 192425 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Clara St | 6 | : | Tree | Private 2 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.7796012912124 | -122.402233334018 | (37.7796012912124, -122.402233334018) | 6 | 2 | 9 | 28856 | 34 | |||
12981 | 150277 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | Width 4ft | 6012531.20718 | 2106963.7474 | 37.7660265519105 | -122.399882884798 | (37.7660265519105, -122.399882884798) | 14 | 3 | 8 | 28856 | 20 | ||
12989 | 139211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2031 Post St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002368.8281 | 2113997.6031 | 37.7847679739293 | -122.435535694505 | (37.7847679739293, -122.435535694505) | 13 | 6 | 11 | 29490 | 13 | |||
13047 | 70677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 110 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010274.94764 | 2110617.18135 | 37.7759319943133 | -122.407944528121 | (37.7759319943133, -122.407944528121) | 8 | 2 | 9 | 28853 | 34 | |||
13172 | 264709 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
13275 | 225677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600X Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008676.00847 | 2096910.24517 | 37.7382062114413 | -122.412506564025 | (37.7382062114413, -122.412506564025) | 10 | 7 | 7 | 28859 | 2 | |||
13295 | 72207 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331 | (37.8025135249949, -122.40843327331) | 3 | 1 | 10 | 308 | 23 | |||
13302 | 231498 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:05:00 PM | 3 | Width 3ft | 6011317.42279 | 2101858.91316 | 37.7519420696849 | -122.403721918837 | (37.7519420696849, -122.403721918837) | 10 | 4 | 8 | 28859 | 19 | ||
13365 | 225615 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002593.03805 | 2095538.61045 | 37.73409676026 | -122.43344044482 | (37.73409676026, -122.43344044482) | 2 | 7 | 5 | 63 | 7 | |||
13446 | 226197 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 801x Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009034.07414 | 2096916.87656 | 37.7382445081807 | -122.411269014179 | (37.7382445081807, -122.411269014179) | 10 | 7 | 7 | 28859 | 2 | |||
13460 | 190428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 26 | : | Tree | Private 2 | 1 | Width 3ft | 6017641.63274 | 2097108.43991 | 37.7392494942632 | -122.381521343831 | (37.7392494942632, -122.381521343831) | 10 | 3 | 8 | 58 | 1 | |||
13502 | 225668 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007886.44005 | 2096099.07772 | 37.7359345806165 | -122.415179104548 | (37.7359345806165, -122.415179104548) | 2 | 7 | 7 | 28859 | 2 | |||
13555 | 226201 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701X Jarboe Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008833.56872 | 2096933.18629 | 37.7382780438907 | -122.411963417589 | (37.7382780438907, -122.411963417589) | 10 | 7 | 7 | 28859 | 2 | |||
13578 | 253069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
13610 | 247805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 488 30th St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.7419067175277 | -122.430676143802 | (37.7419067175277, -122.430676143802) | 2 | 7 | 5 | 63 | 22 | |||
13942 | 192464 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 797 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015635.55835 | 2103917.93744 | 37.7578359916633 | -122.388932798913 | (37.7578359916633, -122.388932798913) | 10 | 3 | 8 | 28856 | 29 | |||
13965 | 225680 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 901X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007829.14315 | 2097739.40397 | 37.7404353358322 | -122.415493298878 | (37.7404353358322, -122.415493298878) | 2 | 7 | 7 | 28859 | 2 | |||
14001 | 49817 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1226 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46608 | 6012208.77564 | 2102677.65266 | 37.7542399031726 | -122.400696986204 | (37.7542399031726, -122.400696986204) | 10 | 3 | 8 | 28856 | 29 |
14020 | 225632 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Powhattan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007685.38755 | 2098160.84073 | 37.7415844265716 | -122.416020188286 | (37.7415844265716, -122.416020188286) | 2 | 7 | 7 | 28859 | 2 | |||
14023 | 226231 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2831 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009237.08939 | 2103907.61142 | 37.7574509019423 | -122.411060731168 | (37.7574509019423, -122.411060731168) | 2 | 4 | 7 | 28859 | 19 | |||
14048 | 19740 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
14185 | 75407 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 194X Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6010525.12192 | 2111307.03338 | 37.7778401704149 | -122.407127744063 | (37.7778401704149, -122.407127744063) | 14 | 2 | 9 | 28853 | 34 | |||
14371 | 1412 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 87 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017443.0312922 | 2095232.0493547 | 37.7340863325513 | -122.382077533105 | (37.7340863325513, -122.382077533105) | 10 | 3 | 8 | 58 | 1 | ||
14392 | 128960 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007843 | 2112396 | 37.7806797483911 | -122.416483319824 | (37.7806797483911, -122.416483319824) | 7 | 10 | 9 | 28852 | 36 | |||
14461 | 62082 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1985 12:00:00 AM | 5 | Permit Number 22166 | 6013236.0728 | 2104376.01067 | 37.7589604679833 | -122.397263399784 | (37.7589604679833, -122.397263399784) | 10 | 3 | 8 | 28856 | 29 | |
14531 | 84257 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 894 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988243.88098 | 2109914.2292 | 37.7727438112406 | -122.484103215339 | (37.7727438112406, -122.484103215339) | 11 | 6 | 2 | 55 | 26 | |||
14644 | 128956 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 190 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008324.7013 | 2112452.543 | 37.7808620795531 | -122.414820881171 | (37.7808620795531, -122.414820881171) | 7 | 10 | 9 | 28852 | 36 | |||
14739 | 226064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005624.89593 | 2103166.13242 | 37.7552117465446 | -122.423500439705 | (37.7552117465446, -122.423500439705) | 2 | 4 | 5 | 28859 | 19 | |||
14792 | 226083 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1681 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009334.76318 | 2099698.46458 | 37.7458990005447 | -122.410425730686 | (37.7458990005447, -122.410425730686) | 2 | 7 | 7 | 28859 | 2 | |||
14813 | 190494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 541 Delancey St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6015224.29962 | 2113700.39003 | 37.7846736447102 | -122.391038840285 | (37.7846736447102, -122.391038840285) | 6 | 2 | 9 | 28856 | 6 | |||
14821 | 226044 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3548 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005910.57761 | 2105523.0579 | 37.7616994342103 | -122.422679949545 | (37.7616994342103, -122.422679949545) | 8 | 4 | 5 | 28859 | 19 | |||
14854 | 74616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2350 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5991316.62714 | 2112033.26872 | 37.7787405344574 | -122.473628955238 | (37.7787405344574, -122.473628955238) | 11 | 6 | 2 | 54 | 26 | |||
15361 | 36968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 118 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1998 12:00:00 AM | 5 | Permit Number 39595 | 5993987.97624 | 2114726.89582 | 37.786290850626 | -122.464583430573 | (37.786290850626, -122.464583430573) | 11 | 6 | 1 | 54 | 11 | ||
15486 | 81720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014948.39032 | 2104075.36829 | 37.7582301501175 | -122.39132033706 | (37.7582301501175, -122.39132033706) | 10 | 3 | 8 | 28856 | 29 | |||
15540 | 124027 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 201 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991798.47727 | 2113998.77869 | 37.7841651786362 | -122.47210536759 | (37.7841651786362, -122.47210536759) | 11 | 6 | 2 | 54 | 11 | |||
15552 | 149669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6011308.34689 | 2106942.89259 | 37.765901038939 | -122.404111067171 | (37.765901038939, -122.404111067171) | 8 | 3 | 8 | 28853 | 20 | |||
15610 | 78628 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 695 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6011848.41815 | 2105223.54822 | 37.7612102650599 | -122.402122174202 | (37.7612102650599, -122.402122174202) | 10 | 3 | 8 | 28856 | 29 | |||
15669 | 226292 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Width 2ft | Permit Number 29820 | 6003335.67331 | 2095877.19361 | 37.7350685379825 | -122.430897079359 | (37.7350685379825, -122.430897079359) | 2 | 7 | 5 | 63 | 7 | |
15719 | 7346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2225 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/1980 12:00:00 AM | 1 | 3X3 | 6002798.59801 | 2115979.15257 | 37.7902332041481 | -122.43419054146 | (37.7902332041481, -122.43419054146) | 13 | 9 | 1 | 29490 | 27 | ||
15826 | 83441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 325 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6014074.06894 | 2105534.94834 | 37.7621892769404 | -122.394446342739 | (37.7621892769404, -122.394446342739) | 10 | 3 | 8 | 28856 | 29 | ||
15859 | 228223 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 176 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000130.83227 | 2104896.01094 | 37.7596499359143 | -122.442624675007 | (37.7596499359143, -122.442624675007) | 2 | 4 | 5 | 28862 | 3 | |||
15910 | 226183 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 330 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008608.53672 | 2097126.22235 | 37.7387954508426 | -122.412755113274 | (37.7387954508426, -122.412755113274) | 10 | 7 | 7 | 28859 | 2 | |||
15997 | 225696 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3342 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6x9 | 6006072.97895 | 2103191.31452 | 37.7553061717546 | -122.421952622821 | (37.7553061717546, -122.421952622821) | 2 | 4 | 5 | 28859 | 19 | |||
16071 | 202049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Exeter St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6012555.81447 | 2090941.8893 | 37.7220353110641 | -122.398673311925 | (37.7220353110641, -122.398673311925) | 10 | 3 | 8 | 58 | 1 | |||
16074 | 128922 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004454.93777 | 2116689.88617 | 37.7922785673477 | -122.428510409935 | (37.7922785673477, -122.428510409935) | 13 | 9 | 1 | 28858 | 27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );