139 rows where Zip Codes = 308 and qSpecies_id = 53 sorted by Location

View and edit SQL

Zip Codes

  • 308 · 139
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)
28305 121625 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
154699 121624 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
55005 112827 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
139551 112828 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
148636 112826 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
186524 112825 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
43430 112751 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
99464 112750 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 4 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
191709 52838 Permitted Site 7 Ficus nitida :: Laurel Fig 53 795on Trenton Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48857 6010309.20673902 2118158.51574656 37.7966406195852 -122.408358059553 (37.7966406195852, -122.408358059553) 3 1 10 308 4
79809 4593 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6011460.12974 2118136.30046 37.7966440043551 -122.404374021953 (37.7966440043551, -122.404374021953) 3 1 10 308 4
44901 4596 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 170 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6011285.22621 2118219.63855 37.7968630551885 -122.404985101368 (37.7968630551885, -122.404985101368) 3 1 10 308 4
47614 4599 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 170 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6011285.22621 2118219.63855 37.7968630551885 -122.404985101368 (37.7968630551885, -122.404985101368) 3 1 10 308 4
150611 4595 Permitted Site 7 Ficus nitida :: Laurel Fig 53 170 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6011285.22621 2118219.63855 37.7968630551885 -122.404985101368 (37.7968630551885, -122.404985101368) 3 1 10 308 4
160977 4597 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 170 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6011285.22621 2118219.63855 37.7968630551885 -122.404985101368 (37.7968630551885, -122.404985101368) 3 1 10 308 4
191099 100527 Undocumented 4 Ficus nitida :: Laurel Fig 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21
99484 116156 Undocumented 4 Ficus nitida :: Laurel Fig 53 755 SANSOME ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012110 2118369 37.7973192357085 -122.402141679915 (37.7973192357085, -122.402141679915) 3 1 10 308 4
28626 100399 Undocumented 4 Ficus nitida :: Laurel Fig 53 900 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 4x4   6011664 2118384 37.7973355180624 -122.403686018548 (37.7973355180624, -122.403686018548) 3 1 10 308 23
138724 19491 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 10X Saroyan Pl 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6010944.42859 2118456.69114 37.7974948878134 -122.406181056735 (37.7974948878134, -122.406181056735) 3 1 10 308 4
162852 19490 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 10X Saroyan Pl 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6010944.42859 2118456.69114 37.7974948878134 -122.406181056735 (37.7974948878134, -122.406181056735) 3 1 10 308 4
101743 98254 Undocumented 4 Ficus nitida :: Laurel Fig 53 571 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010764.4 2118536 37.797702579203 -122.406809598565 (37.797702579203, -122.406809598565) 3 1 10 308 4
23258 4604 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 270 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     26 3x3   6010907.72336 2118541.73775 37.7977263519913 -122.406314062528 (37.7977263519913, -122.406314062528) 3 1 10 308 23
18087 4603 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 270 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6010933.33158 2118545.7793 37.7977388815556 -122.406225735505 (37.7977388815556, -122.406225735505) 3 1 10 308 23
13161 4609 Permitted Site 7 Ficus nitida :: Laurel Fig 53 316 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2015 12:00:00 AM 3 3X3 Permit Number 774670 6010771.0363 2118706.95943 37.7981723635161 -122.406798689949 (37.7981723635161, -122.406798689949) 3 1 10 308 23
71188 4619 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 358 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     32 3x3   6010602.31813 2118839.00805 37.7985254951528 -122.407391821594 (37.7985254951528, -122.407391821594) 3 1 10 308 23
151939 257912 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 690X Vallejo St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010415 2118850 37.7985451903817 -122.408040779349 (37.7985451903817, -122.408040779349) 3 1 10 308 4
193319 257913 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 690X Vallejo St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010415 2118850 37.7985451903817 -122.408040779349 (37.7985451903817, -122.408040779349) 3 1 10 308 4
4699 23132 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 610X Vallejo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/29/1999 12:00:00 AM 3 4x4   6010603.58879 2118945.35218 37.798817561298 -122.407394925794 (37.798817561298, -122.407394925794) 3 1 10 308 23
94426 23139 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 406X Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 6x3   6010454.05392 2118948.49862 37.798817830036 -122.407912589535 (37.798817830036, -122.407912589535) 3 1 10 308 23
21287 23131 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610X Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1999 12:00:00 AM 3 4x4   6010622.64357 2118948.98987 37.7988286159864 -122.407329246317 (37.7988286159864, -122.407329246317) 3 1 10 308 23
35445 253642 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 427 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010361.39347 2118971.94152 37.7988770104459 -122.408234880635 (37.7988770104459, -122.408234880635) 3 1 10 308 4
177573 4627 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 420 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     28 3x3   6010403.3977 2118996.04309 37.7989455393885 -122.408091232197 (37.7989455393885, -122.408091232197) 3 1 10 308 23
52658 4626 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 419 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6010254.83162 2118999.33253 37.7989462519709 -122.408605554576 (37.7989462519709, -122.408605554576) 3 1 10 308 4
20324 4630 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 427 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6010279.42625 2119026.32466 37.7990217431564 -122.408522353672 (37.7990217431564, -122.408522353672) 3 1 10 308 4
170847 4631 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 430 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6010350.91598 2119042.69079 37.799070683936 -122.408276129064 (37.799070683936, -122.408276129064) 3 1 10 308 23
88644 4629 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 427 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     22 3x3   6010259.97829 2119047.3818 37.7990784717377 -122.408591136664 (37.7990784717377, -122.408591136664) 3 1 10 308 4
90288 9941 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 5x6 Resulted descion 9/7/16 -DE 6010050.95997 2119172.47111 37.7994102279433 -122.409323246083 (37.7994102279433, -122.409323246083) 3 1 10 308 4
13713 9943 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601X Green St 3 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x5   6010129.67767 2119173.05666 37.7994162456962 -122.409050895178 (37.7994162456962, -122.409050895178) 3 1 10 308 4
93249 9942 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601X Green St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x5   6010129.67767 2119173.05666 37.7994162456962 -122.409050895178 (37.7994162456962, -122.409050895178) 3 1 10 308 4
104635 9944 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 4 Sidewalk: Curb side : Cutout Tree Private 2     80 3X3   6010102.57699 2119179.92896 37.7994335971632 -122.409145158717 (37.7994335971632, -122.409145158717) 3 1 10 308 4
59611 106127 Undocumented 4 Ficus nitida :: Laurel Fig 53 1609 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6009609.6 2119208.8 37.7994852403002 -122.410853080764 (37.7994852403002, -122.410853080764) 3 1 10 308 4
151684 4640 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   6010023.44398 2119255.15348 37.7996357117478 -122.409424299905 (37.7996357117478, -122.409424299905) 3 1 10 308 4
84456 254739 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009970 2119286 37.7997174141149 -122.409611414659 (37.7997174141149, -122.409611414659) 3 1 10 308 4
77953 4657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 599X Columbus Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     75 3x3   6009795.85928 2119479.51144 37.8002389893085 -122.41022767808 (37.8002389893085, -122.41022767808) 3 1 10 308 4
119311 4652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 599X Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     22 3x3   6009795.85928 2119479.51144 37.8002389893085 -122.41022767808 (37.8002389893085, -122.41022767808) 3 1 10 308 4
143163 4654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 599X Columbus Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     19 3x3   6009795.85928 2119479.51144 37.8002389893085 -122.41022767808 (37.8002389893085, -122.41022767808) 3 1 10 308 4
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32
103171 4672 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 659 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6009562.16476 2119705.53614 37.8008464951643 -122.411052329729 (37.8008464951643, -122.411052329729) 3 1 10 308 4
37409 112110 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
52578 112111 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
83502 112109 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
126231 112107 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
145725 112106 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
184105 112108 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
74171 110682 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 370 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 6x4   6011146.7308 2119712.42854 37.8009541508763 -122.405569522927 (37.8009541508763, -122.405569522927) 3 1 10 308 23
140945 4683 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 707 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6009355.02929 2119856.39151 37.8012490888204 -122.41177977375 (37.8012490888204, -122.41177977375) 3 1 10 308 4
122874 94039 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 722 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6009288 2119899 37.801362320674 -122.412014738208 (37.801362320674, -122.412014738208) 3 1 10 308 4
127504 4686 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 722 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6009336.3456 2120034.69791 37.8017376257964 -122.411857034683 (37.8017376257964, -122.411857034683) 3 1 10 308 23
96003 4693 Permitted Site 7 Ficus nitida :: Laurel Fig 53 781 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6009263.30605 2120079.28345 37.801855948749 -122.412112938993 (37.801855948749, -122.412112938993) 3 1 10 308 23
177916 113574 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
41372 95268 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
168362 95269 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
73387 113573 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007813 2120272 37.8023036186348 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
179087 105657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
36315 4701 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 841 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6008961.46783 2120321.2947 37.8025035109944 -122.41317456692 (37.8025035109944, -122.41317456692) 3 1 10 308 23
79373 29910 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 791x Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12     6008575.10006 2120353.42874 37.8025700449008 -122.414513871045 (37.8025700449008, -122.414513871045) 3 1 10 308 32
14581 4695 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 850X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     125 4x8   6008940.69941 2120350.97779 37.802583847399 -122.4132485365 (37.802583847399, -122.4132485365) 3 1 10 308 23
124571 98660 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 701X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6008942.64461 2120384.58796 37.8026762417443 -122.41324418324 (37.8026762417443, -122.41324418324) 3 1 10 308 23
11284 117186 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
52074 117185 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
182781 117184 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
126620 13077 Permitted Site 7 Ficus nitida :: Laurel Fig 53 645X Lombard St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
128036 4704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 940 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008705.2823 2120549.3769 37.8031153821632 -122.414077244448 (37.8031153821632, -122.414077244448) 3 1 10 308 23
155532 13054 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 562 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     32 3x3   6009643.06131 2120540.81886 37.80314451067 -122.41083141813 (37.80314451067, -122.41083141813) 3 1 10 308 23
65947 103484 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 9x6   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
100883 103485 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 9x9   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
64595 20258 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 495X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 8x8   6009991.46116 2120547.45752 37.8031822677113 -122.409626234652 (37.8031822677113, -122.409626234652) 3 1 10 308 23
54052 4709 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 968 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/13/2016 07:32:00 AM 3 5x5   6008598.66291 2120633.4675 37.8033402849031 -122.414452158528 (37.8033402849031, -122.414452158528) 3 1 10 308 23
175894 13036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 490 Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/04/2015 08:35:00 AM 3 3X3   6010019.32094 2120615.54911 37.80337079145 -122.409534633266 (37.80337079145, -122.409534633266) 3 1 10 308 23
113684 13012 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 400 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     125 3X3   6010380.84909 2120676.56867 37.8035585868989 -122.408287852113 (37.8035585868989, -122.408287852113) 3 1 10 308 23
61232 12996 Permitted Site 7 Ficus nitida :: Laurel Fig 53 340 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6010677.76597 2120690.63206 37.8036138232581 -122.407261344489 (37.8036138232581, -122.407261344489) 3 1 10 308 23
147035 13023 Permitted Site 7 Ficus nitida :: Laurel Fig 53 440 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2015 08:29:00 AM 3 4X4   6010228.79362 2120718.91833 37.8036663528767 -122.408817039093 (37.8036663528767, -122.408817039093) 3 1 10 308 23
37194 4729 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1075 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008196.257 2120907.29394 37.8040695291651 -122.41586410452 (37.8040695291651, -122.41586410452) 5 1 10 308 32
57727 4728 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1075 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008196.257 2120907.29394 37.8040695291651 -122.41586410452 (37.8040695291651, -122.41586410452) 5 1 10 308 32
34305 102625 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6010349.4 2120908.5 37.804193651889 -122.408413053021 (37.804193651889, -122.408413053021) 3 1 10 308 23
103458 59152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/1980 12:00:00 AM 12 3x3 Permit Number 18461 6009909.46799044 2121095.5996991 37.8046827351828 -122.409948693589 (37.8046827351828, -122.409948693589) 3 1 10 308 23
38641 102621 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
118093 102618 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
142193 102620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
163667 102619 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
31137 4747 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1199X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     22 3X4   6007816.30894 2121179.41413 37.8047953349468 -122.417198239329 (37.8047953349468, -122.417198239329) 5 1 1 308 32
138529 4746 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1199X Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X4   6007816.30894 2121179.41413 37.8047953349468 -122.417198239329 (37.8047953349468, -122.417198239329) 5 1 1 308 32
145382 56574 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100x Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2     14     6010338.9406 2121168.3232 37.8049064763082 -122.408467587357 (37.8049064763082, -122.408467587357) 3 1 10 308 23
170611 104729 Undocumented 4 Ficus nitida :: Laurel Fig 53 250-252 FRANCISCO ST   Sidewalk: Curb side : Cutout Tree Private 2     22 5x5   6010061.3 2121325.4 37.805322217951 -122.409439489572 (37.805322217951, -122.409439489572) 3 1 10 308 23
117475 97938 Undocumented 4 Ficus nitida :: Laurel Fig 53 2133 Stockton St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009831.3 2121360.2 37.8054048804892 -122.410237896013 (37.8054048804892, -122.410237896013) 3 1 10 308 23
58111 258045 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
150358 258047 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
168220 258046 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
37710 4753 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 4X4   6007719.65165 2121534.55679 37.8057650284682 -122.417557918763 (37.8057650284682, -122.417557918763) 5 1 10 308 23
39012 4754 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 4X4   6007719.65165 2121534.55679 37.8057650284682 -122.417557918763 (37.8057650284682, -122.417557918763) 5 1 10 308 23

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);