trees
3,247 rows where qSpecies_id = 22 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155253 | 129011 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2200 Grant Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010212.84483 | 2122235.52115 | 37.8078296738771 | -122.40897930247 | (37.8078296738771, -122.40897930247) | 3 | 1 | 10 | 308 | 23 | |||
| 129500 | 129010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2200 Grant Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010219.4685 | 2122201.72912 | 37.8077372604315 | -122.408953993726 | (37.8077372604315, -122.408953993726) | 3 | 1 | 10 | 308 | 23 | |||
| 182248 | 129012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010624.52904 | 2121364.46761 | 37.8054610295673 | -122.407493109815 | (37.8054610295673, -122.407493109815) | 3 | 1 | 10 | 308 | 23 | ||||
| 41174 | 129013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.407570525278 | (37.8054503923804, -122.407570525278) | 3 | 1 | 10 | 308 | 23 | ||||
| 186830 | 143214 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 209 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010288.2363 | 2121289.8221 | 37.805237242499 | -122.408651632361 | (37.805237242499, -122.408651632361) | 3 | 1 | 10 | 308 | 23 | |||
| 46385 | 48357 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 271 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 4 | Permit Number 46907 | 6009989.2786 | 2121248.5013 | 37.8051070376269 | -122.40968329882 | (37.8051070376269, -122.40968329882) | 3 | 1 | 10 | 308 | 23 | |
| 164423 | 129008 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2550 Leavenworth St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007462.65437 | 2121216.63674 | 37.804877636656 | -122.418424741625 | (37.804877636656, -122.418424741625) | 5 | 1 | 1 | 308 | 32 | |||
| 40335 | 129007 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2550 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007463.35439 | 2121202.39829 | 37.8048385808931 | -122.418421308908 | (37.8048385808931, -122.418421308908) | 5 | 1 | 1 | 308 | 32 | |||
| 70480 | 129016 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6011815.54331 | 2120971.51121 | 37.8044486600418 | -122.403343759329 | (37.8044486600418, -122.403343759329) | 3 | 1 | 10 | 28860 | 6 | |||
| 138291 | 129015 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6011821.67405 | 2120927.2444 | 37.8043274566138 | -122.403319427258 | (37.8043274566138, -122.403319427258) | 3 | 1 | 10 | 28860 | 6 | |||
| 177036 | 129014 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6011826.76829 | 2120892.13124 | 37.8042313289751 | -122.403299326499 | (37.8042313289751, -122.403299326499) | 3 | 1 | 10 | 28860 | 6 | |||
| 162733 | 55912 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 801 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770168 | 6007877.21664 | 2120606.58742 | 37.8032259237896 | -122.416946850615 | (37.8032259237896, -122.416946850615) | 5 | 1 | 1 | 308 | 32 | |
| 80947 | 33317 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | Permit Number 782769 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.428886594537 | (37.8026433303993, -122.428886594537) | 13 | 9 | 1 | 57 | 17 | |
| 76420 | 33316 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | Permit Number 782769 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346 | (37.8026370063559, -122.42893607346) | 13 | 9 | 1 | 57 | 17 | |
| 35761 | 128888 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1549 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003944.76829 | 2120400.71212 | 37.8024386572819 | -122.430540507163 | (37.8024386572819, -122.430540507163) | 13 | 9 | 1 | 57 | 17 | |||
| 151480 | 143067 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Child St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010601.6848 | 2120393.9506 | 37.8027949508206 | -122.407503698977 | (37.8027949508206, -122.407503698977) | 3 | 1 | 10 | 308 | 23 | |||
| 5352 | 143065 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Child St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010630.6807 | 2120383.8561 | 37.8027688567606 | -122.4074026458 | (37.8027688567606, -122.4074026458) | 3 | 1 | 10 | 308 | 23 | |||
| 141075 | 143068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Child St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010607.1256 | 2120351.0165 | 37.8026773688895 | -122.407481842223 | (37.8026773688895, -122.407481842223) | 3 | 1 | 10 | 308 | 23 | |||
| 72073 | 4694 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 850X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x8 | 6008940.69941 | 2120350.97779 | 37.802583847399 | -122.4132485365 | (37.802583847399, -122.4132485365) | 3 | 1 | 10 | 308 | 23 | |||
| 49416 | 64371 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 470 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 12 | Permit Number 25210 | 6010591.4795 | 2120329.1807 | 37.8026165373925 | -122.407534445483 | (37.8026165373925, -122.407534445483) | 3 | 1 | 10 | 308 | 23 | |
| 79505 | 112131 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 121936 | 112128 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 172055 | 112127 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 174435 | 112129 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 189815 | 112130 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 28464 | 64369 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | 3 | 1 | 10 | 308 | 23 | |
| 136326 | 143070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010344.9622 | 2120299.1083 | 37.8025201643159 | -122.408385400714 | (37.8025201643159, -122.408385400714) | 3 | 1 | 10 | 308 | 23 | |||
| 13295 | 72207 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331 | (37.8025135249949, -122.40843327331) | 3 | 1 | 10 | 308 | 23 | |||
| 75258 | 64372 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 530 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25211 | 6010298.20676285 | 2120293.66367922 | 37.802502596356 | -122.408546814252 | (37.802502596356, -122.408546814252) | 3 | 1 | 10 | 308 | 23 | ||
| 33987 | 64366 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 8 | Permit Number 25205 | 6010278.2434 | 2120287.8996 | 37.802485651571 | -122.408615490868 | (37.802485651571, -122.408615490868) | 3 | 1 | 10 | 308 | 23 | |
| 112580 | 64365 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 7 | Permit Number 25204 | 6010256.8933 | 2120284.6971 | 37.8024756625421 | -122.408689147089 | (37.8024756625421, -122.408689147089) | 3 | 1 | 10 | 308 | 23 | |
| 173439 | 52200 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 558 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2005 12:00:00 AM | 1 | Permit Number 48388 | 6010241.4146 | 2120284.6971 | 37.8024747955984 | -122.408742711308 | (37.8024747955984, -122.408742711308) | 3 | 1 | 10 | 308 | 23 | ||
| 6175 | 143071 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 558 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010223.267 | 2120278.2921 | 37.8024561925927 | -122.408805059144 | (37.8024561925927, -122.408805059144) | 3 | 1 | 10 | 308 | 23 | |||
| 110745 | 64382 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25223 | 6010171.68830219 | 2120276.20924301 | 37.8024475844496 | -122.408983400718 | (37.8024475844496, -122.408983400718) | 3 | 1 | 10 | 308 | 23 | ||
| 20059 | 143064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 568 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010191.242 | 2120275.0896 | 37.8024456055 | -122.408915655908 | (37.8024456055, -122.408915655908) | 3 | 1 | 10 | 308 | 23 | |||
| 52715 | 64363 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 568 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/09/2007 12:00:00 AM | 8 | Permit No. 49276 | 6010205.6533 | 2120275.0896 | 37.8024464127339 | -122.40886578546 | (37.8024464127339, -122.40886578546) | 3 | 1 | 10 | 308 | 23 | |
| 30897 | 64364 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 562 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25203 | 6010163.25374355 | 2120275.04561468 | 37.8024439169341 | -122.409012506441 | (37.8024439169341, -122.409012506441) | 3 | 1 | 10 | 308 | 23 | ||
| 103663 | 64361 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 580 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 8 | Permit Number 25200 | 6010170.4257 | 2120272.4208 | 37.8024371115938 | -122.408987502507 | (37.8024371115938, -122.408987502507) | 3 | 1 | 10 | 308 | 23 | |
| 63597 | 129005 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2620 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006623.13144 | 2120229.16523 | 37.8021189959583 | -122.421259841781 | (37.8021189959583, -122.421259841781) | 5 | 9 | 1 | 28858 | 32 | |||
| 29223 | 65857 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3444 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1990 12:00:00 AM | 2 | 3x3 | Permit Number 49753 | 6000794.66575 | 2120227.32857 | 37.8017836378592 | -122.441428940891 | (37.8017836378592, -122.441428940891) | 13 | 9 | 1 | 57 | 17 | |
| 150333 | 129004 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2620 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006625.29288 | 2120213.21651 | 37.8020753266811 | -122.421251228963 | (37.8020753266811, -122.421251228963) | 5 | 9 | 1 | 28858 | 32 | |||
| 10304 | 71422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009722.2927 | 2120212.6608 | 37.8022479122752 | -122.410534048105 | (37.8022479122752, -122.410534048105) | 3 | 1 | 10 | 308 | 23 | |||
| 155409 | 86818 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3444 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49753 | 6000793 | 2120207 | 37.8017277261212 | -122.441433245596 | (37.8017277261212, -122.441433245596) | 13 | 9 | 1 | 57 | 17 | |||
| 192668 | 46083 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | 3 | 1 | 10 | 308 | 23 | ||
| 41686 | 128909 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1620 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.371 | 2120116.17018 | 37.8016631907718 | -122.430165140031 | (37.8016631907718, -122.430165140031) | 13 | 9 | 1 | 57 | 17 | |||
| 164499 | 86823 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 290 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49766 | 6000913.42352 | 2120028.23652 | 37.8012437487566 | -122.44100369379 | (37.8012437487566, -122.44100369379) | 13 | 9 | 1 | 57 | 17 | |
| 160602 | 250211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 212 Union St | 7 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796 | (37.80121941579, -122.40351603796) | 3 | 1 | 10 | 308 | 23 | |||
| 113138 | 108148 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6003294.68219 | 2119741.92969 | 37.8005929642463 | -122.432743036759 | (37.8005929642463, -122.432743036759) | 13 | 9 | 1 | 57 | 17 | ||||
| 168588 | 108147 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.432733936524 | (37.800534134189, -122.432733936524) | 13 | 9 | 1 | 57 | 17 | ||
| 124381 | 108146 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6003298.685 | 2119704.23273 | 37.800489685219 | -122.432726491033 | (37.800489685219, -122.432726491033) | 13 | 9 | 1 | 57 | 17 | ||||
| 154256 | 44131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2820 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2000 12:00:00 AM | 4 | Permit Number 43633 | 6005248.14777 | 2119695.60909 | 37.8005763744637 | -122.425979944327 | (37.8005763744637, -122.425979944327) | 13 | 9 | 1 | 57 | 17 | ||
| 153997 | 13140 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1785 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1997 12:00:00 AM | 18 | 3X3 | 6003874.8006 | 2119664.6973 | 37.8004137877384 | -122.430730076432 | (37.8004137877384, -122.430730076432) | 13 | 9 | 1 | 57 | 17 | ||
| 181881 | 52195 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1209 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2005 12:00:00 AM | 3 | Permit Number 48386 | 6007084.31165 | 2119457.46133 | 37.8000260811036 | -122.419609149648 | (37.8000260811036, -122.419609149648) | 5 | 1 | 1 | 28858 | 32 | ||
| 93262 | 48589 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1813 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53725 | 6004114.81766 | 2119382.23545 | 37.799651815633 | -122.429879362441 | (37.799651815633, -122.429879362441) | 13 | 9 | 1 | 57 | 17 | |
| 82770 | 68012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1137 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 8 | Permit Number 31742 | 6011522.79537 | 2119247.92417 | 37.7996997558097 | -122.404235461403 | (37.7996997558097, -122.404235461403) | 3 | 1 | 10 | 308 | 23 | ||
| 42849 | 129009 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1137 Montgomery St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6011525.13377 | 2119231.56027 | 37.7996549551749 | -122.404226217291 | (37.7996549551749, -122.404226217291) | 3 | 1 | 10 | 308 | 23 | |||
| 96458 | 107778 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.09266 | 2119225.96368 | 37.7990395913723 | -122.441026839613 | (37.7990395913723, -122.441026839613) | 13 | 9 | 1 | 57 | 17 | |
| 27240 | 68167 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1131 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | 12 | Permit Number 31936 | 6011528.02794 | 2119216.24888 | 37.7996130755308 | -122.404215124131 | (37.7996130755308, -122.404215124131) | 3 | 1 | 10 | 308 | 23 | ||
| 192776 | 107779 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.66944 | 2119210.84486 | 37.7989981119436 | -122.441023758536 | (37.7989981119436, -122.441023758536) | 13 | 9 | 1 | 57 | 17 | |
| 45775 | 107780 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000893.56163 | 2119195.20013 | 37.7989553203824 | -122.441012627647 | (37.7989553203824, -122.441012627647) | 13 | 9 | 1 | 57 | 17 | |
| 56853 | 107781 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000894.3565 | 2119181.32338 | 37.7989172637699 | -122.441008881075 | (37.7989172637699, -122.441008881075) | 13 | 9 | 1 | 57 | 17 | |
| 146080 | 128887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2201 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002313.17726 | 2119132.85269 | 37.7988648845528 | -122.436095829861 | (37.7988648845528, -122.436095829861) | 13 | 9 | 1 | 57 | 17 | |||
| 46277 | 128886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2201 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002294.64841 | 2119130.10879 | 37.7988562978392 | -122.436159749193 | (37.7988562978392, -122.436159749193) | 13 | 9 | 1 | 57 | 17 | |||
| 70289 | 128885 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2201 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002262.59094 | 2119125.25384 | 37.7988411460494 | -122.436270330726 | (37.7988411460494, -122.436270330726) | 13 | 9 | 1 | 57 | 17 | |||
| 31830 | 58810 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.04088 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | 13 | 9 | 1 | 57 | 17 | |
| 141777 | 128884 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1978 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003477.22131 | 2118991.9993 | 37.7985442007084 | -122.432057794742 | (37.7985442007084, -122.432057794742) | 13 | 9 | 1 | 57 | 17 | |||
| 125658 | 63951 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1980 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1987 12:00:00 AM | 6 | Permit Number 24682 | 6003463.5929 | 2118990.37708 | 37.7985389738578 | -122.432104837366 | (37.7985389738578, -122.432104837366) | 13 | 9 | 1 | 57 | 17 | ||
| 88681 | 63950 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1982 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1987 12:00:00 AM | 2 | Permit Number 24681 | 6003447.61154 | 2118987.9571 | 37.7985314231417 | -122.432159964919 | (37.7985314231417, -122.432159964919) | 13 | 9 | 1 | 57 | 17 | ||
| 168435 | 106426 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2919 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770060 | 6003851.7386 | 2118879.76121 | 37.798257249522 | -122.430753834436 | (37.798257249522, -122.430753834436) | 13 | 9 | 1 | 57 | 17 | |
| 42871 | 108698 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) | 13 | 9 | 1 | 57 | 17 |
| 33532 | 44053 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3100 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43582 | 6001974.87365527 | 2118765.4026711 | 37.7978367374605 | -122.437240145023 | (37.7978367374605, -122.437240145023) | 13 | 9 | 1 | 57 | 17 | |||
| 66587 | 112802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 865 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009439.76342 | 2118739.20101 | 37.798186312791 | -122.411407584406 | (37.798186312791, -122.411407584406) | 3 | 1 | 10 | 308 | 4 | |||
| 124196 | 112801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009421.02251 | 2118738.48661 | 37.7981833000696 | -122.411472383257 | (37.7981833000696, -122.411472383257) | 3 | 1 | 10 | 308 | 4 | |||
| 34825 | 129006 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.413210643283 | (37.7977154080083, -122.413210643283) | 3 | 1 | 10 | 308 | 21 | ||||
| 4259 | 33111 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 4x4 | Permit Number 769981 | 6000363.34088 | 2118561.77591 | 37.7971858916671 | -122.442801853125 | (37.7971858916671, -122.442801853125) | 13 | 9 | 1 | 57 | 17 | |
| 86837 | 105352 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2055 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2014 12:00:00 AM | 1 | 3x3 | Permit Number 768583 | 6003162.6 | 2118532.6 | 37.7972649672191 | -122.433113640832 | (37.7972649672191, -122.433113640832) | 13 | 9 | 1 | 57 | 17 | |
| 184074 | 128997 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1189 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007893.47286 | 2118525.78201 | 37.7975134679385 | -122.416743094821 | (37.7975134679385, -122.416743094821) | 5 | 1 | 10 | 28858 | 21 | |||
| 184339 | 128996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1189 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007875.74827 | 2118524.15827 | 37.7975080126282 | -122.416804311666 | (37.7975080126282, -122.416804311666) | 5 | 1 | 10 | 28858 | 21 | |||
| 101940 | 88446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1629 Green St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | 3x3 | Permit Number 51411 | 6005229.98772 | 2118491.64787 | 37.7972695780743 | -122.425957034113 | (37.7972695780743, -122.425957034113) | 13 | 9 | 1 | 57 | 17 | ||
| 47519 | 128908 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000146.67214 | 2118481.01335 | 37.7969517846466 | -122.443545774121 | (37.7969517846466, -122.443545774121) | 13 | 9 | 1 | 57 | 17 | |||
| 98849 | 128907 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000123.7305 | 2118478.82178 | 37.7969444587701 | -122.443624999898 | (37.7969444587701, -122.443624999898) | 13 | 9 | 1 | 57 | 17 | |||
| 50985 | 33117 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000101.0018 | 2118475.17057 | 37.7969331372011 | -122.443703383925 | (37.7969331372011, -122.443703383925) | 13 | 9 | 1 | 57 | 17 | |
| 31468 | 33116 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37353 | 6000083.68486 | 2118474.07473 | 37.7969291406212 | -122.443763225693 | (37.7969291406212, -122.443763225693) | 13 | 9 | 1 | 57 | 17 | |
| 142752 | 67622 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1760 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | Permit Number 31207 | 6007850.45930515 | 2118441.04608217 | 37.7972783848242 | -122.416885926914 | (37.7972783848242, -122.416885926914) | 5 | 1 | 10 | 28858 | 21 | ||
| 171012 | 128998 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1717 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008298.90003 | 2118387.0949 | 37.7971554622092 | -122.41533038219 | (37.7971554622092, -122.41533038219) | 5 | 1 | 10 | 28858 | 21 | |||
| 61463 | 128999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1717 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008297.95397 | 2118364.12478 | 37.7970923387857 | -122.415332028868 | (37.7970923387857, -122.415332028868) | 5 | 1 | 10 | 28858 | 21 | |||
| 134329 | 56346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2017 12:00:00 AM | 3 | Permit Number 12488 | 6012822.94142 | 2118342.56385 | 37.797286416082 | -122.399672847242 | (37.797286416082, -122.399672847242) | 3 | 1 | 10 | 28860 | 6 | ||
| 149528 | 129000 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1564 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006045.24222 | 2118309.47605 | 37.7968154204364 | -122.423123087771 | (37.7968154204364, -122.423123087771) | 13 | 9 | 10 | 28858 | 32 | |||
| 58155 | 129001 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1564 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006030.23381 | 2118308.73674 | 37.7968125435181 | -122.423174967846 | (37.7968125435181, -122.423174967846) | 13 | 9 | 10 | 28858 | 32 | |||
| 138285 | 129002 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1564 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006007.80394 | 2118305.26867 | 37.7968017552614 | -122.423252333851 | (37.7968017552614, -122.423252333851) | 13 | 9 | 10 | 28858 | 32 | |||
| 171433 | 129003 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1564 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005987.25802 | 2118303.85744 | 37.7967967208423 | -122.423323327214 | (37.7967967208423, -122.423323327214) | 13 | 9 | 10 | 28858 | 32 | |||
| 110336 | 59656 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2743 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1981 12:00:00 AM | 9 | Permit Number 19077 | 5999546.51373 | 2118294.85744 | 37.7964064042791 | -122.445609064411 | (37.7964064042791, -122.445609064411) | 13 | 9 | 1 | 57 | 17 | ||
| 177985 | 110155 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008584.20475 | 2118266.76798 | 37.7968411050867 | -122.414334635748 | (37.7968411050867, -122.414334635748) | 5 | 1 | 10 | 308 | 21 | |
| 130087 | 110156 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008596.56055 | 2118265.88339 | 37.7968393702849 | -122.414291819036 | (37.7968393702849, -122.414291819036) | 5 | 1 | 10 | 308 | 21 | |
| 96369 | 128991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008570.82974 | 2118264.35585 | 37.7968337306409 | -122.414380745793 | (37.7968337306409, -122.414380745793) | 5 | 1 | 10 | 308 | 21 | |||
| 142053 | 110157 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.414436727676 | (37.7968272906045, -122.414436727676) | 5 | 1 | 10 | 308 | 21 | ||
| 37837 | 110158 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.414560246865 | (37.7968116091339, -122.414560246865) | 5 | 1 | 10 | 308 | 21 | ||
| 90047 | 128937 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2613 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004426.80187 | 2118244.37407 | 37.7965452029457 | -122.428718624581 | (37.7965452029457, -122.428718624581) | 13 | 9 | 1 | 57 | 17 | |||
| 135625 | 128880 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2848 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001079.71107 | 2118186.43072 | 37.7961961059217 | -122.440296108089 | (37.7961961059217, -122.440296108089) | 13 | 9 | 1 | 57 | 17 | |||
| 1952 | 129457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | 3 | 1 | 10 | 308 | 4 |
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) );