trees
3,247 rows where qSpecies_id = 22 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8246 | 264713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th 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 | |||
| 8250 | 19840 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
| 8273 | 226143 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 165 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004761.35268 | 2102682.3331 | 37.7538345679338 | -122.426452382491 | (37.7538345679338, -122.426452382491) | 2 | 4 | 5 | 28862 | 22 | |||
| 8396 | 225575 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Carmelita St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002578.23632 | 2108754.51591 | 37.7703836584071 | -122.434436211974 | (37.7703836584071, -122.434436211974) | 15 | 5 | 5 | 29492 | 9 | |||
| 8567 | 225678 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008639.28815 | 2096915.28176 | 37.7382179799816 | -122.412633881069 | (37.7382179799816, -122.412633881069) | 10 | 7 | 7 | 28859 | 2 | |||
| 8594 | 225630 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100x Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007655.63255 | 2098163.38605 | 37.7415897424739 | -122.416123251495 | (37.7415897424739, -122.416123251495) | 2 | 7 | 7 | 28859 | 2 | |||
| 8602 | 228283 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
| 8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
| 8732 | 261131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 205 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002921 | 2092296 | 37.725211886246 | -122.432075099304 | (37.725211886246, -122.432075099304) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 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 | ||
| 8996 | 98282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.50432 | 37.7764907880679 | -122.415211370411 | (37.7764907880679, -122.415211370411) | 8 | 2 | 9 | 28853 | 34 | ||
| 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 | ||
| 9108 | 116642 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 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 | |||
| 9492 | 104107 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 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 | ||
| 10044 | 98961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 10049 | 261052 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Hooper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013012.2905 | 2108046.92839 | 37.769027533769 | -122.398294909078 | (37.769027533769, -122.398294909078) | 14 | 3 | 8 | 28856 | 20 | ||||
| 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 | ||
| 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 | |||
| 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 | |||
| 10523 | 262206 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000738 | 2088975 | 37.7159691653279 | -122.439383549479 | (37.7159691653279, -122.439383549479) | 9 | 7 | 6 | 28861 | 5 | ||||
| 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 | |||
| 10725 | 228284 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
| 10740 | 228285 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 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 | |||||||||||||
| 11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | ||||
| 11718 | 176523 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 852 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 4 | Width 2ft | Permit Number 48053 | 6000783.87975 | 2089020.62281 | 37.7160970462187 | -122.439228236006 | (37.7160970462187, -122.439228236006) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 11989 | 261017 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
| 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 | |||
| 12180 | 91455 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 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 | |||
| 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 | |||
| 12479 | 66411 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 217 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2009 12:00:00 AM | 3x3 | Permit Number 52018 | 6006829.83812508 | 2097883.34846014 | 37.7407743554357 | -122.418958717737 | (37.7407743554357, -122.418958717737) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | |||
| 13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
| 13165 | 152981 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
| 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 | |||
| 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 | |||
| 13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 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 | |||
| 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 | |||
| 14479 | 260995 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
| 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 | |||
| 14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
| 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 | |||
| 14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
| 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 | ||
| 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 | |||
| 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 |
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) );