Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 146876 | 146876 | 129011 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2020 Grant Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010212.84483 | 2122235.52115 | 37.8078296738771 | -122.40897930247 | (37.8078296738771, -122.40897930247) | |||
| 66883 | 66883 | 129010 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2020 Grant Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010219.4685 | 2122201.7291200003 | 37.8077372604315 | -122.408953993726 | (37.8077372604315, -122.408953993726) | |||
| 158625 | 158625 | 129012 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 150 Francisco St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6010624.52904 | 2121364.4676099997 | 37.8054610295673 | -122.40749310981501 | (37.8054610295673, -122.407493109815) | ||||
| 63296 | 63296 | 129013 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 150 Francisco St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.40757052527799 | (37.8054503923804, -122.407570525278) | ||||
| 167596 | 167596 | 143214 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 209 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010288.2363 | 2121289.8221 | 37.805237242499 | -122.40865163236099 | (37.805237242499, -122.408651632361) | |||
| 137083 | 137083 | 48357 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 271 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 4 | Permit Number 46907 | 6009989.2786 | 2121248.5013 | 37.805107037626904 | -122.40968329882 | (37.8051070376269, -122.40968329882) | |
| 57197 | 57197 | 129008 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2550 Leavenworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007462.65437 | 2121216.63674 | 37.804877636655995 | -122.418424741625 | (37.804877636656, -122.418424741625) | |||
| 131319 | 131319 | 129007 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2550 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007463.35439 | 2121202.39829 | 37.804838580893104 | -122.41842130890801 | (37.8048385808931, -122.418421308908) | |||
| 170611 | 170611 | 129016 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1500 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6011815.54331 | 2120971.5112099997 | 37.80444866004179 | -122.40334375932899 | (37.8044486600418, -122.403343759329) | |||
| 74680 | 74680 | 129015 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1500 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6011821.67405 | 2120927.2444 | 37.8043274566138 | -122.403319427258 | (37.8043274566138, -122.403319427258) | |||
| 182988 | 182988 | 129014 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1500 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6011826.76829 | 2120892.13124 | 37.8042313289751 | -122.40329932649901 | (37.8042313289751, -122.403299326499) | |||
| 6080 | 6080 | 55912 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 801 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770168 | 6007877.21664 | 2120606.58742 | 37.803225923789604 | -122.416946850615 | (37.8032259237896, -122.416946850615) | |
| 3517 | 3517 | 33317 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.42888659453699 | (37.8026433303993, -122.428886594537) | |
| 2487 | 2487 | 33316 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 774619 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346001 | (37.8026370063559, -122.42893607346) | |
| 61480 | 61480 | 128888 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1549 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003944.76829 | 2120400.7121200003 | 37.8024386572819 | -122.43054050716299 | (37.8024386572819, -122.430540507163) | |||
| 47596 | 47596 | 143067 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 15 Child St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010601.6848 | 2120393.9506 | 37.802794950820605 | -122.407503698977 | (37.8027949508206, -122.407503698977) | |||
| 24661 | 24661 | 143065 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Child St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010630.6807 | 2120383.8561 | 37.8027688567606 | -122.4074026458 | (37.8027688567606, -122.4074026458) | |||
| 55697 | 55697 | 143068 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1 Child St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010607.1256 | 2120351.0165 | 37.8026773688895 | -122.40748184222299 | (37.8026773688895, -122.407481842223) | |||
| 2222 | 2222 | 4694 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 850X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 70698 | 70698 | 64371 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 12 | Permit Number 25210 | 6010591.4795 | 2120329.1807 | 37.8026165373925 | -122.407534445483 | (37.8026165373925, -122.407534445483) | |
| 96202 | 96202 | 112131 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 106111 | 106111 | 112128 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 141984 | 141984 | 112129 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 144403 | 144403 | 112127 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 145495 | 145495 | 112130 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3x6 | 6008928.0 | 2120320.0 | 37.8024980771426 | -122.41329029104999 | (37.8024980771426, -122.41329029105) | |||
| 187696 | 187696 | 64369 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | |
| 57139 | 57139 | 143070 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 528 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010344.9622 | 2120299.1083 | 37.8025201643159 | -122.408385400714 | (37.8025201643159, -122.408385400714) | |||
| 48945 | 48945 | 72207 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1988 12:00:00 AM | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331001 | (37.8025135249949, -122.40843327331) | ||
| 87830 | 87830 | 64372 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 530 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | Permit Number 25211 | 6010298.20676285 | 2120293.66367922 | 37.802502596356 | -122.40854681425199 | (37.802502596356, -122.408546814252) | ||
| 42257 | 42257 | 64366 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 540 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 8 | Permit Number 25205 | 6010278.2434 | 2120287.8996 | 37.802485651571004 | -122.408615490868 | (37.802485651571, -122.408615490868) | |
| 155918 | 155918 | 52200 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 558 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2005 12:00:00 AM | 1 | Permit Number 48388 | 6010241.4146 | 2120284.6971 | 37.8024747955984 | -122.40874271130801 | (37.8024747955984, -122.408742711308) | ||
| 169763 | 169763 | 64365 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 550 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 7 | Permit Number 25204 | 6010256.8933 | 2120284.6971 | 37.8024756625421 | -122.408689147089 | (37.8024756625421, -122.408689147089) | |
| 23755 | 23755 | 143071 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 558 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010223.267000001 | 2120278.2921 | 37.8024561925927 | -122.408805059144 | (37.8024561925927, -122.408805059144) | |||
| 99966 | 99966 | 64382 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 560 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | Permit Number 25223 | 6010171.68830219 | 2120276.20924301 | 37.8024475844496 | -122.408983400718 | (37.8024475844496, -122.408983400718) | ||
| 132591 | 132591 | 143064 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 568 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010191.242000001 | 2120275.0896 | 37.802445605500004 | -122.40891565590799 | (37.8024456055, -122.408915655908) | |||
| 158370 | 158370 | 64363 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 568 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/09/2007 12:00:00 AM | 8 | Permit No. 49276 | 6010205.6533 | 2120275.0896 | 37.8024464127339 | -122.40886578546001 | (37.8024464127339, -122.40886578546) | |
| 77543 | 77543 | 64364 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | ||
| 154894 | 154894 | 64361 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 580 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 8 | Permit Number 25200 | 6010170.4257 | 2120272.4208 | 37.8024371115938 | -122.408987502507 | (37.8024371115938, -122.408987502507) | |
| 169879 | 169879 | 129005 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2620 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006623.131440001 | 2120229.16523 | 37.802118995958295 | -122.42125984178101 | (37.8021189959583, -122.421259841781) | |||
| 35548 | 35548 | 65857 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3444 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/1990 12:00:00 AM | 2 | 3x3 | Permit Number 49753 | 6000794.66575 | 2120227.32857 | 37.8017836378592 | -122.441428940891 | (37.8017836378592, -122.441428940891) | |
| 176661 | 176661 | 129004 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2620 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006625.292880001 | 2120213.2165099997 | 37.802075326681106 | -122.42125122896299 | (37.8020753266811, -122.421251228963) | |||
| 26133 | 26133 | 71422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6009722.2927 | 2120212.6608 | 37.802247912275206 | -122.41053404810499 | (37.8022479122752, -122.410534048105) | ||
| 138467 | 138467 | 86818 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3444 Scott St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49753 | 6000793.0 | 2120207.0 | 37.8017277261212 | -122.441433245596 | (37.8017277261212, -122.441433245596) | |||
| 35761 | 35761 | 46083 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | ||
| 187876 | 187876 | 128909 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1620 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004047.371 | 2120116.17018 | 37.8016631907718 | -122.430165140031 | (37.8016631907718, -122.430165140031) | |||
| 64252 | 64252 | 86823 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 290 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49766 | 6000913.42352 | 2120028.2365200003 | 37.8012437487566 | -122.44100369379 | (37.8012437487566, -122.44100369379) | |
| 185839 | 185839 | 250211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 212 Union St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796002 | (37.80121941579, -122.40351603796) | |||
| 25647 | 25647 | 58743 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2142 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3 | Permit Number 769347 | 6007661.70452 | 2119773.9783400004 | 37.800927664050995 | -122.417633590924 | (37.800927664051, -122.417633590924) | ||
| 125314 | 125314 | 108148 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6003294.68219 | 2119741.92969 | 37.8005929642463 | -122.43274303675899 | (37.8005929642463, -122.432743036759) | ||||
| 7551 | 7551 | 108147 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.43273393652399 | (37.800534134189, -122.432733936524) | ||
| 70162 | 70162 | 108146 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 3322 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6003298.685 | 2119704.23273 | 37.800489685219 | -122.432726491033 | (37.800489685219, -122.432726491033) | ||||
| 129967 | 129967 | 44131 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2820 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2000 12:00:00 AM | 4 | Permit Number 43633 | 6005248.14777 | 2119695.60909 | 37.8005763744637 | -122.425979944327 | (37.8005763744637, -122.425979944327) | ||
| 5948 | 5948 | 13140 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1785 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1997 12:00:00 AM | 18 | 3X3 | 6003874.8006 | 2119664.6973 | 37.8004137877384 | -122.430730076432 | (37.8004137877384, -122.430730076432) | ||
| 157906 | 157906 | 52195 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1209 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2005 12:00:00 AM | 3 | Permit Number 48386 | 6007084.31165 | 2119457.46133 | 37.8000260811036 | -122.419609149648 | (37.8000260811036, -122.419609149648) | ||
| 159809 | 159809 | 48589 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1813 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53725 | 6004114.81766 | 2119382.23545 | 37.799651815633 | -122.429879362441 | (37.799651815633, -122.429879362441) | |
| 31569 | 31569 | 68012 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1137 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 8 | Permit Number 31742 | 6011522.7953699995 | 2119247.92417 | 37.799699755809705 | -122.404235461403 | (37.7996997558097, -122.404235461403) | ||
| 57029 | 57029 | 129009 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1137 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6011525.133769999 | 2119231.5602700002 | 37.7996549551749 | -122.404226217291 | (37.7996549551749, -122.404226217291) | |||
| 4911 | 4911 | 107778 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.09266 | 2119225.96368 | 37.7990395913723 | -122.441026839613 | (37.7990395913723, -122.441026839613) | |
| 74589 | 74589 | 68167 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1131 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1993 12:00:00 AM | 12 | Permit Number 31936 | 6011528.02794 | 2119216.24888 | 37.79961307553079 | -122.404215124131 | (37.7996130755308, -122.404215124131) | ||
| 7997 | 7997 | 107779 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.66944 | 2119210.84486 | 37.798998111943604 | -122.44102375853599 | (37.7989981119436, -122.441023758536) | |
| 4755 | 4755 | 107780 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000893.56163 | 2119195.20013 | 37.7989553203824 | -122.441012627647 | (37.7989553203824, -122.441012627647) | |
| 1537 | 1537 | 107781 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3155 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000894.3565 | 2119181.32338 | 37.7989172637699 | -122.441008881075 | (37.7989172637699, -122.441008881075) | |
| 62796 | 62796 | 128887 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2201 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002313.17726 | 2119132.85269 | 37.7988648845528 | -122.43609582986099 | (37.7988648845528, -122.436095829861) | |||
| 172257 | 172257 | 128886 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2201 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002294.64841 | 2119130.10879 | 37.7988562978392 | -122.436159749193 | (37.7988562978392, -122.436159749193) | |||
| 42334 | 42334 | 128885 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2201 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002262.5909400005 | 2119125.2538400004 | 37.7988411460494 | -122.43627033072599 | (37.7988411460494, -122.436270330726) | |||
| 6582 | 6582 | 58810 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.0408799998 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | |
| 75370 | 75370 | 128884 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1978 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003477.22131 | 2118991.9993 | 37.7985442007084 | -122.432057794742 | (37.7985442007084, -122.432057794742) | |||
| 181187 | 181187 | 63951 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1980 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1987 12:00:00 AM | 6 | Permit Number 24682 | 6003463.5929 | 2118990.37708 | 37.798538973857795 | -122.43210483736601 | (37.7985389738578, -122.432104837366) | ||
| 153221 | 153221 | 63950 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1982 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1987 12:00:00 AM | 2 | Permit Number 24681 | 6003447.61154 | 2118987.9571 | 37.798531423141704 | -122.432159964919 | (37.7985314231417, -122.432159964919) | ||
| 52122 | 52122 | 106426 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2919 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770060 | 6003851.7386 | 2118879.7612099997 | 37.798257249522 | -122.430753834436 | (37.798257249522, -122.430753834436) | |
| 1696 | 1696 | 108698 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) |
| 77371 | 77371 | 44053 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3100 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43582 | 6001974.87365527 | 2118765.4026711 | 37.7978367374605 | -122.437240145023 | (37.7978367374605, -122.437240145023) | |||
| 147147 | 147147 | 112802 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 865 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009439.76342 | 2118739.20101 | 37.798186312790996 | -122.41140758440599 | (37.798186312791, -122.411407584406) | |||
| 58791 | 58791 | 112801 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 865 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009421.02251 | 2118738.48661 | 37.7981833000696 | -122.411472383257 | (37.7981833000696, -122.411472383257) | |||
| 168120 | 168120 | 129006 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.41321064328301 | (37.7977154080083, -122.413210643283) | ||||
| 8908 | 8908 | 33111 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.797185891667105 | -122.442801853125 | (37.7971858916671, -122.442801853125) | |
| 63735 | 63735 | 105352 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2055 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2014 12:00:00 AM | 1 | 3x3 | Permit Number 768583 | 6003162.6 | 2118532.6 | 37.7972649672191 | -122.433113640832 | (37.7972649672191, -122.433113640832) | |
| 161238 | 161238 | 128997 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1189 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007893.47286 | 2118525.7820099997 | 37.7975134679385 | -122.416743094821 | (37.7975134679385, -122.416743094821) | |||
| 177221 | 177221 | 128996 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1189 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007875.748269999 | 2118524.15827 | 37.7975080126282 | -122.416804311666 | (37.7975080126282, -122.416804311666) | |||
| 148579 | 148579 | 88446 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 51411 | 6005229.98772 | 2118491.64787 | 37.7972695780743 | -122.42595703411301 | (37.7972695780743, -122.425957034113) | ||
| 40623 | 40623 | 128908 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000146.67214 | 2118481.01335 | 37.7969517846466 | -122.44354577412099 | (37.7969517846466, -122.443545774121) | |||
| 32106 | 32106 | 128907 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000123.7305 | 2118478.82178 | 37.796944458770106 | -122.44362499989799 | (37.7969444587701, -122.443624999898) | |||
| 29469 | 29469 | 33117 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000101.0018 | 2118475.17057 | 37.7969331372011 | -122.443703383925 | (37.7969331372011, -122.443703383925) | |
| 34521 | 34521 | 33116 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.684859999 | 2118474.07473 | 37.7969291406212 | -122.44376322569299 | (37.7969291406212, -122.443763225693) | |
| 112031 | 112031 | 67622 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1760 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | Permit Number 31207 | 6007850.45930515 | 2118441.04608217 | 37.7972783848242 | -122.416885926914 | (37.7972783848242, -122.416885926914) | ||
| 184119 | 184119 | 128998 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1717 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008298.90003 | 2118387.0949 | 37.797155462209204 | -122.41533038218999 | (37.7971554622092, -122.41533038219) | |||
| 132564 | 132564 | 128999 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1717 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6008297.95397 | 2118364.1247799997 | 37.7970923387857 | -122.41533202886801 | (37.7970923387857, -122.415332028868) | |||
| 146571 | 146571 | 56346 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 615 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1973 12:00:00 AM | 2 | Permit Number 12488 | 6012822.94142 | 2118342.56385 | 37.797286416082 | -122.39967284724199 | (37.797286416082, -122.399672847242) | ||
| 69244 | 69244 | 129000 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1564 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006045.242219999 | 2118309.47605 | 37.796815420436396 | -122.42312308777099 | (37.7968154204364, -122.423123087771) | |||
| 63159 | 63159 | 129001 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1564 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006030.23381 | 2118308.73674 | 37.7968125435181 | -122.423174967846 | (37.7968125435181, -122.423174967846) | |||
| 187718 | 187718 | 129002 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1564 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006007.80394 | 2118305.26867 | 37.7968017552614 | -122.423252333851 | (37.7968017552614, -122.423252333851) | |||
| 165642 | 165642 | 129003 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1564 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005987.25802 | 2118303.85744 | 37.796796720842295 | -122.42332332721399 | (37.7967967208423, -122.423323327214) | |||
| 130432 | 130432 | 59656 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2743 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/1981 12:00:00 AM | 9 | Permit Number 19077 | 5999546.513730001 | 2118294.85744 | 37.796406404279104 | -122.44560906441099 | (37.7964064042791, -122.445609064411) | ||
| 4477 | 4477 | 110155 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1041 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008584.20475 | 2118266.76798 | 37.796841105086706 | -122.414334635748 | (37.7968411050867, -122.414334635748) | |
| 6731 | 6731 | 110156 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1041 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008596.56055 | 2118265.88339 | 37.7968393702849 | -122.41429181903601 | (37.7968393702849, -122.414291819036) | |
| 164154 | 164154 | 128991 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1045 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008570.82974 | 2118264.35585 | 37.7968337306409 | -122.414380745793 | (37.7968337306409, -122.414380745793) | |||
| 5343 | 5343 | 110157 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.41443672767599 | (37.7968272906045, -122.414436727676) | ||
| 1049 | 1049 | 110158 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.41456024686501 | (37.7968116091339, -122.414560246865) | ||
| 49149 | 49149 | 128937 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2613 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004426.80187 | 2118244.37407 | 37.7965452029457 | -122.428718624581 | (37.7965452029457, -122.428718624581) | |||
| 170178 | 170178 | 128880 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2848 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001079.711069999 | 2118186.43072 | 37.7961961059217 | -122.44029610808902 | (37.7961961059217, -122.440296108089) |
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");