221 rows where Police Districts = 1 and qSpecies_id = 53 sorted by Neighborhoods (old)

View and edit SQL

Police Districts

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) ▼
13581 113413 Undocumented 4 Ficus nitida :: Laurel Fig 53 16X LEROY PL 1 Sidewalk: Curb side : Cutout Tree Private 2     7 1x1   6008359 2116497 37.7919691052865 -122.414988572568 (37.7919691052865, -122.414988572568) 5 1 10 28858 21
20147 103506 Undocumented 4 Ficus nitida :: Laurel Fig 53 1348 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
28662 99265 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
41004 99266 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
47816 107839 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
48551 18500 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 519X Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4X4   6010154.14929 2115557.66128 37.7894906186413 -122.408711019419 (37.7894906186413, -122.408711019419) 5 1 10 28857 21
52775 18497 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6010150.58942 2115513.37022 37.7893688066449 -122.408720210327 (37.7893688066449, -122.408720210327) 5 1 10 28857 21
54854 18511 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 626 Powell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6010143.9604039 2115933.8512359 37.7905229751065 -122.408772822924 (37.7905229751065, -122.408772822924) 5 1 10 28857 21
108315 251688 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 925 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008132 2115128 37.788197407905 -122.415677021756 (37.788197407905, -122.415677021756) 13 1 10 28858 21
131827 99267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
142924 18508 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 605X Powell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010109.02253 2115823.8794949 37.7902190622309 -122.408885944172 (37.7902190622309, -122.408885944172) 5 1 10 28857 21
143675 107836 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
146277 18498 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Powell St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6010152.17541 2115498.44033 37.7893279015823 -122.408713669265 (37.7893279015823, -122.408713669265) 5 1 10 28857 21
151930 18509 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 605X Powell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010109.02253 2115823.8794949 37.7902190622309 -122.408885944172 (37.7902190622309, -122.408885944172) 5 1 10 28857 21
159895 113553 Undocumented 4 Ficus nitida :: Laurel Fig 53 700 TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   3x3   6009263 2115423 37.7890709188275 -122.411784791395 (37.7890709188275, -122.411784791395) 5 1 10 28857 21
159917 122820 Permitted Site 7 Ficus nitida :: Laurel Fig 53 776 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009771.51732552 2115777.23613944 37.7900720800575 -122.410050397484 (37.7900720800575, -122.410050397484) 5 1 10 28857 21
166051 18510 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 605X Powell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6010109.02253 2115823.8794949 37.7902190622309 -122.408885944172 (37.7902190622309, -122.408885944172) 5 1 10 28857 21
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
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
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
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
11874 110985 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
12765 117400 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 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
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
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
18979 110983 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
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
26107 21817 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2683 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008202.62871 2121958.17011 37.8069553278433 -122.4159165161 (37.8069553278433, -122.4159165161) 5 1 10 308 23
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
28833 21815 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2653 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008264.14138 2121978.44796 37.8070144637358 -122.415705074993 (37.8070144637358, -122.415705074993) 5 1 10 308 23
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
35514 110994 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
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
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
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
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
44244 110995 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
53203 110987 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
56447 117399 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 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
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
63395 21810 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2627 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008310.29957 2121825.65474 37.806597526846 -122.415534509856 (37.806597526846, -122.415534509856) 5 1 10 308 23
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
65967 21814 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2653 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008264.14138 2121978.44796 37.8070144637358 -122.415705074993 (37.8070144637358, -122.415705074993) 5 1 10 308 23
67256 110998 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
70668 21818 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2693 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008270.97753 2122039.96134 37.8071837481777 -122.415685775277 (37.8071837481777, -122.415685775277) 5 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
73243 110988 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
73509 21808 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2600X Taylor St 13 Sidewalk: Property side : Cutout Tree DPW 1   03/01/2016 12:00:00 AM 3 4x4   6008553.39113 2121935.04647 37.8069115498008 -122.414700989571 (37.8069115498008, -122.414700989571) 3 1 10 308 23
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
74708 52076 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2005 12:00:00 AM     Permit Number 48272 6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
85015 21812 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2631 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008221.30715 2121822.90168 37.806584965078 -122.415842290697 (37.806584965078, -122.415842290697) 5 1 10 308 23
87782 21807 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2600X Taylor St 12 Sidewalk: Property side : Cutout Tree DPW 1   03/01/2016 12:00:00 AM 3 3X3   6008553.39113 2121935.04647 37.8069115498008 -122.414700989571 (37.8069115498008, -122.414700989571) 3 1 10 308 23
88657 110984 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
89782 4755 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     70 4X4   6007719.65165 2121534.55679 37.8057650284682 -122.417557918763 (37.8057650284682, -122.417557918763) 5 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
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
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
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
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
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
120103 40159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2211 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1999 12:00:00 AM     Permit Number 41353 6009783.18603588 2121626.8328918 37.8061342908169 -122.410423240295 (37.8061342908169, -122.410423240295) 3 1 10 308 23
122892 21816 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2669 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008202.59065 2121958.17011 37.8069553257036 -122.415916647815 (37.8069553257036, -122.415916647815) 5 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
126032 110991 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
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
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
136446 110992 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
138984 110996 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
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
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
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
150414 117403 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
152048 92896 Permitted Site 7 Ficus nitida :: Laurel Fig 53 226 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3   6009506.8 2122067 37.8073273816355 -122.411410840149 (37.8073273816355, -122.411410840149) 3 1 10 308 23
154973 21805 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2600X Taylor St 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2016 12:00:00 AM 3 3X3   6008553.39113 2121935.04647 37.8069115498008 -122.414700989571 (37.8069115498008, -122.414700989571) 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
158673 117398 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 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
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
168710 21809 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2627 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008310.29957 2121825.65474 37.806597526846 -122.415534509856 (37.806597526846, -122.415534509856) 5 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
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
171851 110997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
172294 110990 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
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
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
183563 110986 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
185775 117401 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
190730 110993 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
21080 11033 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1503 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007448.9758793 2117473.8836265 37.7946002066648 -122.418206559463 (37.7946002066648, -122.418206559463) 5 1 10 28858 32
27435 11036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1521 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007446.95336 2117561.22726 37.79483991673 -122.41821975317 (37.79483991673, -122.41821975317) 5 1 10 28858 32
28739 11129 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
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

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