Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80660 | 80660 | 101190 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 300 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994863.0 | 2106716.0 | 37.764345459457004 | -122.460975263176 | (37.764345459457, -122.460975263176) | ||||
| 80758 | 80758 | 66245 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 717 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29344 | 5994860.14526787 | 2089894.90916917 | 37.7181587604438 | -122.459766630257 | (37.7181587604438, -122.459766630257) | ||
| 80810 | 80810 | 30404 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 80821 | 80821 | 97810 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 901 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 33299 | 6009614.0 | 2116053.0 | 37.7908204311206 | -122.410614878669 | (37.7908204311206, -122.410614878669) | |||
| 80901 | 80901 | 45558 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 631 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | Permit Number 44306 | 5993757.287623 | 2111198.20088201 | 37.7765887076598 | -122.465125156838 | (37.7765887076598, -122.465125156838) | |||
| 80921 | 80921 | 104904 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 417 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 80985 | 80985 | 41100 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 519 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41847 | 5998900.19465733 | 2108958.89301628 | 37.770735360026 | -122.447173222473 | (37.770735360026, -122.447173222473) | ||
| 81072 | 81072 | 47774 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1237 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2002 12:00:00 AM | Permit Number 45551 | 6003237.36960705 | 2111690.62273761 | 37.7784828753755 | -122.43236600382099 | (37.7784828753755, -122.432366003821) | |||
| 81169 | 81169 | 48996 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 179 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46859 | 5992717.47131078 | 2097513.94028533 | 37.7389552850694 | -122.467726685378 | (37.7389552850694, -122.467726685378) | ||
| 81193 | 81193 | 49801 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 3x3 | Permit Number 46595 | 6007674.4763735 | 2101992.27281083 | 37.75210406660779 | -122.416329227522 | (37.7521040666078, -122.416329227522) | |
| 81202 | 81202 | 106286 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1600X Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007107.0 | 2116756.0 | 37.7926098218975 | -122.419338891627 | (37.7926098218975, -122.419338891627) | |||||
| 81293 | 81293 | 97871 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 81435 | 81435 | 94362 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 507 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | 3x3 | Permit Number 53636 | 5992474.9 | 2111972.9 | 37.7786417900192 | -122.469617677573 | (37.7786417900192, -122.469617677573) | |||
| 81664 | 81664 | 39608 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 40X Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 4x4 | Permit Number 41011 | 5998720.01537421 | 2105405.17907901 | 37.7609674612338 | -122.447540618719 | (37.7609674612338, -122.447540618719) | |
| 81740 | 81740 | 47330 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 242 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45261 | 5994763.5780735 | 2090205.44685868 | 37.719005869189 | -122.46012290455299 | (37.719005869189, -122.460122904553) | ||
| 81913 | 81913 | 113293 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1626 PIERCE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002154.0 | 2114089.0 | 37.7850067228559 | -122.43628547108801 | (37.7850067228559, -122.436285471088) | ||||
| 81972 | 81972 | 98746 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 82130 | 82130 | 47772 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1700 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2002 12:00:00 AM | Permit Number 45550 | 6014858.18965719 | 2096344.09030254 | 37.7369966758652 | -122.391091912235 | (37.7369966758652, -122.391091912235) | |||
| 82370 | 82370 | 30390 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 82394 | 82394 | 42722 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42732 | 6013616.31802888 | 2093434.69648512 | 37.7289390851959 | -122.395181915037 | (37.7289390851959, -122.395181915037) | ||
| 82475 | 82475 | 35015 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 47 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/1997 12:00:00 AM | Permit Number 38587 | 6005404.86941948 | 2103441.39072556 | 37.755955120251606 | -122.424280933156 | (37.7559551202516, -122.424280933156) | ||
| 82508 | 82508 | 63970 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 427 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 6002374.96532989 | 2101475.67318166 | 37.750386176039 | -122.434618774806 | (37.750386176039, -122.434618774806) | |||
| 82549 | 82549 | 36115 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1226 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39212 | 5991452.81371882 | 2107068.83835934 | 37.7651174387305 | -122.472795757205 | (37.7651174387305, -122.472795757205) | ||
| 82590 | 82590 | 37410 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 301 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39889 | 6003208.12169915 | 2100936.51274949 | 37.7489530306424 | -122.431699173329 | (37.7489530306424, -122.431699173329) | ||
| 82859 | 82859 | 97868 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 82987 | 82987 | 36884 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2610 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39541 | 6001692.79590827 | 2116681.16611668 | 37.792097928333895 | -122.43806683477 | (37.7920979283339, -122.43806683477) | ||
| 83185 | 83185 | 113738 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 83474 | 83474 | 50841 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1871 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | Permit Number 47358 | 5998915.90678898 | 2110046.56932775 | 37.7737227395784 | -122.447197166031 | (37.7737227395784, -122.447197166031) | |||
| 83527 | 83527 | 46452 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2002 12:00:00 AM | Permit Number 44663 | 6003039.93601639 | 2111368.51212752 | 37.77758724287 | -122.433025981227 | (37.77758724287, -122.433025981227) | |||
| 83545 | 83545 | 107135 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 83658 | 83658 | 46674 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1458 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | Permit Number 44803 | 5991507.25834553 | 2105491.75937017 | 37.760790351138 | -122.472492463065 | (37.760790351138, -122.472492463065) | ||
| 83719 | 83719 | 97864 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 83794 | 83794 | 94649 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 363 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53787 | 6004189.0 | 2098364.0 | 37.7419450553656 | -122.42812398750799 | (37.7419450553656, -122.428123987508) | |
| 83876 | 83876 | 109990 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 84164 | 84164 | 61038 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 233 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50553 | 6003740.22262264 | 2109194.37057661 | 37.7716572821034 | -122.430448289878 | (37.7716572821034, -122.430448289878) | ||
| 84170 | 84170 | 46737 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 Sargent St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44847 | 5994017.67630199 | 2089152.6927278999 | 37.7160723272597 | -122.46262485198 | (37.7160723272597, -122.46262485198) | |||
| 84263 | 84263 | 108120 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 600X 14TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004785.9 | 2107807.3 | 37.7679078999373 | -122.42673243213999 | (37.7679078999373, -122.42673243214) | ||||
| 84267 | 84267 | 30392 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 84303 | 84303 | 84022 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4243 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50505 | 6002293.79060162 | 2101178.89811159 | 37.7495666934434 | -122.434878261178 | (37.7495666934434, -122.434878261178) | ||
| 84431 | 84431 | 87800 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 225 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50552 | 6003750.0 | 2109140.0 | 37.7715085476448 | -122.430410589394 | (37.7715085476448, -122.430410589394) | ||
| 84492 | 84492 | 97809 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 901 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 33299 | 6009614.0 | 2116053.0 | 37.7908204311206 | -122.410614878669 | (37.7908204311206, -122.410614878669) | ||||
| 84846 | 84846 | 107136 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) | |||
| 84866 | 84866 | 46828 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 503 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44904 | 6003640.3820222 | 2091980.16396675 | 37.7243854297654 | -122.429565753929 | (37.7243854297654, -122.429565753929) | ||
| 85005 | 85005 | 63964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 934 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 934-936 Diamond St | 6001894.63542373 | 2101371.30666035 | 37.7500723306894 | -122.436272318547 | (37.7500723306894, -122.436272318547) | ||
| 85042 | 85042 | 106874 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 85138 | 85138 | 103617 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 201X Haight St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004725.0 | 2109149.0 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | |||||
| 85302 | 85302 | 44788 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 280 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | Permit Number 43884 | 6010570.97154351 | 2107030.47360281 | 37.766100288713005 | -122.406667680538 | (37.766100288713, -122.406667680538) | |||
| 85516 | 85516 | 42721 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1790 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42732 | 6013616.31802888 | 2093434.69648512 | 37.7289390851959 | -122.395181915037 | (37.7289390851959, -122.395181915037) | ||
| 85525 | 85525 | 67044 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 668 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30423 | 6004263.67792589 | 2105003.52302827 | 37.760179861222795 | -122.428338882622 | (37.7601798612228, -122.428338882622) | ||
| 85574 | 85574 | 37330 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39840 | 6003021.44463533 | 2104165.68333023 | 37.7578089842605 | -122.432575328482 | (37.7578089842605, -122.432575328482) | ||
| 85667 | 85667 | 120620 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010405.0 | 2122056.0 | 37.8073475155142 | -122.40830162894899 | (37.8073475155142, -122.408301628949) | ||||
| 85677 | 85677 | 52249 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1660 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2006 12:00:00 AM | 3x3 | Permit Number 48417 | 6005553.43635592 | 2115190.35771863 | 37.7882233398649 | -122.42460286204599 | (37.7882233398649, -122.424602862046) | ||
| 85678 | 85678 | 115250 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1404x Mason St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 6009352.6 | 2118074.7 | 37.796356867240206 | -122.41166222086001 | (37.7963568672402, -122.41166222086) | ||||
| 85740 | 85740 | 57268 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 75 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | Permit Number 767724 | 5999760.39037505 | 2106440.5672957 | 37.7638697809416 | -122.44401682498699 | (37.7638697809416, -122.444016824987) | |||
| 85819 | 85819 | 101180 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 432 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994386.3 | 2106769.0 | 37.7644635416108 | -122.462627867612 | (37.7644635416108, -122.462627867612) | ||||
| 85861 | 85861 | 113048 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 616 DIVISADERO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001677.0 | 2110571.0 | 37.7753200717846 | -122.43768369628799 | (37.7753200717846, -122.437683696288) | ||||
| 85938 | 85938 | 112896 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1x WEBSTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
| 85983 | 85983 | 99833 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1610 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3x | 6007914.0 | 2117933.0 | 37.7958869904292 | -122.416630050903 | (37.7958869904292, -122.416630050903) | ||||
| 86074 | 86074 | 58291 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 347 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/1978 12:00:00 AM | Permit Number 17305 | 6002958.31085663 | 2106224.19787329 | 37.76345758918821 | -122.432940734515 | (37.7634575891882, -122.432940734515) | |||
| 86298 | 86298 | 105862 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
| 86330 | 86330 | 95114 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 887 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54041 | 6001057.0 | 2091844.3 | 37.7238657652599 | -122.43848639746099 | (37.7238657652599, -122.438486397461) | |
| 86362 | 86362 | 30382 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 86420 | 86420 | 113721 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1526 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2015 12:00:00 AM | 3x3 | 5989360.0 | 2104938.6 | 37.7591470062831 | -122.479878309336 | (37.7591470062831, -122.479878309336) | |||
| 86489 | 86489 | 49439 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2900 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2003 12:00:00 AM | Permit Number 46377 | 6008885.40306298 | 2103350.58196767 | 37.755901697023894 | -122.41223763868099 | (37.7559016970239, -122.412237638681) | |||
| 86539 | 86539 | 92216 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3001 Pacific Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2009 12:00:00 AM | 3x3 | Permit Number 52643 | 5999733.7 | 2116663.4 | 37.791937538515604 | -122.444844029888 | (37.7919375385156, -122.444844029888) | ||
| 86545 | 86545 | 58347 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 428 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/1978 12:00:00 AM | Permit Number 17372 | 6002359.77155099 | 2101526.90872343 | 37.750525994140204 | -122.434674979158 | (37.7505259941402, -122.434674979158) | |||
| 86620 | 86620 | 49731 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | |||
| 86663 | 86663 | 88313 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 638 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51304 | 6003091.0 | 2089648.0 | 37.7179507025626 | -122.43129849323799 | (37.7179507025626, -122.431298493238) | |||
| 86904 | 86904 | 30388 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2800 Turk St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1956 12:00:00 AM | Permit Number 66 | 5997681.665837 | 2111673.48633421 | 37.778119232070395 | -122.451583952943 | (37.7781192320704, -122.451583952943) | |||
| 86948 | 86948 | 106872 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | |||
| 87003 | 87003 | 113514 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 352 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008306.0 | 2113136.0 | 37.78273763754461 | -122.41493396572399 | (37.7827376375446, -122.414933965724) | ||||
| 87058 | 87058 | 31964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1261 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35366 | 6000773.52102031 | 2112972.2415243997 | 37.781861858147295 | -122.440981332997 | (37.7818618581473, -122.440981332997) | |||
| 87200 | 87200 | 113739 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 87334 | 87334 | 98017 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561@21st Ave Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 87406 | 87406 | 91356 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2121 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2009 12:00:00 AM | 3x3 | Permit Number 52063 | 6007640.0 | 2119628.0 | 37.8005256228645 | -122.41769834526 | (37.8005256228645, -122.41769834526) | ||
| 87483 | 87483 | 31423 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4052 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35006 | 6001951.47636685 | 2103555.31466959 | 37.7560723237915 | -122.436232037881 | (37.7560723237915, -122.436232037881) | ||
| 87831 | 87831 | 31459 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 625 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2006 12:00:00 AM | Permit Number 48868 | 6001235.09098461 | 2102755.90419216 | 37.753836607103 | -122.43865225476401 | (37.753836607103, -122.438652254764) | ||
| 87884 | 87884 | 47775 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1237 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2002 12:00:00 AM | Permit Number 45551 | 6003237.36960705 | 2111690.62273761 | 37.7784828753755 | -122.43236600382099 | (37.7784828753755, -122.432366003821) | |||
| 87988 | 87988 | 104440 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 200X Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770343 | 6004765.42963 | 2102220.02594 | 37.752565410803705 | -122.42640536894599 | (37.7525654108037, -122.426405368946) | |||
| 88046 | 88046 | 82167 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 246 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50430 | 6004002.57632876 | 2104541.49208349 | 37.7588964563216 | -122.42920896377399 | (37.7588964563216, -122.429208963774) | ||
| 88110 | 88110 | 101201 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994231.2 | 2106687.3 | 37.7642302811549 | -122.463158383346 | (37.7642302811549, -122.463158383346) | |||||
| 88171 | 88171 | 98019 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1561 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988339.7 | 2098919.1 | 37.7425597372021 | -122.48296577400801 | (37.7425597372021, -122.482965774008) | ||||
| 88324 | 88324 | 112897 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1x WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
| 88329 | 88329 | 122853 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 571 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013397.0 | 2114664.0 | 37.7872179274416 | -122.397428333184 | (37.7872179274416, -122.397428333184) | ||||
| 88442 | 88442 | 95723 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 845 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767472 | 6004159.7 | 2090885.0 | 37.7214077415573 | -122.42769255078899 | (37.7214077415573, -122.427692550789) | |
| 88525 | 88525 | 103459 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1028 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2013 12:00:00 AM | 3x3 | Permit Number 770176 | 6009851.0 | 2116823.0 | 37.7929479491773 | -122.40984924338699 | (37.7929479491773, -122.409849243387) | ||
| 88641 | 88641 | 101178 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 400 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994553.0 | 2106706.0 | 37.7643001590155 | -122.462046733301 | (37.7643001590155, -122.462046733301) | ||||
| 88706 | 88706 | 49725 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1300@ REVERE Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | Permit Number 46533 | 6017891.63282432 | 2092647.03396297 | 37.727013150708 | -122.380346965446 | (37.727013150708, -122.380346965446) | ||
| 88796 | 88796 | 60985 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2091 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 20797 | 6006849.0 | 2106188.0 | 37.763578110001795 | -122.419481494164 | (37.7635781100018, -122.419481494164) | ||
| 88857 | 88857 | 122789 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1655 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007172.0 | 2109097.0 | 37.771583727056104 | -122.418570631079 | (37.7715837270561, -122.418570631079) | ||||
| 88967 | 88967 | 43939 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 227 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43526 | 5994275.63478435 | 2114006.81221927 | 37.784330275303205 | -122.463535935804 | (37.7843302753032, -122.463535935804) | ||||
| 89066 | 89066 | 92127 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 279 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992512.0 | 2097215.0 | 37.738122604210204 | -122.46841536099 | (37.7381226042102, -122.46841536099) | |||||
| 89103 | 89103 | 116005 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 945 FRONT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012663.0 | 2119386.0 | 37.8001425245044 | -122.40029961366501 | (37.8001425245044, -122.400299613665) | ||||
| 89234 | 89234 | 52989 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 362REVISED Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48972 | 6003271.074545099 | 2104500.95688485 | 37.7587437185151 | -122.43173594249 | (37.7587437185151, -122.43173594249) | ||||
| 89365 | 89365 | 51224 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 117 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53577 | 5999341.2801238 | 2107680.17758119 | 37.767249522917794 | -122.445555540213 | (37.7672495229178, -122.445555540213) | ||
| 89386 | 89386 | 65490 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1105 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | Permit Number 28374 | 6008199.50951886 | 2115504.50751693 | 37.7892350004146 | -122.415470115629 | (37.7892350004146, -122.415470115629) | ||
| 89504 | 89504 | 58857 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 304 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/1979 12:00:00 AM | 3x3 | Permit Number 767678 | 6007714.93476251 | 2097698.0267641996 | 37.7403153030515 | -122.415885258489 | (37.7403153030515, -122.415885258489) | ||
| 89611 | 89611 | 108923 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1335 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 5999481.5 | 2108169.7 | 37.768601632456495 | -122.445105738432 | (37.7686016324565, -122.445105738432) | ||||
| 89691 | 89691 | 109988 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501X Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 89806 | 89806 | 113734 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");