3,247 rows where qSpecies_id = 22 sorted by PlantType

View and edit SQL

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)
6502 71315 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 555 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6003422.952 2090101.24578 37.7192140226932 -122.430183398047 (37.7192140226932, -122.430183398047) 9 7 6 28861 5
6545 254389 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 990 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2018 12:00:00 AM 3 3x3   6009377.71563 2118076.93343 37.7963644085284 -122.411575473026 (37.7963644085284, -122.411575473026) 3 1 10 308 4
6645 226161 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 126 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/1993 12:00:00 AM 9 Width 4ft Permit Number 32799 5997997.11826 2106529.02842 37.76401192934 -122.450121798605 (37.76401192934, -122.450121798605) 15 5 11 29492 9
6665 226202 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 599X Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6008574.51077 2096960.1089 37.7383374297197 -122.412861018343 (37.7383374297197, -122.412861018343) 10 7 7 28859 2
6679 152982 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006311.85744 2102620.48455 37.7537522736602 -122.421085978553 (37.7537522736602, -122.421085978553) 2 4 5 28859 19
6684 32355 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 455 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 2   Permit Number 36909 5988077.70341 2112909.74205 37.7809589730845 -122.484897834483 (37.7809589730845, -122.484897834483) 11 6 2 55 26
6702 84260 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 660 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988186.45102 2111472.04935 37.777017806636 -122.484416148832 (37.777017806636, -122.484416148832) 11 6 2 55 26
6769 125297 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 822 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010069.63851 2118171.76968 37.7966635933042 -122.409187958682 (37.7966635933042, -122.409187958682) 3 1 10 308 4
6849 45748 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM 3   Permit Number 44395 5997461.24318 2116299.42267 37.7908082054694 -122.452680420191 (37.7908082054694, -122.452680420191) 11 6 1 54 31
6920 32855 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 121 Hoffman Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/1996 12:00:00 AM     Permit Number 37205 6000624.61627289 2102511.57259046 37.7531309843157 -122.440745886867 (37.7531309843157, -122.440745886867) 2 4 5 28862 22
6969 26176 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 491 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/1998 12:00:00 AM 3 3X3   6002367.6851 2105408.33914 37.7611839212116 -122.434925166173 (37.7611839212116, -122.434925166173) 15 4 5 28862 3
6989 109119 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
7043 112197 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2570 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.7921756543416 -122.437399303646 (37.7921756543416, -122.437399303646) 13 6 1 29490 27
7064 129030 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 537 Sacramento St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6012231.96171 2117118.21401 37.793891683102 -122.401631701054 (37.793891683102, -122.401631701054) 4 1 10 28860 6
7100 228281 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 4 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
7127 260547 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 4 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
7354 228212 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 258 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 4x4   6001431.41596 2104296.0416 37.7580766187648 -122.438083635558 (37.7580766187648, -122.438083635558) 2 4 5 28862 3
7494 243413 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 77 Belgrave Ave 1 Sidewalk: Property side : Yard Tree Private 2   11/12/2019 12:00:00 AM 3 6x6 Permit Number 781419 5998151.68157 2104894.95588 37.7595340204918 -122.449469463666 (37.7595340204918, -122.449469463666) 15 5 11 28862 12
7524 111636 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2625 35TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2015 12:00:00 AM 3 3x3   5985486 2097347 37.7380767082098 -122.492717127165 (37.7380767082098, -122.492717127165) 1 8 3 29491 35
7575 221710 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 90 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1999 12:00:00 AM 4 Width 3ft Permit Number 41442 6005828.31885 2102883.52989 37.7544472652446 -122.422776859587 (37.7544472652446, -122.422776859587) 2 4 5 28859 19
7607 123761 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 201 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5994919.42218 2110746.11008 37.7754143312074 -122.461072248502 (37.7754143312074, -122.461072248502) 11 6 2 54 11
7616 71689 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2133 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5997637.9995 2109872.9453 37.7731729127242 -122.451605099071 (37.7731729127242, -122.451605099071) 15 5 11 29492 16
8005 128927 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2101 Washington St 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6004695.29857 2116719.42491 37.7923732722634 -122.427680861803 (37.7923732722634, -122.427680861803) 13 9 1 28858 27
8046 261018 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 79 Cragmont Ave 2 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
8103 108711 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2000-2038X 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773095 6011373.53842 2106528.51703 37.7647668994048 -122.40385642054 (37.7647668994048, -122.40385642054) 8 3 8 28853 20
8132 19305 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 345 07th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/1990 12:00:00 AM 20 3X3   6010549.63293 2110708.85281 37.7761990776491 -122.407000778664 (37.7761990776491, -122.407000778664) 14 2 9 28853 34
8137 84234 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 361-363 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52253 5988056.84631807 2113563.86004854 37.782753781159 -122.485017993529 (37.782753781159, -122.485017993529) 11 6 2 55 26
8230 105663 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 263 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x2   5990541.50647 2113621.53342 37.783056548593 -122.476426424914 (37.783056548593, -122.476426424914) 11 6 2 55 26
8238 195098 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 22nd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     9 Width 3ft   6015116.41348 2103939.58285 37.7578666360554 -122.390729746003 (37.7578666360554, -122.390729746003) 10 3 8 28856 29
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
8505 71601 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 138 Wilson St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5994653.0975 2086384.07363 37.7085069255288 -122.460228076664 (37.7085069255288, -122.460228076664) 9 8 6 28861 25
8515 76311 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 299X Cambridge St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 0   6006754.26056 2093151.90933 37.7277786091743 -122.418884550584 (37.7277786091743, -122.418884550584) 9 3 7 309 5
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
8656 64940 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2157 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/19/1989 12:00:00 AM 5   Permit Number 25969 5997552.9152 2109862.9805 37.7731406790273 -122.451898696297 (37.7731406790273, -122.451898696297) 15 5 11 29492 16
8659 71325 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 114 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6004555.30191 2090455.11867 37.7202497511935 -122.426294473226 (37.7202497511935, -122.426294473226) 9 7 6 28861 5
8668 39268 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 540 Delancey St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1998 12:00:00 AM 8 3x3 Permit Number 40880 6015240.80145 2113614.13929 37.7844377354544 -122.390975718675 (37.7844377354544, -122.390975718675) 6 2 9 28856 6
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
8720 67850 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 485 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1993 12:00:00 AM     Permit Number 31520 6002735.666769 2098756.82734478 37.7429413329054 -122.433177202226 (37.7429413329054, -122.433177202226) 2 7 5 63 22
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
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
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
9306 40717 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 360 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1999 12:00:00 AM     Permit Number 41696 6008594.61699406 2097088.56935412 37.7386912826447 -122.412800580048 (37.7386912826447, -122.412800580048) 10 7 7 28859 2
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
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
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
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
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
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
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                      
11217 36019 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 99 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39165 6006729.30953986 2099082.13183863 37.7440602847413 -122.419391331569 (37.7440602847413, -122.419391331569) 2 7 7 28859 2
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
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
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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);