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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67943 | 67943 | 133166 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010237.48446 | 2122281.28865 | 37.8079567202001 | -122.40889726181001 | (37.8079567202001, -122.40889726181) | |||
| 29401 | 29401 | 133165 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010207.21606 | 2122279.33076 | 37.8079496488199 | -122.409001875447 | (37.8079496488199, -122.409001875447) | |||
| 170063 | 170063 | 133167 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010256.39489 | 2122271.9772900003 | 37.8079322127625 | -122.40883115985399 | (37.8079322127625, -122.408831159854) | |||
| 187672 | 187672 | 133164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010207.81759 | 2122270.0679900004 | 37.8079242492629 | -122.40899913969999 | (37.8079242492629, -122.4089991397) | |||
| 135811 | 135811 | 133168 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010279.11077 | 2122259.53245 | 37.807899314677 | -122.40875166696699 | (37.807899314677, -122.408751666967) | |||
| 161893 | 161893 | 133163 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010216.41491 | 2122216.75015 | 37.8077783333804 | -122.408965621987 | (37.8077783333804, -122.408965621987) | |||
| 67620 | 67620 | 133169 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010376.77172 | 2122205.8801 | 37.8077574681897 | -122.40840989849501 | (37.8077574681897, -122.408409898495) | |||
| 184428 | 184428 | 133170 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6010397.4572 | 2122193.47677 | 37.807724570097896 | -122.40833743563101 | (37.8077245700979, -122.408337435631) | |||
| 58023 | 58023 | 133171 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010415.55118 | 2122184.23819 | 37.8077002164636 | -122.408274164737 | (37.8077002164636, -122.408274164737) | |||
| 68729 | 68729 | 133162 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6010218.20069 | 2122178.33315 | 37.807672949920395 | -122.40895672949101 | (37.8076729499204, -122.408956729491) | |||
| 38455 | 38455 | 133172 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010432.96946 | 2122172.52415 | 37.8076690279636 | -122.40821305761101 | (37.8076690279636, -122.408213057611) | |||
| 185064 | 185064 | 133161 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010222.5930699995 | 2122161.11982 | 37.8076259324541 | -122.40894031325199 | (37.8076259324541, -122.408940313252) | |||
| 61190 | 61190 | 133160 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010226.97141 | 2122123.83069 | 37.807523791061 | -122.40892252824699 | (37.807523791061, -122.408922528247) | |||
| 71596 | 71596 | 133173 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6010549.201230001 | 2122094.68608 | 37.8074618115912 | -122.407805315766 | (37.8074618115912, -122.407805315766) | |||
| 151879 | 151879 | 133159 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010230.36491 | 2122096.40301 | 37.80744867157979 | -122.40890884779101 | (37.8074486715798, -122.408908847791) | |||
| 73659 | 73659 | 133174 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6010559.670419999 | 2122087.00358 | 37.8074413034386 | -122.407768542507 | (37.8074413034386, -122.407768542507) | |||
| 156115 | 156115 | 133175 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 8ft | 6010562.9606 | 2122079.77861 | 37.807421649655204 | -122.407756646259 | (37.8074216496552, -122.407756646259) | |||
| 51452 | 51452 | 120607 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010542.52683 | 2122064.94827 | 37.8073797853146 | -122.407826315843 | (37.8073797853146, -122.407826315843) | |||
| 171689 | 171689 | 120608 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010531.654080001 | 2122063.27649 | 37.807374586331 | -122.40786382564801 | (37.807374586331, -122.407863825648) | |||
| 44952 | 44952 | 133158 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010234.54459 | 2122068.76212 | 37.8073730107117 | -122.40889243154601 | (37.8073730107117, -122.408892431546) | |||
| 173002 | 173002 | 120609 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6010517.15809 | 2122061.11032 | 37.80736782701629 | -122.407913839654 | (37.8073678270163, -122.407913839654) | |||
| 152628 | 152628 | 120610 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010501.50248 | 2122058.02124 | 37.8073584686759 | -122.407967801668 | (37.8073584686759, -122.407967801668) | |||
| 23963 | 23963 | 120611 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6010487.778630001 | 2122056.40729 | 37.8073532688065 | -122.40801518244801 | (37.8073532688065, -122.408015182448) | |||
| 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) | ||||
| 135791 | 135791 | 120612 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010461.28086 | 2122053.1606900003 | 37.8073428708526 | -122.408106655207 | (37.8073428708526, -122.408106655207) | |||
| 188459 | 188459 | 120613 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010416.24668 | 2122047.4403 | 37.8073246424791 | -122.408262103012 | (37.8073246424791, -122.408262103012) | |||
| 36851 | 36851 | 120614 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6010408.116090001 | 2122046.12993 | 37.8073205892499 | -122.40829014837 | (37.8073205892499, -122.40829014837) | |||
| 177764 | 177764 | 133137 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2801 Leavenworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6007292.2429 | 2122109.53275 | 37.807319706996296 | -122.419077842767 | (37.8073197069963, -122.419077842767) | |||
| 169262 | 169262 | 120615 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010397.30052 | 2122043.98866 | 37.8073141042181 | -122.40832742709101 | (37.8073141042181, -122.408327427091) | |||
| 25665 | 25665 | 120616 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6010384.51701 | 2122042.2809099997 | 37.8073086993106 | -122.408371546927 | (37.8073086993106, -122.408371546927) | |||
| 27350 | 27350 | 133157 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010238.59911 | 2122044.66703 | 37.8073070787122 | -122.408876698811 | (37.8073070787122, -122.408876698811) | |||
| 155112 | 155112 | 120617 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6010329.49641 | 2122033.8571599997 | 37.807282488558 | -122.408561364135 | (37.807282488558, -122.408561364135) | |||
| 154590 | 154590 | 120618 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6010315.01578 | 2122031.29873 | 37.8072746527595 | -122.40861129717 | (37.8072746527595, -122.40861129717) | |||
| 131954 | 131954 | 120619 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.40866875575199 | (37.8072676263732, -122.408668755752) | |||
| 75536 | 75536 | 133138 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2801 Leavenworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007294.5755 | 2122084.57406 | 37.8072513081645 | -122.419067998799 | (37.8072513081645, -122.419067998799) | |||
| 62390 | 62390 | 133156 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010460.75882 | 2121992.28603 | 37.8071756949569 | -122.408104165883 | (37.8071756949569, -122.408104165883) | |||
| 150939 | 150939 | 133155 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010424.25918 | 2121988.2428099997 | 37.8071625495686 | -122.408230195965 | (37.8071625495686, -122.408230195965) | |||
| 57827 | 57827 | 66140 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 221 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1990 12:00:00 AM | 13 | Permit Number 29203 | 6002405.45885 | 2121836.92325 | 37.8062947928465 | -122.435970098337 | (37.8062947928465, -122.435970098337) | ||
| 74181 | 74181 | 133074 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 736 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007212.48928 | 2121606.5161599996 | 37.8059340603819 | -122.419318141631 | (37.8059340603819, -122.419318141631) | |||
| 180268 | 180268 | 143153 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2090 Grant Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010318.2551 | 2121458.3909 | 37.805701771795505 | -122.408559646613 | (37.8057017717955, -122.408559646613) | |||
| 93451 | 93451 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 108788 | 108788 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1275 Columbus Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 29574 | 29574 | 66047 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 465 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 9 | Permit Number 29210 | 6001137.14728 | 2121594.78406 | 37.805557811007795 | -122.44034192404399 | (37.8055578110078, -122.440341924044) | |
| 8715 | 8715 | 107356 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010305.7737 | 2121389.2048 | 37.8055111049264 | -122.40859795685199 | (37.8055111049264, -122.408597956852) | |||
| 8389 | 8389 | 115409 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 889 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006552.19616 | 2121461.14789 | 37.805497706607596 | -122.42159286252199 | (37.8054977066076, -122.421592862522) | |||
| 175929 | 175929 | 142640 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2030 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010328.3355 | 2121382.7884 | 37.805494750639895 | -122.40851942539 | (37.8054947506399, -122.40851942539) | |||
| 1714 | 1714 | 115408 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 889 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6006526.39743 | 2121457.3012099997 | 37.8054856898732 | -122.42168186931801 | (37.8054856898732, -122.421681869318) | |||
| 61364 | 61364 | 133075 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 899 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006495.56154 | 2121453.88194 | 37.8054745625741 | -122.421788338267 | (37.8054745625741, -122.421788338267) | |||
| 158198 | 158198 | 143193 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 GRANT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010307.0272 | 2121371.6551 | 37.8054629880096 | -122.408592380142 | (37.8054629880096, -122.408592380142) | |||
| 147879 | 147879 | 143191 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2010 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6010332.7456 | 2121367.0379 | 37.805451750654 | -122.408503051838 | (37.805451750654, -122.408503051838) | |||
| 61068 | 61068 | 133177 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6010481.51509 | 2121362.5408 | 37.8054477330788 | -122.40798789525 | (37.8054477330788, -122.40798789525) | ||||
| 160985 | 160985 | 143195 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 13 Midway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010077.6882 | 2121368.0904 | 37.8054403533909 | -122.40938579048401 | (37.8054403533909, -122.409385790484) | |||
| 913 | 913 | 107355 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.40858034027201 | (37.8054166971664, -122.408580340272) | |||
| 33297 | 33297 | 133178 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010460.26266 | 2121350.57674 | 37.8054136928441 | -122.40806059821199 | (37.8054136928441, -122.408060598212) | ||||
| 146686 | 146686 | 143190 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2000 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010334.6357 | 2121352.5474 | 37.8054120691874 | -122.408495488074 | (37.8054120691874, -122.408495488074) | |||
| 150663 | 150663 | 133180 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6010437.48919 | 2121349.87905 | 37.80541050205729 | -122.40813935996 | (37.8054105020573, -122.40813935996) | ||||
| 158580 | 158580 | 133176 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6010490.33512 | 2121337.17898 | 37.8053785896135 | -122.407955582591 | (37.8053785896135, -122.407955582591) | ||||
| 160710 | 160710 | 133179 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 Francisco St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010446.38311 | 2121337.68774 | 37.8053775257257 | -122.408107720898 | (37.8053775257257, -122.408107720898) | ||||
| 147172 | 147172 | 133181 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010456.661040001 | 2121322.6258799997 | 37.805336745057396 | -122.408071089728 | (37.8053367450574, -122.408071089728) | ||||
| 173428 | 173428 | 133190 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6010565.46337 | 2121315.97137 | 37.8053245646485 | -122.407694093918 | (37.8053245646485, -122.407694093918) | ||||
| 52076 | 52076 | 133187 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010536.300969999 | 2121315.75922 | 37.8053223496175 | -122.407794999663 | (37.8053223496175, -122.407794999663) | ||||
| 188185 | 188185 | 133189 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010562.1879199995 | 2121314.22329 | 37.8053195814974 | -122.40770530575399 | (37.8053195814974, -122.407705305754) | ||||
| 176631 | 176631 | 133188 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010540.31188 | 2121313.86259 | 37.80531736647829 | -122.407780985508 | (37.8053173664783, -122.407780985508) | ||||
| 42553 | 42553 | 133185 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6010525.52833 | 2121313.76081 | 37.805316259401295 | -122.407832138939 | (37.8053162594013, -122.407832138939) | ||||
| 52718 | 52718 | 143196 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3 Midway St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010083.3642 | 2121319.2771 | 37.805306642222796 | -122.409362700866 | (37.8053066422228, -122.409362700866) | |||
| 50265 | 50265 | 133184 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6010514.4999 | 2121309.14638 | 37.8053029719104 | -122.407869978821 | (37.8053029719104, -122.407869978821) | ||||
| 188585 | 188585 | 133186 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010537.33866 | 2121307.06763 | 37.80529854275579 | -122.40779079533199 | (37.8052985427558, -122.407790795332) | ||||
| 162241 | 162241 | 133183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010500.28668 | 2121307.21814 | 37.8052968817183 | -122.40791902965401 | (37.8052968817183, -122.407919029654) | ||||
| 55269 | 55269 | 133182 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010494.592999999 | 2121305.47712 | 37.8052917825441 | -122.4079386106 | (37.8052917825441, -122.4079386106) | ||||
| 56666 | 56666 | 66048 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 424 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 13 | Permit Number 29181 | 6001089.75769 | 2121478.69254 | 37.8052363564241 | -122.440497590403 | (37.8052363564241, -122.440497590403) | ||
| 35194 | 35194 | 31668 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 215#3 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | Permit Number 35176 | 6010250.9256 | 2121284.082 | 37.8052193918816 | -122.408780346054 | (37.8052193918816, -122.408780346054) | |
| 148712 | 148712 | 143216 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 221 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010228.4436 | 2121281.2119 | 37.805210252041796 | -122.408857945528 | (37.8052102520418, -122.408857945528) | |||
| 168271 | 168271 | 143209 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1960 GRANT AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010344.1015 | 2121269.7232 | 37.805185184583394 | -122.408456884376 | (37.8051851845834, -122.408456884376) | |||
| 158533 | 158533 | 143208 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1960 GRANT AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010347.6145 | 2121247.3277 | 37.805123888825996 | -122.408443146453 | (37.805123888826, -122.408443146453) | |||
| 96613 | 96613 | 48836 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3700X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46054 | 6003439.85317318 | 2121384.75473793 | 37.805111964872395 | -122.43235808435 | (37.8051119648724, -122.43235808435) | |||
| 113726 | 113726 | 48835 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3700X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | Permit Number 46054 | 6003439.85317318 | 2121384.75473793 | 37.805111964872395 | -122.43235808435 | (37.8051119648724, -122.43235808435) | |||
| 42816 | 42816 | 143207 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1960 GRANT AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010351.5667 | 2121221.8584 | 37.805054177768895 | -122.408427671693 | (37.8050541777689, -122.408427671693) | |||
| 80335 | 80335 | 98579 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 94043 | 94043 | 98566 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/04/2013 12:00:00 AM | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | ||
| 116963 | 116963 | 98570 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |
| 117271 | 117271 | 98572 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 117633 | 117633 | 98578 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/26/2016 09:53:00 AM | 3 | 6x7 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |
| 119062 | 119062 | 98568 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |
| 120761 | 120761 | 98574 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 126470 | 126470 | 98573 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 138574 | 138574 | 98575 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 161001 | 161001 | 132756 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3601 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003510.18678 | 2121357.23068 | 37.80504037886271 | -122.43211271993 | (37.8050403788627, -122.43211271993) | |||
| 4581 | 4581 | 142526 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | |||
| 184329 | 184329 | 143206 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1960 GRANT AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6010352.4449 | 2121209.5628 | 37.8050204662791 | -122.408423764738 | (37.8050204662791, -122.408423764738) | |||
| 4583 | 4583 | 142550 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:53:00 AM | 22 | Width 0ft | 6009784.6811 | 2121219.3711 | 37.805015586162796 | -122.41038927752199 | (37.8050155861628, -122.410389277522) | ||
| 4595 | 4595 | 142523 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.804977071531404 | -122.410638645677 | (37.8049770715314, -122.410638645677) | |||
| 4590 | 4590 | 142522 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.804975764730294 | -122.410719306308 | (37.8049757647303, -122.410719306308) | |||
| 38864 | 38864 | 143205 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1960 GRANT AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6010355.0797 | 2121190.6804 | 37.8049687674386 | -122.408413313951 | (37.8049687674386, -122.408413313951) | |||
| 4571 | 4571 | 142549 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.41079549257799 | (37.8049613971858, -122.410795492578) | |||
| 4612 | 4612 | 142548 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | |||
| 4573 | 4573 | 142546 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301 FRANCISCO ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/26/2016 09:47:00 AM | 23 | Width 0ft | 6009592.8375 | 2121191.8795 | 37.8049293448711 | -122.411051233847 | (37.8049293448711, -122.411051233847) | ||
| 38519 | 38519 | 98781 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3601X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003515.05274 | 2121316.40662 | 37.804928562571504 | -122.432092963617 | (37.8049285625715, -122.432092963617) | |||
| 2368 | 2368 | 68207 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2048 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 10 | Permit Number 31989 | 6009891.7858 | 2121179.0457 | 37.80491086613029 | -122.41001577934601 | (37.8049108661303, -122.410015779346) | |
| 152530 | 152530 | 143204 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1960 GRANT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010358.5927 | 2121168.7241 | 37.804908677608 | -122.40839960710301 | (37.804908677608, -122.408399607103) | |||
| 23513 | 23513 | 56574 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1931 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6010338.9406 | 2121168.3232 | 37.804906476308204 | -122.40846758735701 | (37.8049064763082, -122.408467587357) |
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");