trees
3,247 rows where qSpecies_id = 22 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );