200 rows where Zip Codes = 28853 and qSpecies_id = 53 sorted by Supervisor Districts

View and edit SQL

Zip Codes

  • 28853 · 200
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)
24151 96336 Undocumented 4 Ficus nitida :: Laurel Fig 53 1851 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005204.9 2107156.8 37.7661454629436 -122.42523686393 (37.7661454629436, -122.42523686393) 8 4 5 28853 19
29857 57300 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3178 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM 14 3x3 Permit Number 16122 6005671.4432239 2106688.52693537 37.7648860421109 -122.423589884437 (37.7648860421109, -122.423589884437) 8 4 5 28853 19
56472 96337 Undocumented 4 Ficus nitida :: Laurel Fig 53 1851 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005204.9 2107156.8 37.7661454629436 -122.42523686393 (37.7661454629436, -122.42523686393) 8 4 5 28853 19
61233 28383 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6006047.68288 2107930.23885 37.7683167183705 -122.422376798825 (37.7683167183705, -122.422376798825) 8 4 5 28853 19
83519 57298 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3120 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM 20 5x5 Permit Number 16120 6006015.66145192 2106707.62529636 37.7649579052871 -122.422400676647 (37.7649579052871, -122.422400676647) 8 4 5 28853 19
132426 95220 Undocumented 4 Ficus nitida :: Laurel Fig 53 3208 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005461 2106663 37.7648040703693 -122.424315938973 (37.7648040703693, -122.424315938973) 8 4 5 28853 19
143541 28384 Permitted Site 7 Ficus nitida :: Laurel Fig 53 286 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     18     6006047.68288 2107930.23885 37.7683167183705 -122.422376798825 (37.7683167183705, -122.422376798825) 8 4 5 28853 19
177897 100470 Undocumented 4 Ficus nitida :: Laurel Fig 53 5X Pearl St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005567.3 2108720.4 37.7704592014806 -122.424094599295 (37.7704592014806, -122.424094599295) 8 2 5 28853 19
8209 103628 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
89426 65007 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1849 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/1989 12:00:00 AM 18 3x3 Permit Number 26048 6008683.18209706 2107760.52572873 37.7679990416006 -122.413248823154 (37.7679990416006, -122.413248823154) 8 4 7 28853 19
92126 103631 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
95503 103635 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 8 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
103831 58284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1528 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/1978 12:00:00 AM   4x4 Permit Number 17298 6007189.64621742 2107366.09742219 37.7668320707182 -122.418386841574 (37.7668320707182, -122.418386841574) 8 4 7 28853 19
112964 103629 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
117580 100483 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
120567 103630 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
122861 103633 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
133574 100482 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
136552 103634 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
146667 15335 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1720 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6006691.81678 2108397.85831 37.7696370050813 -122.420181988192 (37.7696370050813, -122.420181988192) 8 4 7 28853 19
148177 100480 Undocumented 4 Ficus nitida :: Laurel Fig 53 245 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6007080 2107899 37.7682891227663 -122.418803888241 (37.7682891227663, -122.418803888241) 8 4 7 28853 19
150296 100481 Undocumented 4 Ficus nitida :: Laurel Fig 53 1849 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 26048 6008683 2107773 37.7680332828269 -122.413250335235 (37.7680332828269, -122.413250335235) 8 4 7 28853 19
160281 103637 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 10 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
164853 103632 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
166088 103636 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 9 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
20262 253597 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010453 2107072 37.7662077096315 -122.407078650031 (37.7662077096315, -122.407078650031) 8 4 8 28853 19
28577 18320 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 206 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6010262.2750436 2107350.6845554 37.7669622387245 -122.40775798639 (37.7669622387245, -122.40775798639) 8 4 8 28853 19
33185 18322 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 226 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6010268.7839855 2107259.8540962 37.7667132034185 -122.407729067657 (37.7667132034185, -122.407729067657) 8 4 8 28853 19
37186 112411 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
43596 112404 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
47161 18304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010232.4387225 2107842.1672579 37.7683100673499 -122.407895847634 (37.7683100673499, -122.407895847634) 8 4 8 28853 19
55250 112408 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
72828 18316 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 199 POTRERO AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010430 2107503 37.7673898501442 -122.407188587519 (37.7673898501442, -122.407188587519) 8 4 8 28853 19
75232 18306 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010232.4387225 2107842.1672579 37.7683100673499 -122.407895847634 (37.7683100673499, -122.407895847634) 8 4 8 28853 19
86618 111873 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
86959 111872 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
89256 111871 Undocumented 4 Ficus nitida :: Laurel Fig 53 300X POTRERO AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010207 2106863 37.7656200738156 -122.407914780785 (37.7656200738156, -122.407914780785) 8 4 8 28853 19
98753 18298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 35X Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6010274.737783 2108072.9305947 37.7689460585554 -122.407765812226 (37.7689460585554, -122.407765812226) 8 4 8 28853 19
101356 18317 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 199 POTRERO AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010430 2107503 37.7673898501442 -122.407188587519 (37.7673898501442, -122.407188587519) 8 4 8 28853 19
120051 112410 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
130193 112406 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
139216 18329 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 8 4 8 28853 19
141499 18310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 140 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010243.055587 2107664.3185897 37.7678223300533 -122.407846582122 (37.7678223300533, -122.407846582122) 8 4 8 28853 19
145639 112403 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
148347 18327 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X2   6010329.0895487 2107117.8320658 37.7663266190773 -122.407510465965 (37.7663266190773, -122.407510465965) 8 4 8 28853 19
152094 18326 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010329.0895487 2107117.8320658 37.7663266190773 -122.407510465965 (37.7663266190773, -122.407510465965) 8 4 8 28853 19
153176 112405 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
166186 112407 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
168880 112409 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
170902 18297 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 35X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6010274.737783 2108072.9305947 37.7689460585554 -122.407765812226 (37.7689460585554, -122.407765812226) 8 4 8 28853 19
183113 18328 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 269 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 8 4 8 28853 19
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
371 251215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
770 111807 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
5722 255886 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
6188 111792 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
8874 15149 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
16987 17305 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
19070 15154 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 8 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
19705 95415 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
20034 255882 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
20552 15171 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 941 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010472.08374 2112774.72891 37.7818671496492 -122.407414720255 (37.7818671496492, -122.407414720255) 14 2 9 28853 34
24140 32644 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
24565 10586 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Harrison St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     75 3X3   6011036.2882597 2110765.2479161 37.7763811461579 -122.405321269139 (37.7763811461579, -122.405321269139) 14 2 9 28853 34
24912 32645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
26170 124732 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
26375 111795 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 12 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
27252 17296 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007104.29527 2109558.64203 37.7728474744005 -122.418837572 (37.7728474744005, -122.418837572) 8 2 9 28853 19
27832 15155 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
28163 10573 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1     65 4x4   6011301.87316 2111047.97507 37.7771722946398 -122.404422436991 (37.7771722946398, -122.404422436991) 14 2 9 28853 34
31550 15160 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 14 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
32017 116771 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 590X NATOMA ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6009883 2111689 37.7788530052944 -122.409376039999 (37.7788530052944, -122.409376039999) 14 2 9 28853 34
32372 111797 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 14 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
34758 15261 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
34792 15148 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
36076 111627 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
36280 110558 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection 6007165.9 2109609 37.7729892139286 -122.418628045346 (37.7729892139286, -122.418628045346) 8 2 9 28853 19
38468 111626 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
38782 101759 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
39348 97611 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
39622 15164 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 18 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
40269 25702 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 06th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6012081.78675 2110335.7627 37.7752602760543 -122.401674380603 (37.7752602760543, -122.401674380603) 14 2 9 28853 34
40345 17320 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
41708 251371 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390 06th St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
42234 25701 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 06th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6012066.85402 2110350.08491 37.7752987682674 -122.40172704355 (37.7752987682674, -122.40172704355) 14 2 9 28853 34
43589 15250 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007716.15968 2110227.06056 37.7747172257492 -122.416768419302 (37.7747172257492, -122.416768419302) 8 2 9 28853 34
45235 15147 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
47908 101764 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
51241 15259 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6007494.54134 2110025.11497 37.7741502637452 -122.417520728591 (37.7741502637452, -122.417520728591) 8 2 9 28853 19
51739 19375 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06th St 6 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
51840 15324 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1698X Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006725.5802 2108585.93757 37.7701553284346 -122.420078550817 (37.7701553284346, -122.420078550817) 8 4 9 28853 19
52966 66275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1065 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1990 12:00:00 AM   3x3 Permit Number 768678 6007678.31560988 2109516.6646006 37.7727645184447 -122.416848989215 (37.7727645184447, -122.416848989215) 8 2 9 28853 19
54470 101758 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
54802 17309 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
55646 111811 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
55801 15251 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007694.41094 2110207.30516 37.7746617588291 -122.416842252889 (37.7746617588291, -122.416842252889) 8 2 9 28853 34
57879 101766 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
58538 15152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34

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