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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54 | 54 | 121137 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 60 | 60 | 121139 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 70 | 70 | 121138 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 1388x Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 1887 | 1887 | 20008 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
| 2790 | 2790 | 20006 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 5366 | 5366 | 19799 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY21 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 6932 | 6932 | 36849 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7300 | 7300 | 36853 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7669 | 7669 | 19837 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY25 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 7845 | 7845 | 36850 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 8166 | 8166 | 20381 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 262X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 10591 | 10591 | 36848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 10643 | 10643 | 20031 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY51 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
| 12819 | 12819 | 20005 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 13103 | 13103 | 20037 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY51 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | ST | ||||||||
| 13401 | 13401 | 87812 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 4850 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50626 | |||||||
| 13714 | 13714 | 36844 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14029 | 14029 | 20030 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY51 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
| 14114 | 14114 | 20007 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY46 | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 14679 | 14679 | 36852 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14747 | 14747 | 36851 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15278 | 15278 | 20067 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY54 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 15753 | 15753 | 19798 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY21 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 16463 | 16463 | 20033 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 100 STAIRWAY51 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | ST | ||||||||
| 16842 | 16842 | 36847 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 159243 | 159243 | 37076 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1267 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 6 | Permit Number 39678 | 5982408.3748 | 2106484.4364 | 37.7629851116454 | -122.504034448261 | (37.7629851116454, -122.504034448261) | |
| 74325 | 74325 | 40195 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 547 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 6 | Permit Number 41379 | 5983457.691219999 | 2112080.91654 | 37.7784130880263 | -122.50081916943701 | (37.7784130880263, -122.500819169437) | |
| 51280 | 51280 | 117779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 7550 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 5983517.54679 | 2112515.2039799998 | 37.779609028810896 | -122.500644231512 | (37.7796090288109, -122.500644231512) | |||
| 26740 | 26740 | 47428 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 822 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45339 | 5983574.08653 | 2110178.2628599997 | 37.773195785140295 | -122.500275818952 | (37.7731957851403, -122.500275818952) | |
| 178670 | 178670 | 62469 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3425 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1986 12:00:00 AM | 10 | Permit Number 22639 | 5983887.9414 | 2105603.0938 | 37.7606520894678 | -122.498852099706 | (37.7606520894678, -122.498852099706) | ||
| 172848 | 172848 | 117768 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 423 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5984050.00239 | 2112962.0320599996 | 37.780867132804104 | -122.498835286864 | (37.7808671328041, -122.498835286864) | |||
| 67595 | 67595 | 184318 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1557 39th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5984035.0211 | 2104355.9181 | 37.757236320202296 | -122.49825131167101 | (37.7572363202023, -122.498251311671) | |||
| 47098 | 47098 | 63196 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 478 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 12 | Permit Number 23737 | 5984416.50201 | 2112603.40597 | 37.7799039391325 | -122.497540919644 | (37.7799039391325, -122.497540919644) | |
| 169922 | 169922 | 118065 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 414 36th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5984711.3164099995 | 2113070.71562 | 37.7812043122816 | -122.496555535147 | (37.7812043122816, -122.496555535147) | |||
| 48798 | 48798 | 52674 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 470 REVISED 36th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | 12 | Permit Number 48754 | 5984724.91084 | 2112700.37427 | 37.7801882586294 | -122.496481169909 | (37.7801882586294, -122.496481169909) | ||
| 184448 | 184448 | 63199 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 470 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 12 | Permit Number 23740 | 5984724.91084 | 2112700.37427 | 37.7801882586294 | -122.496481169909 | (37.7801882586294, -122.496481169909) | |
| 175886 | 175886 | 118058 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 478 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5984725.63179 | 2112655.31186 | 37.780064572525504 | -122.496475349721 | (37.7800645725255, -122.496475349721) | |||
| 40874 | 40874 | 118059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 478 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5984726.55462 | 2112637.2362 | 37.780014996055 | -122.496470823095 | (37.780014996055, -122.496470823095) | |||
| 38711 | 38711 | 181507 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1400 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984877.2478 | 2105497.3399 | 37.7604196957107 | -122.495422787092 | (37.7604196957107, -122.495422787092) | |||
| 55731 | 55731 | 181392 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984896.9779 | 2104568.1208 | 37.7578694740705 | -122.49528602274201 | (37.7578694740705, -122.495286022742) | |||
| 178798 | 178798 | 181394 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984907.5602 | 2104576.4752 | 37.7578930325113 | -122.495250041349 | (37.7578930325113, -122.495250041349) | |||
| 49760 | 49760 | 185704 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2101 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984910.4508 | 2100497.5253 | 37.7466935274926 | -122.49493929257099 | (37.7466935274926, -122.494939292571) | |||
| 158406 | 158406 | 187165 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2301 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5984939.6487 | 2099318.7286 | 37.7434585810539 | -122.49475143609199 | (37.7434585810539, -122.494751436092) | |||
| 49558 | 49558 | 187230 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984931.9096 | 2098648.6859 | 37.741618371959 | -122.49472880629999 | (37.741618371959, -122.4947288063) | |||
| 183031 | 183031 | 187229 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984934.768999999 | 2098656.8556 | 37.7416409711188 | -122.494719521782 | (37.7416409711188, -122.494719521782) | |||
| 132791 | 132791 | 187166 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2301 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984954.0932 | 2099317.2472 | 37.7434553590095 | -122.494701382193 | (37.7434553590095, -122.494701382193) | |||
| 52819 | 52819 | 187247 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984940.8963 | 2098476.306 | 37.7411455892764 | -122.494685028149 | (37.7411455892764, -122.494685028149) | |||
| 184697 | 184697 | 187051 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2501 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984993.8369 | 2097637.9998 | 37.738846924542706 | -122.49444020007799 | (37.7388469245427, -122.494440200078) | |||
| 152972 | 152972 | 187050 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2501 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984995.182 | 2097644.0528 | 37.7388636231768 | -122.494435995495 | (37.7388636231768, -122.494435995495) | |||
| 83115 | 83115 | 21346 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2592X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 120024 | 120024 | 21347 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2592X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 140607 | 140607 | 21345 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2592X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 39110 | 39110 | 187384 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985074.9529 | 2100108.0339 | 37.7456337184099 | -122.494341764001 | (37.7456337184099, -122.494341764001) | |||
| 146906 | 146906 | 187322 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985076.4763 | 2099635.9315 | 37.7443375424183 | -122.494301703866 | (37.7443375424183, -122.494301703866) | |||
| 65905 | 65905 | 187317 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985079.5233 | 2099619.0042 | 37.7442912429495 | -122.494289920676 | (37.7442912429495, -122.494289920676) | |||
| 59886 | 59886 | 187325 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985091.7109 | 2099649.8119 | 37.7443765457606 | -122.494250049505 | (37.7443765457606, -122.494250049505) | |||
| 188972 | 188972 | 187326 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985094.7578 | 2099652.5203 | 37.7443841605942 | -122.494239713708 | (37.7443841605942, -122.494239713708) | |||
| 37709 | 37709 | 50244 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1274 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 6 | Permit Number 46949 | 5985245.6795 | 2106544.1944 | 37.7633156319875 | -122.49422573334999 | (37.7633156319875, -122.49422573335) | |
| 55454 | 55454 | 185000 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2701 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985034.7824 | 2096510.0599 | 37.7357522997185 | -122.494215517122 | (37.7357522997185, -122.494215517122) | |||
| 167602 | 167602 | 185011 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2701 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985034.3637 | 2096468.1875 | 37.7356373047826 | -122.49421387938601 | (37.7356373047826, -122.494213879386) | |||
| 44339 | 44339 | 184999 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2701 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985036.0386 | 2096516.3408 | 37.7357696189035 | -122.494211636814 | (37.7357696189035, -122.494211636814) | |||
| 72764 | 72764 | 185007 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2701 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985036.4573 | 2096492.0548 | 37.7357029605314 | -122.49420839974199 | (37.7357029605314, -122.494208399742) | |||
| 164196 | 164196 | 185484 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985117.0889 | 2098499.1184 | 37.741218537266796 | -122.494077507295 | (37.7412185372668, -122.494077507295) | |||
| 66075 | 66075 | 185169 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985175.8564 | 2097713.8919 | 37.739065954832604 | -122.493816461854 | (37.7390659548326, -122.493816461854) | |||
| 89296 | 89296 | 185164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2500 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985178.5125 | 2097683.3461 | 37.7389822396554 | -122.493805028032 | (37.7389822396554, -122.493805028032) | |||
| 166223 | 166223 | 186868 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2700 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985166.3388 | 2096363.9443 | 37.73535880277029 | -122.493749918136 | (37.7353588027703, -122.493749918136) | |||
| 49120 | 49120 | 186894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2700 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985197.9699 | 2096565.1913 | 37.73591322390129 | -122.493655383708 | (37.7359132239013, -122.493655383708) | |||
| 54403 | 54403 | 119464 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 690 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985706.9173099995 | 2111215.35341 | 37.776168297371505 | -122.492974588998 | (37.7761682973715, -122.492974588998) | |||
| 164044 | 164044 | 119463 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 690 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985707.60303 | 2111194.84048 | 37.7761120148174 | -122.49297070558701 | (37.7761120148174, -122.492970705587) | |||
| 34938 | 34938 | 119462 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 690 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985708.5317 | 2111176.93111 | 37.7760628951039 | -122.492966173591 | (37.7760628951039, -122.492966173591) | |||
| 81208 | 81208 | 9275 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6800 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 8M | 5985741.39506 | 2112508.81899 | 37.779721800131796 | -122.49295062194099 | (37.7797218001318, -122.492950621941) | ||
| 30085 | 30085 | 119310 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3140 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5985735.316219999 | 2111154.39034 | 37.776002570923 | -122.49287185946899 | (37.776002570923, -122.492871859469) | |||
| 26927 | 26927 | 119309 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3140 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985780.39427 | 2111154.49522 | 37.7760054948731 | -122.492715932595 | (37.7760054948731, -122.492715932595) | |||
| 160207 | 160207 | 57808 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3140 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1977 12:00:00 AM | 5 | Permit Number 16744 | 5985802.737980001 | 2111156.1497299997 | 37.7760113441782 | -122.492638762807 | (37.7760113441782, -122.492638762807) | ||
| 78258 | 78258 | 95981 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6800 Geary Blvd | 2 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 5985845.243869999 | 2112512.8777799997 | 37.7797390169842 | -122.492591667736 | (37.7797390169842, -122.492591667736) | |||
| 148608 | 148608 | 182623 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1850 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985688.7082 | 2102627.708 | 37.7525879572458 | -122.492405036663 | (37.7525879572458, -122.492405036663) | |||
| 27139 | 27139 | 182622 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1850 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5985688.7082 | 2102616.5515 | 37.752557324548796 | -122.492404215168 | (37.7525573245488, -122.492404215168) | |||
| 61690 | 61690 | 115232 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 523 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775420 | 5985904.5 | 2112316.6 | 37.7792035589465 | -122.49237222008001 | (37.7792035589465, -122.49237222008) | |||
| 67854 | 67854 | 119420 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 523 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985932.831730001 | 2112325.28299 | 37.7792290562827 | -122.49227484989201 | (37.7792290562827, -122.492274849892) | |||
| 117980 | 117980 | 9266 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 1 | 8M | 5986118.97919 | 2112523.68041 | 37.7797846793968 | -122.491645506378 | (37.7797846793968, -122.491645506378) | ||
| 45073 | 45073 | 92242 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1471 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52688 | 5986177.3397 | 2105245.4336 | 37.7598040693601 | -122.490907896162 | (37.7598040693601, -122.490907896162) | |
| 39295 | 39295 | 44814 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1490 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 7 | Permit Number 43906 | 5986225.4839 | 2105102.471 | 37.7594143459963 | -122.490730872272 | (37.7594143459963, -122.490730872272) | |
| 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) | |||
| 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) | |||
| 44108 | 44108 | 181904 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2370 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5986121.3373 | 2099118.1885 | 37.7429770494421 | -122.490650759358 | (37.7429770494421, -122.490650759358) | |||
| 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) | |||
| 53594 | 53594 | 9256 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6600X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 8M | 5986422.80447 | 2112533.30055 | 37.779828845077795 | -122.49059516382201 | (37.7798288450778, -122.490595163822) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 31757 | 31757 | 95989 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 369 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767641 | 5986512.577409999 | 2113474.91393 | 37.7824194894942 | -122.490353892493 | (37.7824194894942, -122.490353892493) |
| 25482 | 25482 | 66331 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1221 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1990 12:00:00 AM | 8 | Permit Number 29450 | 5986429.897000001 | 2106906.0714 | 37.7643784727426 | -122.490156589457 | (37.7643784727426, -122.490156589457) | |
| 46846 | 46846 | 69918 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1285 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5986443.4748 | 2106504.0514 | 37.7632754302753 | -122.490080055854 | (37.7632754302753, -122.490080055854) | ||
| 84304 | 84304 | 33169 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2221 TARAVAL ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768560 | 5986287.4 | 2098860.0 | 37.7422778317635 | -122.490057581406 | (37.7422778317635, -122.490057581406) |
| 107984 | 107984 | 95456 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.49000089052099 | (37.7774409068096, -122.490000890521) | ||
| 179003 | 179003 | 119994 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 526 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5986601.12954 | 2112305.72798 | 37.7792144102456 | -122.48996152454201 | (37.7792144102456, -122.489961524542) | |||
| 36202 | 36202 | 181954 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2213 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5986321.1753 | 2098879.7703 | 37.7423340880066 | -122.48994225213998 | (37.7423340880066, -122.48994225214) |
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");