Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4727 | 4727 | 253673 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 600 x Sanchez St | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 6003598.0 | 2104743.0 | 37.75942683738779 | -122.43062255590701 | (37.7594268373878, -122.430622555907) | ||||
| 4544 | 4544 | 253638 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 859 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2017 12:00:00 AM | 3 | 3x3 | 6009440.103999999 | 2118743.01656 | 37.7981968084542 | -122.411406675592 | (37.7981968084542, -122.411406675592) | ||
| 3746 | 3746 | 253553 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | ||||
| 3179 | 3179 | 253343 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 200 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | Permit Number 778434 | 5995550.1802199995 | 2114806.2223 | 37.786598594028504 | -122.459184390305 | (37.7865985940285, -122.459184390305) | |||
| 3189 | 3189 | 253342 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | Permit Number 778434 | 5995550.1802199995 | 2114806.2223 | 37.786598594028504 | -122.459184390305 | (37.7865985940285, -122.459184390305) | |||
| 3149 | 3149 | 253338 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 324 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 5996595.0 | 2107026.0 | 37.7652961513923 | -122.455007196131 | (37.7652961513923, -122.455007196131) | ||||
| 3907 | 3907 | 253159 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 500 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2017 02:21:00 PM | 3 | 3x3 | 6004815.0 | 2092724.0 | 37.7264942782417 | -122.425558174045 | (37.7264942782417, -122.425558174045) | ||
| 2650 | 2650 | 253148 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 375 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | 3x3 | Permit Number 43092 | 6003622.0 | 2091383.0 | 37.722744709081205 | -122.42958672889 | (37.7227447090812, -122.42958672889) | |||
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 2575 | 2575 | 253126 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 182 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779117 | 6002742.73008 | 2092646.2038099999 | 37.726163358663705 | -122.432716365158 | (37.7261633586637, -122.432716365158) | ||
| 4453 | 4453 | 253083 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:53:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4493 | 4493 | 253082 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2849X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:25:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 2133 | 2133 | 252909 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 3201x 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417.0 | 2106083.0 | 37.763321780718705 | -122.417509514421 | (37.7633217807187, -122.417509514421) | |
| 2147 | 2147 | 252908 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2142 | 2142 | 252906 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 2143 | 2143 | 252905 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | |
| 4400 | 4400 | 251729 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 35 Bruce Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/11/2017 10:39:00 AM | 3 | Width 3ft | 5997172.50242 | 2091270.81822 | 37.7220693917577 | -122.45187305021099 | (37.7220693917577, -122.451873050211) | ||
| 4004 | 4004 | 251722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 18 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 03:08:00 PM | 3 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | |||
| 1672 | 1672 | 251649 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2649 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007031.0 | 2102934.0 | 37.7546536287073 | -122.41862124555 | (37.7546536287073, -122.41862124555) | ||||
| 1667 | 1667 | 251648 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2649 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007031.0 | 2102934.0 | 37.7546536287073 | -122.41862124555 | (37.7546536287073, -122.41862124555) | ||||
| 1704 | 1704 | 251429 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1345 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779991 | 6003307.0 | 2100429.0 | 37.7475651236724 | -122.43132102920099 | (37.7475651236724, -122.431321029201) | |
| 655 | 655 | 251353 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | ||||
| 22859 | 22859 | 251138 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 304 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003283.0 | 2109317.0 | 37.7719680815982 | -122.43203860792299 | (37.7719680815982, -122.432038607923) | ||||
| 22836 | 22836 | 251133 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | ||||
| 1968 | 1968 | 251132 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 02/11/2006 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 1986 | 1986 | 251131 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 354 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/14/2014 12:00:00 AM | 3x3 | Permit Number 779305 | 6011875.0 | 2111882.0 | 37.779494345884295 | -122.402498458881 | (37.7794943458843, -122.402498458881) | |
| 157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
| 40342 | 40342 | 251093 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987925.4225 | 2112589.2174 | 37.780070032325 | -122.485401115216 | (37.780070032325, -122.485401115216) | |||
| 177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
| 151880 | 151880 | 251078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991099.7276 | 2112702.723 | 37.7805661077577 | -122.474428154783 | (37.7805661077577, -122.474428154783) | |||
| 175283 | 175283 | 251074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | |||
| 172638 | 172638 | 251071 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990727.8797 | 2112689.8051 | 37.7805090880033 | -122.47571359647101 | (37.7805090880033, -122.475713596471) | |||
| 173206 | 173206 | 251070 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990754.7634 | 2112689.2674 | 37.7805091701663 | -122.47562055473499 | (37.7805091701663, -122.475620554735) | |||
| 34570 | 34570 | 251048 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5700x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989255.4598 | 2112633.0799 | 37.7802678632993 | -122.480803179963 | (37.7802678632993, -122.480803179963) | |||
| 176711 | 176711 | 251042 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5500x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989852.8157 | 2112655.9311 | 37.7803653089721 | -122.47873834484899 | (37.7803653089721, -122.478738344849) | |||
| 74413 | 74413 | 251035 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5317x Geary Blvd | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990415.7605 | 2112675.5562 | 37.7804518645045 | -122.47679231146002 | (37.7804518645045, -122.47679231146) | |||
| 47168 | 47168 | 251029 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991370.3842 | 2112709.3567 | 37.7805999993895 | -122.473492318223 | (37.7805999993895, -122.473492318223) | |||
| 152127 | 152127 | 251023 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991490.4549 | 2112712.2313 | 37.780614844759995 | -122.473077150172 | (37.78061484476, -122.473077150172) | |||
| 69767 | 69767 | 251022 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5991511.6828 | 2112712.2313 | 37.7806160737768 | -122.473003713445 | (37.7806160737768, -122.473003713445) | |||
| 48589 | 48589 | 250912 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 295 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986804.90066 | 2113997.38532 | 37.78387111489079 | -122.48938102442301 | (37.7838711148908, -122.489381024423) | |||
| 70796 | 70796 | 250911 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 289 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986802.05545 | 2114026.5929900003 | 37.7839511446853 | -122.48939301598699 | (37.7839511446853, -122.489393015987) | |||
| 54453 | 54453 | 250910 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 282 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986846.58406 | 2114055.94379 | 37.78403433287 | -122.489241124102 | (37.78403433287, -122.489241124102) | |||
| 177741 | 177741 | 250909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 283 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986801.87237 | 2114054.20987 | 37.7840269620296 | -122.48939568068998 | (37.7840269620296, -122.48939568069) | |||
| 63222 | 63222 | 250904 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 270 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986844.372690001 | 2114133.07691 | 37.784245989215 | -122.489254447562 | (37.784245989215, -122.489254447562) | |||
| 48007 | 48007 | 250903 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 269 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986799.05425 | 2114139.02615 | 37.7842596786901 | -122.48941166883199 | (37.7842596786901, -122.489411668832) | |||
| 70061 | 70061 | 250900 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 258 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986841.97365 | 2114201.3931299997 | 37.7844334259182 | -122.489267771885 | (37.7844334259182, -122.489267771885) | |||
| 134836 | 134836 | 250899 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 261 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986798.04224 | 2114182.00117 | 37.7843776166842 | -122.48941833100099 | (37.7843776166842, -122.489418331001) | |||
| 135779 | 135779 | 250898 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 254 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986841.38943 | 2114228.2514400003 | 37.7845071370277 | -122.48927176847401 | (37.7845071370277, -122.489271768474) | |||
| 77119 | 77119 | 250896 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 253 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986796.03039 | 2114232.28383 | 37.784515560989206 | -122.48942898976601 | (37.7845155609892, -122.489428989766) | |||
| 189062 | 189062 | 250894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 250 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986839.6011 | 2114252.83409 | 37.784574529539796 | -122.489279763454 | (37.7845745295398, -122.489279763454) | |||
| 50640 | 50640 | 250891 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 245 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986795.664 | 2114287.51727 | 37.78466719476761 | -122.48943432006399 | (37.7846671947676, -122.489434320064) | |||
| 71952 | 71952 | 250861 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 219 30th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986480.5422 | 2114338.79152 | 37.784789578116495 | -122.490528294956 | (37.7847895781165, -122.490528294956) | |||
| 165502 | 165502 | 250860 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 219 30th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986477.783559999 | 2114358.77919 | 37.7848442973726 | -122.49053930984199 | (37.7848442973726, -122.490539309842) | |||
| 47144 | 47144 | 250859 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 219 30th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986477.240130001 | 2114376.0021599997 | 37.7848915549471 | -122.490542457465 | (37.7848915549471, -122.490542457465) | |||
| 138248 | 138248 | 250858 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 219 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986477.98376 | 2114389.57454 | 37.7849288642293 | -122.490540883666 | (37.7849288642293, -122.490540883666) | |||
| 44787 | 44787 | 250857 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 219 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986476.07648 | 2114406.82652 | 37.784976121793896 | -122.490548751849 | (37.7849761217939, -122.490548751849) | |||
| 55975 | 55975 | 250856 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 219 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986476.36541 | 2114420.4082400003 | 37.7850134301615 | -122.49054875183501 | (37.7850134301615, -122.490548751835) | |||
| 184971 | 184971 | 250754 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2901 Lake St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5986452.66826 | 2114440.57637 | 37.7850674218586 | -122.490632219704 | (37.7850674218586, -122.490632219704) | |||
| 75678 | 75678 | 250753 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2901 Lake St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5986440.50803 | 2114442.51108 | 37.7850720236993 | -122.490674432088 | (37.7850720236993, -122.490674432088) | |||
| 178080 | 178080 | 250752 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2901 Lake St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5986424.93008 | 2114442.0046599996 | 37.785069723239104 | -122.490728288873 | (37.7850697232391, -122.490728288873) | |||
| 32237 | 32237 | 250565 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987286.538 | 2112566.9152 | 37.7799715553521 | -122.48760963785601 | (37.7799715553521, -122.487609637856) | |||
| 66695 | 66695 | 250492 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 334 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987535.4917 | 2115340.76951 | 37.7876022851576 | -122.486952172315 | (37.7876022851576, -122.486952172315) | |||
| 177412 | 177412 | 250491 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 334 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987543.5108900005 | 2115340.02768 | 37.7876007158561 | -122.48692437335698 | (37.7876007158561, -122.486924373357) | |||
| 43156 | 43156 | 250090 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1668 Bush St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005420.5972 | 2115171.3490400002 | 37.788163643775896 | -122.42506111059099 | (37.7881636437759, -122.425061110591) | |||
| 62339 | 62339 | 250089 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1660 Bush St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6005589.26464 | 2115194.4909 | 37.7882367118918 | -122.424479196185 | (37.7882367118918, -122.424479196185) | |||
| 131652 | 131652 | 250088 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1610 Bush St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6005767.223069999 | 2115217.64782 | 37.7883103429988 | -122.423865136366 | (37.7883103429988, -122.423865136366) | |||
| 66147 | 66147 | 250085 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1600 Bush St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6005789.05655 | 2115220.3533900003 | 37.788319004372 | -122.42378978847 | (37.788319004372, -122.42378978847) | |||
| 52398 | 52398 | 250084 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1699 Bush St | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6005447.35392 | 2115124.6653400003 | 37.7880369733859 | -122.42496521407301 | (37.7880369733859, -122.424965214073) | |||
| 155658 | 155658 | 250083 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1699 Bush St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6005422.35006 | 2115121.82809 | 37.7880277706121 | -122.425051521136 | (37.7880277706121, -122.425051521136) | |||
| 169382 | 169382 | 250082 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 351 Austin St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005546.992319999 | 2115322.69213 | 37.7885863332435 | -122.424634574753 | (37.7885863332435, -122.424634574753) | |||
| 64972 | 64972 | 250081 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 351 Austin St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005532.94249 | 2115320.2252599997 | 37.788578766345296 | -122.424683009533 | (37.7885787663453, -122.424683009533) | |||
| 373 | 373 | 250075 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 415 | 415 | 250074 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 347 | 347 | 250073 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 377 | 377 | 250072 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1599X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6006083.0 | 2115238.0 | 37.7883840466687 | -122.422774045373 | (37.7883840466687, -122.422774045373) | |
| 183901 | 183901 | 249915 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 356 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011213.4228 | 2120410.2337700003 | 37.8028738823843 | -122.405387909344 | (37.8028738823843, -122.405387909344) | |||
| 163462 | 163462 | 249912 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 356 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011242.80215 | 2120418.17004 | 37.8028973160279 | -122.405286800351 | (37.8028973160279, -122.405286800351) | |||
| 137333 | 137333 | 249909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 308 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 0ft | 6011272.62588 | 2120428.81285 | 37.8029282059239 | -122.40518434420099 | (37.8029282059239, -122.405184344201) | |||
| 63666 | 63666 | 249900 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 300 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 6011328.50093 | 2120408.94667 | 37.802876781803896 | -122.40498958701099 | (37.8028767818039, -122.404989587011) | |||
| 171235 | 171235 | 249889 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 25 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6011472.47528 | 2120454.19881 | 37.8030090801563 | -122.404494546207 | (37.8030090801563, -122.404494546207) | |||
| 26255 | 26255 | 249868 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6011723.02594 | 2120467.18676 | 37.803058740725 | -122.403628419935 | (37.803058740725, -122.403628419935) | |||
| 73388 | 73388 | 249854 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 285 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 43 | Width 0ft | 6011456.47585 | 2120387.94643 | 37.8028262731804 | -122.40454524638099 | (37.8028262731804, -122.404545246381) | |||
| 57451 | 57451 | 249779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6010421.07006 | 2121139.1053400002 | 37.804830850333204 | -122.408181306135 | (37.8048308503332, -122.408181306135) | |||
| 36138 | 36138 | 249778 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6010409.80858 | 2121137.7854400002 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | |||
| 179054 | 179054 | 249777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010400.427069999 | 2121136.58311 | 37.8048227690275 | -122.40825256571001 | (37.8048227690275, -122.40825256571) | |||
| 53370 | 53370 | 249773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.80487103114871 | -122.40814255972602 | (37.8048710311487, -122.408142559726) | |||
| 64938 | 64938 | 249772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.40812137351801 | (37.8049001107042, -122.408121373518) | |||
| 43890 | 43890 | 249771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | |||
| 179329 | 179329 | 249731 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Broderick St | 15 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6000168.8987300005 | 2117282.9089599997 | 37.793663374005604 | -122.443382762997 | (37.7936633740056, -122.443382762997) | |||
| 186379 | 186379 | 249717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Broderick St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 7ft | 6000147.51069 | 2117427.0095900004 | 37.794057816679995 | -122.44346712302601 | (37.79405781668, -122.443467123026) | |||
| 170191 | 170191 | 249696 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999680.27614 | 2117316.2653799998 | 37.7937270855963 | -122.44507583208599 | (37.7937270855963, -122.445075832086) | ||||
| 188577 | 188577 | 249695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999678.04202 | 2117322.75965 | 37.7937447896309 | -122.445084029412 | (37.7937447896309, -122.445084029412) | ||||
| 169373 | 169373 | 249693 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5999669.5395599995 | 2117354.78581 | 37.7938322397096 | -122.445115752098 | (37.7938322397096, -122.445115752098) | ||||
| 183690 | 183690 | 249685 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999728.9564 | 2117260.57889 | 37.793576963545796 | -122.444903389791 | (37.7935769635458, -122.444903389791) | ||||
| 116489 | 116489 | 249681 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 5999730.06735 | 2117240.34957 | 37.7935214825788 | -122.444898090975 | (37.7935214825788, -122.444898090975) | ||||
| 58461 | 58461 | 249564 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1251 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6005929.24831 | 2114394.73993 | 37.786059987429105 | -122.42324603589898 | (37.7860599874291, -122.423246035899) | |||
| 174652 | 174652 | 249404 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 201 Hyde St | 2 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6008044.54094 | 2113134.78651 | 37.7827196103579 | -122.415838420016 | (37.7827196103579, -122.415838420016) | |||
| 172290 | 172290 | 249403 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 201 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6008040.77723 | 2113154.96679 | 37.7827748089509 | -122.415852870339 | (37.7827748089509, -122.415852870339) | |||
| 58245 | 58245 | 249398 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 350 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008259.14419 | 2113134.3228700003 | 37.7827303995415 | -122.41509594873001 | (37.7827303995415, -122.41509594873) | |||
| 186530 | 186530 | 249397 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 350 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008279.412330001 | 2113135.60794 | 37.7827350670063 | -122.415025920327 | (37.7827350670063, -122.415025920327) |
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");