trees
969 rows where qSpecies_id = 97 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
174424 | 224640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006790.58194 | 2099800.70275 | 37.7460367694939 | -122.41923042716 | (37.7460367694939, -122.41923042716) | 2 | 7 | 7 | 28859 | 2 | |||
174227 | 33820 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1025 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1984 12:00:00 AM | Permit Number 37834 | 6007679.68250964 | 2115084.43114941 | 37.7880523419006 | -122.417238879212 | (37.7880523419006, -122.417238879212) | 13 | 1 | 10 | 28858 | 21 | |||
173842 | 32046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
173711 | 173681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010317 | 2099454 | 37.7452827689443 | -122.407012047483 | (37.7452827689443, -122.407012047483) | 2 | 7 | 7 | 28859 | 2 | ||||
173490 | 224551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007716.60877 | 2104410.35168 | 37.7587459283935 | -122.416354782871 | (37.7587459283935, -122.416354782871) | 2 | 4 | 7 | 28859 | 19 | |||
173183 | 57946 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 10 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 9 | Permit Number 16905 | 5999382.31979 | 2086721.86457 | 37.7097053198058 | -122.443907611844 | (37.7097053198058, -122.443907611844) | 9 | 7 | 6 | 28861 | 5 | ||
172434 | 224506 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2404 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008170.5791 | 2104405.7281 | 37.7587587509332 | -122.414784412782 | (37.7587587509332, -122.414784412782) | 2 | 4 | 7 | 28859 | 19 | |||
172351 | 48492 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | 11 | 6 | 2 | 55 | 26 | ||
172270 | 63515 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3379 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 24124 | 6007714.38800344 | 2104402.20456648 | 37.758723433411 | -122.416361886265 | (37.758723433411, -122.416361886265) | 2 | 4 | 7 | 28859 | 19 | ||
171989 | 34145 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
171938 | 60290 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2915 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19854 | 6009379.15115854 | 2102740.05515277 | 37.7542530206621 | -122.41048698011 | (37.7542530206621, -122.41048698011) | 2 | 4 | 7 | 28859 | 19 | ||
171805 | 115033 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
171625 | 61732 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21737 | 6003971.9147598 | 2101029.52294751 | 37.7492516799815 | -122.429064604837 | (37.7492516799815, -122.429064604837) | 2 | 4 | 5 | 28862 | 22 | ||
171200 | 93707 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53296 | 6004115 | 2118383 | 37.7969081825869 | -122.429807420143 | (37.7969081825869, -122.429807420143) | 13 | 9 | 1 | 57 | 17 | |||
171147 | 224566 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007859.47136 | 2105581.02762 | 37.7619683674619 | -122.415943597538 | (37.7619683674619, -122.415943597538) | 2 | 4 | 7 | 28859 | 19 | |||
171142 | 61751 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1839 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21762 | 6005280.05550322 | 2107208.06692616 | 37.7662904752312 | -122.424980563467 | (37.7662904752312, -122.424980563467) | 8 | 4 | 5 | 28853 | 19 | ||
170945 | 58156 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 837 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 9 | Permit Number 17140 | 6001092.2872 | 2088918.12181 | 37.7158331464556 | -122.438154896944 | (37.7158331464556, -122.438154896944) | 9 | 7 | 6 | 28861 | 5 | ||
170940 | 98987 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
170827 | 48041 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
170717 | 107384 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
170465 | 64776 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 816 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 25768 | 6010808.79838009 | 2116967.92817235 | 37.7933995175775 | -122.406545412053 | (37.7933995175775, -122.406545412053) | 3 | 1 | 10 | 28857 | 4 | ||
170253 | 224641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.419323735419 | (37.7460721011655, -122.419323735419) | 2 | 7 | 7 | 28859 | 2 | |||
169776 | 218825 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 295 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.7160492409447 | -122.463613852416 | (37.7160492409447, -122.463613852416) | 9 | 8 | 6 | 64 | 24 | |||
169413 | 62604 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.7739446322992 | -122.497099617838 | (37.7739446322992, -122.497099617838) | 11 | 6 | 2 | 55 | 26 | ||
169407 | 224484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1514 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007262.01073 | 2107365.0441 | 37.7668332518872 | -122.418136469321 | (37.7668332518872, -122.418136469321) | 8 | 4 | 7 | 28853 | 19 | |||
169076 | 110116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 160x PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010076 | 2121146 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | 3 | 1 | 10 | 308 | 23 | ||||
168856 | 224553 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007749.4839 | 2104412.62357 | 37.7587540151064 | -122.416241246156 | (37.7587540151064, -122.416241246156) | 2 | 4 | 7 | 28859 | 19 | |||
168838 | 84930 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
168714 | 52860 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
168632 | 590 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3049 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008590.89573 | 2102118.12773 | 37.7525011260356 | -122.413168999261 | (37.7525011260356, -122.413168999261) | 2 | 4 | 7 | 28859 | 19 | |||
168369 | 35391 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1998 12:00:00 AM | Permit Number 38846 | 6003139.07897357 | 2115258.4763002 | 37.7882737292741 | -122.432960994436 | (37.7882737292741, -122.432960994436) | 13 | 9 | 1 | 29490 | 27 | |||
168168 | 224481 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 77 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005108.87913 | 2105720.69975 | 37.7621968483334 | -122.425466769576 | (37.7621968483334, -122.425466769576) | 8 | 4 | 5 | 28859 | 19 | |||
167803 | 41049 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.7512256245579 | -122.402335016202 | (37.7512256245579, -122.402335016202) | 10 | 3 | 8 | 28856 | 29 | ||
167771 | 226488 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2498 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008832.88031 | 2103985.45214 | 37.7576419593387 | -122.41246415471 | (37.7576419593387, -122.41246415471) | 2 | 4 | 7 | 28859 | 19 | |||
167189 | 97724 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
167109 | 61473 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1918 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1984 12:00:00 AM | 24 | Permit Number 21416 | 6004687.86766006 | 2107227.29036829 | 37.766309789845 | -122.427030199286 | (37.766309789845, -122.427030199286) | 8 | 4 | 5 | 28862 | 3 | |
166779 | 224571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008059.06529 | 2105594.02225 | 37.7620152671241 | -122.415254197918 | (37.7620152671241, -122.415254197918) | 2 | 4 | 7 | 28859 | 19 | |||
166304 | 224616 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999502.23945 | 2102489.21916 | 37.7530056250346 | -122.444625668335 | (37.7530056250346, -122.444625668335) | 2 | 5 | 5 | 63 | 38 | |||
166115 | 224644 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006402.40696 | 2098386.74463 | 37.7421324905292 | -122.420472339621 | (37.7421324905292, -122.420472339621) | 2 | 7 | 7 | 28859 | 2 | |||
166052 | 224691 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006345.67902 | 2101450.87841 | 37.7505427101753 | -122.420885982798 | (37.7505427101753, -122.420885982798) | 2 | 4 | 5 | 28859 | 19 | |||
165930 | 224528 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006752.85457 | 2102173.99446 | 37.7525511643191 | -122.419529232289 | (37.7525511643191, -122.419529232289) | 2 | 4 | 7 | 28859 | 19 | |||
165815 | 62533 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 128 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1988 12:00:00 AM | Permit Number 25140 | 6004317.58532782 | 2101049.36983513 | 37.749325736021 | -122.427870683655 | (37.749325736021, -122.427870683655) | 2 | 4 | 5 | 28862 | 22 | |||
165757 | 64580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3540 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1988 12:00:00 AM | Permit Number 25479 | 6006657.88465402 | 2104395.66614284 | 37.7586460128066 | -122.420015302359 | (37.7586460128066, -122.420015302359) | 2 | 4 | 7 | 28859 | 19 | ||
165400 | 33589 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
165378 | 61309 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2325 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21208 | 6011929.28683038 | 2101842.72936764 | 37.7519317939639 | -122.40160485559 | (37.7519317939639, -122.40160485559) | 10 | 3 | 8 | 28856 | 29 | ||
165235 | 224627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999834.58358 | 2107589.10397 | 37.7670276079639 | -122.443842736578 | (37.7670276079639, -122.443842736578) | 15 | 5 | 5 | 29492 | 9 | |||
165184 | 121141 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
165009 | 226476 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008336.71685 | 2105070.66673 | 37.7605938535513 | -122.414256875855 | (37.7605938535513, -122.414256875855) | 2 | 4 | 7 | 28859 | 19 | |||
164692 | 55317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1126 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 4 | Permit Number 11246 | 6011285.28669 | 2089520.65076 | 37.7180620109438 | -122.402965322811 | (37.7180620109438, -122.402965322811) | 10 | 7 | 8 | 309 | 39 | ||
164535 | 67096 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 431 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30501 | 6010004.32773544 | 2098578.96669132 | 37.7428626163512 | -122.408031523079 | (37.7428626163512, -122.408031523079) | 10 | 7 | 7 | 28859 | 2 | ||
164310 | 52858 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
164254 | 59572 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 893 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 24583 | 6003136.10237421 | 2103049.36160406 | 37.7547503322276 | -122.432099077639 | (37.7547503322276, -122.432099077639) | 2 | 4 | 5 | 28862 | 22 | ||
164240 | 96965 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3686 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | Permit Number 23795 | 6005734 | 2104335 | 37.758427342075 | -122.423206207432 | (37.758427342075, -122.423206207432) | 2 | 4 | 5 | 28859 | 19 | ||
163838 | 218836 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991107.22907 | 2098459.95547 | 37.7414596924238 | -122.473363085249 | (37.7414596924238, -122.473363085249) | 1 | 8 | 4 | 29491 | 40 | |||
163673 | 224522 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007847.20121 | 2105421.64723 | 37.7615300558868 | -122.415974748238 | (37.7615300558868, -122.415974748238) | 2 | 4 | 7 | 28859 | 19 | |||
163520 | 101520 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 15X Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769472 | 6010051.6 | 2121037.7 | 37.8045317217453 | -122.409452740826 | (37.8045317217453, -122.409452740826) | 3 | 1 | 10 | 308 | 23 | |||
162342 | 60432 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 447 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | 2 | 7 | 5 | 63 | 22 | ||
162216 | 126627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.395987070255 | (37.796538299751, -122.395987070255) | 3 | 1 | 10 | 28860 | 6 | |||
161744 | 226489 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2496 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008832.21298 | 2104006.96318 | 37.757700986321 | -122.41246798312 | (37.757700986321, -122.41246798312) | 2 | 4 | 7 | 28859 | 19 | |||
161649 | 62442 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3090 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22605 | 5999929.32075843 | 2105305.0040382 | 37.7607614409418 | -122.443350977814 | (37.7607614409418, -122.443350977814) | 15 | 5 | 5 | 28862 | 3 | ||
161624 | 218820 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | 9 | 8 | 6 | 64 | 24 | |||
161072 | 224639 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006112.4253 | 2098109.96948 | 37.7413561822494 | -122.421455355286 | (37.7413561822494, -122.421455355286) | 2 | 7 | 7 | 28859 | 2 | |||
160997 | 64287 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 359 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25092 | 6004210.28159871 | 2098359.34465346 | 37.7419334769159 | -122.428050070914 | (37.7419334769159, -122.428050070914) | 2 | 7 | 5 | 63 | 7 | ||
160598 | 34453 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1167 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 10 | Permit Number 38197 | 6007453.34661 | 2118811.22971 | 37.7982724714417 | -122.418286300874 | (37.7982724714417, -122.418286300874) | 5 | 1 | 10 | 28858 | 32 | |
160352 | 66469 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1991 12:00:00 AM | Permit Number 29620 | 6002231.09425836 | 2109952.33731326 | 37.7736528678468 | -122.435722686817 | (37.7736528678468, -122.435722686817) | 15 | 5 | 11 | 29492 | 10 | ||
159135 | 224542 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008789.37213 | 2103883.03365 | 37.7573582996747 | -122.412607384336 | (37.7573582996747, -122.412607384336) | 2 | 4 | 7 | 28859 | 19 | |||
159096 | 224524 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | 2 | 4 | 7 | 28859 | 19 | |||
158936 | 101289 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 830 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6001069.51096 | 2088976.20041 | 37.715991321918 | -122.438237780259 | (37.715991321918, -122.438237780259) | 9 | 7 | 6 | 28861 | 5 | ||||
158783 | 24602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 419 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007254.49022 | 2097303.30919 | 37.7392055992492 | -122.417449329724 | (37.7392055992492, -122.417449329724) | 2 | 7 | 7 | 28859 | 2 | |||
158586 | 100476 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009833.38685 | 2114620.58318 | 37.7868996565447 | -122.409754655664 | (37.7868996565447, -122.409754655664) | 5 | 10 | 10 | 28852 | 36 | ||
158506 | 226483 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3470 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006409.05576 | 2104966.19294 | 37.7601985241524 | -122.420916373596 | (37.7601985241524, -122.420916373596) | 2 | 4 | 7 | 28859 | 19 | |||
158296 | 250316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995936.88043 | 2115877.74696 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | 11 | 6 | 1 | 54 | 31 | |||
158181 | 612 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3114 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6008205.07322 | 2102132.16672 | 37.7525180063146 | -122.414504236196 | (37.7525180063146, -122.414504236196) | 2 | 4 | 7 | 28859 | 19 | |||
158180 | 224647 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 11 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006471.9777 | 2098350.49655 | 37.7420368818048 | -122.420229213316 | (37.7420368818048, -122.420229213316) | 2 | 7 | 7 | 28859 | 2 | |||
157515 | 226496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008684.6321 | 2107591.00428 | 37.767533656488 | -122.413231818694 | (37.767533656488, -122.413231818694) | 8 | 4 | 7 | 28853 | 19 | |||
156936 | 224648 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 26 Heyman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006463.11483 | 2098326.07704 | 37.7419693319081 | -122.420258125606 | (37.7419693319081, -122.420258125606) | 2 | 7 | 7 | 28859 | 2 | |||
156839 | 58154 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 807 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 10 | Permit Number 17138 | 6001157.22948 | 2089029.0056 | 37.7161413018433 | -122.43793836449 | (37.7161413018433, -122.43793836449) | 9 | 7 | 6 | 28861 | 5 | ||
156513 | 74274 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1999 12:00:00 AM | 15 | 3x3 | 6009331.26403705 | 2104492.17139473 | 37.759061252045 | -122.410776319185 | (37.759061252045, -122.410776319185) | 2 | 4 | 7 | 28859 | 19 | ||
156316 | 226487 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008546.79549 | 2105667.11477 | 37.7622433612724 | -122.413572492685 | (37.7622433612724, -122.413572492685) | 8 | 4 | 7 | 28859 | 19 | |||
156229 | 226472 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008660.80856 | 2105087.18769 | 37.7606574158171 | -122.413137154278 | (37.7606574158171, -122.413137154278) | 2 | 4 | 7 | 28859 | 19 | |||
155644 | 176424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009812.17284 | 2092615.83589 | 37.7264783747515 | -122.408275448966 | (37.7264783747515, -122.408275448966) | 10 | 3 | 7 | 309 | 28 | |||
155433 | 224516 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007854.68212 | 2105234.63682 | 37.7610169890562 | -122.415935631324 | (37.7610169890562, -122.415935631324) | 2 | 4 | 7 | 28859 | 19 | |||
155182 | 226474 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008423.54633 | 2105074.53683 | 37.7606093569454 | -122.413956844941 | (37.7606093569454, -122.413956844941) | 2 | 4 | 7 | 28859 | 19 | |||
155173 | 28743 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 750 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.99358 | 2098694.18206 | 37.742932633526 | -122.42319261615 | (37.742932633526, -122.42319261615) | 2 | 7 | 5 | 28859 | 22 | |||
155149 | 176415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 850 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001011.08243 | 2088875.9268 | 37.7157126696686 | -122.438432556321 | (37.7157126696686, -122.438432556321) | 9 | 7 | 6 | 28861 | 5 | |||
154840 | 63853 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24552 | 6002495.53817147 | 2111986.73822711 | 37.7792538422906 | -122.43495345894 | (37.7792538422906, -122.43495345894) | 15 | 5 | 11 | 29490 | 41 | ||
154697 | 113877 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
154534 | 224556 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3361 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007831.17362 | 2104415.66296 | 37.7587669536521 | -122.415958939967 | (37.7587669536521, -122.415958939967) | 2 | 4 | 7 | 28859 | 19 | |||
154487 | 56880 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 260 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22991 | 6003475.03058778 | 2109173.00048042 | 37.7715835792192 | -122.431364078952 | (37.7715835792192, -122.431364078952) | 15 | 9 | 11 | 29492 | 10 | ||
154134 | 13369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900 Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X50 | 6009189.31279 | 2090017.34286 | 37.7193085603337 | -122.410245275395 | (37.7193085603337, -122.410245275395) | 9 | 3 | 7 | 309 | 28 | |||
153957 | 5685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1506 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x5 | 6005209.87097 | 2099535.96992 | 37.7452207246578 | -122.424677493096 | (37.7452207246578, -122.424677493096) | 2 | 7 | 5 | 63 | 22 | |||
153563 | 224567 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.415816764337 | (37.7619780702545, -122.415816764337) | 2 | 4 | 7 | 28859 | 19 | |||
153527 | 65474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.7233540853263 | -122.459298943633 | (37.7233540853263, -122.459298943633) | 9 | 8 | 4 | 28861 | 24 | ||
153013 | 176419 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 638 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6002178.18938 | 2090229.77829 | 37.7194963630453 | -122.43449524976 | (37.7194963630453, -122.43449524976) | 9 | 7 | 6 | 28861 | 5 | |||
152804 | 60714 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 21 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 20367 | 6005264.975818 | 2105333.47768938 | 37.7611424464321 | -122.424899339668 | (37.7611424464321, -122.424899339668) | 2 | 4 | 5 | 28859 | 19 | ||
152514 | 224650 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007190.04837 | 2099393.66184 | 37.7449416155647 | -122.417820274 | (37.7449416155647, -122.417820274) | 2 | 7 | 7 | 28859 | 2 | |||
152493 | 61711 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 232 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1991 12:00:00 AM | Permit Number 29947 | 6005210.12151982 | 2108247.78406465 | 37.7691413389079 | -122.425296445755 | (37.7691413389079, -122.425296445755) | 8 | 4 | 5 | 28853 | 19 | ||
152169 | 65423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 801 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.407521909343 | (37.7921784739149, -122.407521909343) | 5 | 1 | 10 | 28857 | 21 | ||
152129 | 35055 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 570 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/1998 12:00:00 AM | Permit Number 38614 | 6008948.51314843 | 2105576.68374234 | 37.7620176073252 | -122.41217670641 | (37.7620176073252, -122.41217670641) | 8 | 4 | 7 | 28859 | 19 | ||
151439 | 108964 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 |
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) );