trees
7,157 rows where qSpecies_id = 36 sorted by Location descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64451 | 133166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6010237.48446 | 2122281.28865 | 37.8079567202001 | -122.40889726181 | (37.8079567202001, -122.40889726181) | 3 | 1 | 10 | 308 | 23 | |||
| 122559 | 133165 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010207.21606 | 2122279.33076 | 37.8079496488199 | -122.409001875447 | (37.8079496488199, -122.409001875447) | 3 | 1 | 10 | 308 | 23 | |||
| 170935 | 133167 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010256.39489 | 2122271.97729 | 37.8079322127625 | -122.408831159854 | (37.8079322127625, -122.408831159854) | 3 | 1 | 10 | 308 | 23 | |||
| 182162 | 133164 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010207.81759 | 2122270.06799 | 37.8079242492629 | -122.4089991397 | (37.8079242492629, -122.4089991397) | 3 | 1 | 10 | 308 | 23 | |||
| 106392 | 133168 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010279.11077 | 2122259.53245 | 37.807899314677 | -122.408751666967 | (37.807899314677, -122.408751666967) | 3 | 1 | 10 | 308 | 23 | |||
| 100243 | 133163 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010216.41491 | 2122216.75015 | 37.8077783333804 | -122.408965621987 | (37.8077783333804, -122.408965621987) | 3 | 1 | 10 | 308 | 23 | |||
| 173924 | 133169 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010376.77172 | 2122205.8801 | 37.8077574681897 | -122.408409898495 | (37.8077574681897, -122.408409898495) | 3 | 1 | 10 | 308 | 23 | |||
| 24599 | 133170 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6010397.4572 | 2122193.47677 | 37.8077245700979 | -122.408337435631 | (37.8077245700979, -122.408337435631) | 3 | 1 | 10 | 308 | 23 | |||
| 111851 | 133171 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010415.55118 | 2122184.23819 | 37.8077002164636 | -122.408274164737 | (37.8077002164636, -122.408274164737) | 3 | 1 | 10 | 308 | 23 | |||
| 29475 | 133162 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6010218.20069 | 2122178.33315 | 37.8076729499204 | -122.408956729491 | (37.8076729499204, -122.408956729491) | 3 | 1 | 10 | 308 | 23 | |||
| 110451 | 133172 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010432.96946 | 2122172.52415 | 37.8076690279636 | -122.408213057611 | (37.8076690279636, -122.408213057611) | 3 | 1 | 10 | 308 | 23 | |||
| 155489 | 133161 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6010222.59307 | 2122161.11982 | 37.8076259324541 | -122.408940313252 | (37.8076259324541, -122.408940313252) | 3 | 1 | 10 | 308 | 23 | |||
| 169160 | 133160 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010226.97141 | 2122123.83069 | 37.807523791061 | -122.408922528247 | (37.807523791061, -122.408922528247) | 3 | 1 | 10 | 308 | 23 | |||
| 120790 | 133173 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6010549.20123 | 2122094.68608 | 37.8074618115912 | -122.407805315766 | (37.8074618115912, -122.407805315766) | 3 | 1 | 10 | 308 | 23 | |||
| 103404 | 133159 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010230.36491 | 2122096.40301 | 37.8074486715798 | -122.408908847791 | (37.8074486715798, -122.408908847791) | 3 | 1 | 10 | 308 | 23 | |||
| 49260 | 133174 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 5ft | 6010559.67042 | 2122087.00358 | 37.8074413034386 | -122.407768542507 | (37.8074413034386, -122.407768542507) | 3 | 1 | 10 | 308 | 23 | |||
| 99667 | 133175 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1900 The Embarcadero | 11 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 8ft | 6010562.9606 | 2122079.77861 | 37.8074216496552 | -122.407756646259 | (37.8074216496552, -122.407756646259) | 3 | 1 | 10 | 308 | 23 | |||
| 129487 | 120607 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010542.52683 | 2122064.94827 | 37.8073797853146 | -122.407826315843 | (37.8073797853146, -122.407826315843) | 3 | 1 | 10 | 308 | 23 | |||
| 169267 | 120608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010531.65408 | 2122063.27649 | 37.807374586331 | -122.407863825648 | (37.807374586331, -122.407863825648) | 3 | 1 | 10 | 308 | 23 | |||
| 101739 | 133158 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010234.54459 | 2122068.76212 | 37.8073730107117 | -122.408892431546 | (37.8073730107117, -122.408892431546) | 3 | 1 | 10 | 308 | 23 | |||
| 154356 | 120609 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010517.15809 | 2122061.11032 | 37.8073678270163 | -122.407913839654 | (37.8073678270163, -122.407913839654) | 3 | 1 | 10 | 308 | 23 | |||
| 25687 | 120610 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010501.50248 | 2122058.02124 | 37.8073584686759 | -122.407967801668 | (37.8073584686759, -122.407967801668) | 3 | 1 | 10 | 308 | 23 | |||
| 4528 | 120611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:17:00 PM | 3 | 3x3 | 6010487.77863 | 2122056.40729 | 37.8073532688065 | -122.408015182448 | (37.8073532688065, -122.408015182448) | 3 | 1 | 10 | 308 | 23 | ||
| 59862 | 120620 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010405 | 2122056 | 37.8073475155142 | -122.408301628949 | (37.8073475155142, -122.408301628949) | 3 | 1 | 10 | 308 | 23 | ||||
| 3738 | 120612 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:15:00 PM | 3 | 3x3 | 6010461.28086 | 2122053.16069 | 37.8073428708526 | -122.408106655207 | (37.8073428708526, -122.408106655207) | 3 | 1 | 10 | 308 | 23 | ||
| 145707 | 120613 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010416.24668 | 2122047.4403 | 37.8073246424791 | -122.408262103012 | (37.8073246424791, -122.408262103012) | 3 | 1 | 10 | 308 | 23 | |||
| 74468 | 120614 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6010408.11609 | 2122046.12993 | 37.8073205892499 | -122.40829014837 | (37.8073205892499, -122.40829014837) | 3 | 1 | 10 | 308 | 23 | |||
| 19835 | 133137 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2801 Leavenworth St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007292.2429 | 2122109.53275 | 37.8073197069963 | -122.419077842767 | (37.8073197069963, -122.419077842767) | 5 | 1 | 1 | 308 | 32 | |||
| 57832 | 120615 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010397.30052 | 2122043.98866 | 37.8073141042181 | -122.408327427091 | (37.8073141042181, -122.408327427091) | 3 | 1 | 10 | 308 | 23 | |||
| 46320 | 120616 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6010384.51701 | 2122042.28091 | 37.8073086993106 | -122.408371546927 | (37.8073086993106, -122.408371546927) | 3 | 1 | 10 | 308 | 23 | |||
| 7916 | 133157 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2200 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:39:00 PM | 3 | Width 4ft | 6010238.59911 | 2122044.66703 | 37.8073070787122 | -122.408876698811 | (37.8073070787122, -122.408876698811) | 3 | 1 | 10 | 308 | 23 | ||
| 101965 | 120617 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6010329.49641 | 2122033.85716 | 37.807282488558 | -122.408561364135 | (37.807282488558, -122.408561364135) | 3 | 1 | 10 | 308 | 23 | |||
| 158026 | 120618 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6010315.01578 | 2122031.29873 | 37.8072746527595 | -122.40861129717 | (37.8072746527595, -122.40861129717) | 3 | 1 | 10 | 308 | 23 | |||
| 1444 | 256097 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:12:00 PM | 3 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.408668755752 | (37.8072676263732, -122.408668755752) | 3 | 1 | 10 | 308 | 23 | ||
| 102285 | 256096 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.408668755752 | (37.8072676263732, -122.408668755752) | 3 | 1 | 10 | 308 | 23 | ||||
| 194063 | 120619 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 North Point St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010298.36751 | 2122029.07931 | 37.8072676263732 | -122.408668755752 | (37.8072676263732, -122.408668755752) | 3 | 1 | 10 | 308 | 23 | |||
| 53840 | 133138 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2801 Leavenworth St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007294.5755 | 2122084.57406 | 37.8072513081645 | -122.419067998799 | (37.8072513081645, -122.419067998799) | 5 | 1 | 1 | 308 | 32 | |||
| 59026 | 133156 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99 North Point St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6010460.75882 | 2121992.28603 | 37.8071756949569 | -122.408104165883 | (37.8071756949569, -122.408104165883) | 3 | 1 | 10 | 308 | 23 | |||
| 92160 | 133155 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 99 North Point St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6010424.25918 | 2121988.24281 | 37.8071625495686 | -122.408230195965 | (37.8071625495686, -122.408230195965) | 3 | 1 | 10 | 308 | 23 | |||
| 159198 | 66140 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 221 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/1990 12:00:00 AM | 13 | Permit Number 29203 | 6002405.45885 | 2121836.92325 | 37.8062947928465 | -122.435970098337 | (37.8062947928465, -122.435970098337) | 13 | 9 | 1 | 57 | 17 | ||
| 164048 | 133074 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 736 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007212.48928 | 2121606.51616 | 37.8059340603819 | -122.419318141631 | (37.8059340603819, -122.419318141631) | 5 | 1 | 1 | 28858 | 32 | |||
| 19651 | 143153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2090 Grant Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010318.2551 | 2121458.3909 | 37.8057017717955 | -122.408559646613 | (37.8057017717955, -122.408559646613) | 3 | 1 | 10 | 308 | 23 | |||
| 83898 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1275 Columbus Ave | 2 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
| 123789 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1275 Columbus Ave | 3 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
| 3793 | 66047 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 465 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1990 12:00:00 AM | 9 | Permit Number 29210 | 6001137.14728 | 2121594.78406 | 37.8055578110078 | -122.440341924044 | (37.8055578110078, -122.440341924044) | 13 | 9 | 1 | 57 | 17 | |
| 75450 | 107356 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2001 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010305.7737 | 2121389.2048 | 37.8055111049264 | -122.408597956852 | (37.8055111049264, -122.408597956852) | 3 | 1 | 10 | 308 | 23 | |||
| 80017 | 115409 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 889 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006552.19616 | 2121461.14789 | 37.8054977066076 | -122.421592862522 | (37.8054977066076, -122.421592862522) | 5 | 1 | 1 | 28858 | 32 | |||
| 112636 | 142640 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2030 Grant Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010328.3355 | 2121382.7884 | 37.8054947506399 | -122.40851942539 | (37.8054947506399, -122.40851942539) | 3 | 1 | 10 | 308 | 23 | |||
| 170749 | 115408 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 889 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6006526.39743 | 2121457.30121 | 37.8054856898732 | -122.421681869318 | (37.8054856898732, -122.421681869318) | 5 | 1 | 1 | 28858 | 32 | |||
| 51831 | 133075 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 899 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006495.56154 | 2121453.88194 | 37.8054745625741 | -122.421788338267 | (37.8054745625741, -122.421788338267) | 5 | 1 | 1 | 28858 | 32 | |||
| 81995 | 143193 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2001 GRANT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010307.0272 | 2121371.6551 | 37.8054629880096 | -122.408592380142 | (37.8054629880096, -122.408592380142) | 3 | 1 | 10 | 308 | 23 | |||
| 71454 | 143191 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2010 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010332.7456 | 2121367.0379 | 37.805451750654 | -122.408503051838 | (37.805451750654, -122.408503051838) | 3 | 1 | 10 | 308 | 23 | |||
| 118048 | 133177 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 10 | Front Yard : Yard | Tree | Private 2 | 19 | 6010481.51509 | 2121362.5408 | 37.8054477330788 | -122.40798789525 | (37.8054477330788, -122.40798789525) | 3 | 1 | 10 | 308 | 23 | ||||
| 98346 | 143195 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 13 Midway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010077.6882 | 2121368.0904 | 37.8054403533909 | -122.409385790484 | (37.8054403533909, -122.409385790484) | 3 | 1 | 10 | 308 | 23 | |||
| 93808 | 107355 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.408580340272 | (37.8054166971664, -122.408580340272) | 3 | 1 | 10 | 308 | 23 | |||
| 100857 | 133178 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 12 | Front Yard : Yard | Tree | Private 2 | 14 | 6010460.26266 | 2121350.57674 | 37.8054136928441 | -122.408060598212 | (37.8054136928441, -122.408060598212) | 3 | 1 | 10 | 308 | 23 | ||||
| 172559 | 143190 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2000 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010334.6357 | 2121352.5474 | 37.8054120691874 | -122.408495488074 | (37.8054120691874, -122.408495488074) | 3 | 1 | 10 | 308 | 23 | |||
| 157952 | 133180 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 15 | Front Yard : Yard | Tree | Private 2 | 16 | 6010437.48919 | 2121349.87905 | 37.8054105020573 | -122.40813935996 | (37.8054105020573, -122.40813935996) | 3 | 1 | 10 | 308 | 23 | ||||
| 184121 | 133176 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 9 | Front Yard : Yard | Tree | Private 2 | 45 | 6010490.33512 | 2121337.17898 | 37.8053785896135 | -122.407955582591 | (37.8053785896135, -122.407955582591) | 3 | 1 | 10 | 308 | 23 | ||||
| 15909 | 133179 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 150 Francisco St | 14 | Front Yard : Yard | Tree | Private 2 | 4 | 6010446.38311 | 2121337.68774 | 37.8053775257257 | -122.408107720898 | (37.8053775257257, -122.408107720898) | 3 | 1 | 10 | 308 | 23 | ||||
| 159955 | 133181 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6010456.66104 | 2121322.62588 | 37.8053367450574 | -122.408071089728 | (37.8053367450574, -122.408071089728) | 3 | 1 | 10 | 308 | 23 | ||||
| 41928 | 133190 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 13 | Front Yard : Yard | Tree | Private 2 | 3 | 6010565.46337 | 2121315.97137 | 37.8053245646485 | -122.407694093918 | (37.8053245646485, -122.407694093918) | 3 | 1 | 10 | 308 | 23 | ||||
| 127286 | 133187 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6010536.30097 | 2121315.75922 | 37.8053223496175 | -122.407794999663 | (37.8053223496175, -122.407794999663) | 3 | 1 | 10 | 308 | 23 | ||||
| 185548 | 133189 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 12 | Front Yard : Yard | Tree | Private 2 | 4 | 6010562.18792 | 2121314.22329 | 37.8053195814974 | -122.407705305754 | (37.8053195814974, -122.407705305754) | 3 | 1 | 10 | 308 | 23 | ||||
| 191882 | 133188 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | 6010540.31188 | 2121313.86259 | 37.8053173664783 | -122.407780985508 | (37.8053173664783, -122.407780985508) | 3 | 1 | 10 | 308 | 23 | ||||
| 98142 | 133185 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 6 | Front Yard : Yard | Tree | Private 2 | 31 | 6010525.52833 | 2121313.76081 | 37.8053162594013 | -122.407832138939 | (37.8053162594013, -122.407832138939) | 3 | 1 | 10 | 308 | 23 | ||||
| 60346 | 143196 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3 Midway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010083.3642 | 2121319.2771 | 37.8053066422228 | -122.409362700866 | (37.8053066422228, -122.409362700866) | 3 | 1 | 10 | 308 | 23 | |||
| 49197 | 133184 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 5 | Front Yard : Yard | Tree | Private 2 | 26 | 6010514.4999 | 2121309.14638 | 37.8053029719104 | -122.407869978821 | (37.8053029719104, -122.407869978821) | 3 | 1 | 10 | 308 | 23 | ||||
| 119090 | 133186 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 7 | Front Yard : Yard | Tree | Private 2 | 11 | 6010537.33866 | 2121307.06763 | 37.8052985427558 | -122.407790795332 | (37.8052985427558, -122.407790795332) | 3 | 1 | 10 | 308 | 23 | ||||
| 180539 | 133183 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6010500.28668 | 2121307.21814 | 37.8052968817183 | -122.407919029654 | (37.8052968817183, -122.407919029654) | 3 | 1 | 10 | 308 | 23 | ||||
| 19619 | 133182 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 165 Francisco St | 3 | Front Yard : Yard | Tree | Private 2 | 5 | 6010494.593 | 2121305.47712 | 37.8052917825441 | -122.4079386106 | (37.8052917825441, -122.4079386106) | 3 | 1 | 10 | 308 | 23 | ||||
| 166145 | 66048 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 424 Avila St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1990 12:00:00 AM | 13 | Permit Number 29181 | 6001089.75769 | 2121478.69254 | 37.8052363564241 | -122.440497590403 | (37.8052363564241, -122.440497590403) | 13 | 9 | 1 | 57 | 17 | ||
| 2859 | 31668 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 215#3 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1995 12:00:00 AM | 11 | Permit Number 35176 | 6010250.9256 | 2121284.082 | 37.8052193918816 | -122.408780346054 | (37.8052193918816, -122.408780346054) | 3 | 1 | 10 | 308 | 23 | |
| 142840 | 143209 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010344.1015 | 2121269.7232 | 37.8051851845834 | -122.408456884376 | (37.8051851845834, -122.408456884376) | 3 | 1 | 10 | 308 | 23 | |||
| 95231 | 143208 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010347.6145 | 2121247.3277 | 37.805123888826 | -122.408443146453 | (37.805123888826, -122.408443146453) | 3 | 1 | 10 | 308 | 23 | |||
| 194331 | 143216 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010256 | 2121247 | 37.8051178581324 | -122.408760167658 | (37.8051178581324, -122.408760167658) | 3 | 1 | 10 | 308 | 23 | |||
| 78019 | 48836 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3700X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46054 | 6003439.85317318 | 2121384.75473793 | 37.8051119648724 | -122.43235808435 | (37.8051119648724, -122.43235808435) | 13 | 9 | 1 | 57 | 17 | |||
| 149684 | 48835 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3700X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46054 | 6003439.85317318 | 2121384.75473793 | 37.8051119648724 | -122.43235808435 | (37.8051119648724, -122.43235808435) | 13 | 9 | 1 | 57 | 17 | |||
| 107284 | 143207 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010351.5667 | 2121221.8584 | 37.8050541777689 | -122.408427671693 | (37.8050541777689, -122.408427671693) | 3 | 1 | 10 | 308 | 23 | |||
| 24959 | 98573 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 47784 | 98579 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 79751 | 98566 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/04/2013 12:00:00 AM | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | ||
| 152258 | 98578 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:53:00 AM | 3 | 6x7 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
| 152503 | 98570 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/26/2016 09:47:00 AM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
| 155011 | 98574 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 156452 | 98568 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
| 160459 | 98572 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 175355 | 98575 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301X Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
| 69452 | 132756 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2018 08:13:00 AM | 3 | Width 4ft | 6003510.18678 | 2121357.23068 | 37.8050403788627 | -122.43211271993 | (37.8050403788627, -122.43211271993) | 13 | 9 | 1 | 28858 | 17 | ||
| 80723 | 142526 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | Width 0ft | 6009810.3798 | 2121222.957 | 37.8050268727325 | -122.410300597206 | (37.8050268727325, -122.410300597206) | 3 | 1 | 10 | 308 | 23 | |||
| 102799 | 143206 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010352.4449 | 2121209.5628 | 37.8050204662791 | -122.408423764738 | (37.8050204662791, -122.408423764738) | 3 | 1 | 10 | 308 | 23 | |||
| 83356 | 142550 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/26/2016 09:53:00 AM | 22 | Width 0ft | 6009784.6811 | 2121219.3711 | 37.8050155861628 | -122.410389277522 | (37.8050155861628, -122.410389277522) | 3 | 1 | 10 | 308 | 23 | ||
| 8590 | 142524 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/23/2016 02:52:00 PM | 20 | Width 0ft | 6009733.2838 | 2121208.6135 | 37.8049831671154 | -122.410566384357 | (37.8049831671154, -122.410566384357) | 3 | 1 | 10 | 308 | 23 | ||
| 125465 | 142523 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009712.3662 | 2121206.8206 | 37.8049770715314 | -122.410638645677 | (37.8049770715314, -122.410638645677) | 3 | 1 | 10 | 308 | 23 | |||
| 99299 | 142522 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | Width 0ft | 6009689.0581 | 2121206.8206 | 37.8049757647303 | -122.410719306308 | (37.8049757647303, -122.410719306308) | 3 | 1 | 10 | 308 | 23 | |||
| 135095 | 143205 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1960 GRANT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010355.0797 | 2121190.6804 | 37.8049687674386 | -122.408413313951 | (37.8049687674386, -122.408413313951) | 3 | 1 | 10 | 308 | 23 | |||
| 69868 | 142549 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 9 | Width 0ft | 6009666.9453 | 2121202.0395 | 37.8049613971858 | -122.410795492578 | (37.8049613971858, -122.410795492578) | 3 | 1 | 10 | 308 | 23 | |||
| 165062 | 142548 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 7 | Width 0ft | 6009639.4537 | 2121197.2583 | 37.8049467277157 | -122.410890292822 | (37.8049467277157, -122.410890292822) | 3 | 1 | 10 | 308 | 23 | |||
| 71668 | 142546 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/26/2016 09:47:00 AM | 23 | Width 0ft | 6009592.8375 | 2121191.8795 | 37.8049293448711 | -122.411051233847 | (37.8049293448711, -122.411051233847) | 3 | 1 | 10 | 308 | 23 | ||
| 178978 | 98781 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6003515.05274 | 2121316.40662 | 37.8049285625715 | -122.432092963617 | (37.8049285625715, -122.432092963617) | 13 | 9 | 1 | 28858 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );