1,626 rows where qSpecies_id = 53 sorted by Zip Codes

View and edit SQL

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
58892 40350 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011468.97735143 2112560.39183232 37.7813343766323 -122.403950824176 (37.7813343766323, -122.403950824176) 6 2 9 28853 34
60538 32649 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
64749 17324 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 5 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
66600 17310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 3 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
66641 32646 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
67792 15158 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 12 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
68900 15165 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 19 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
72154 17321 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 2 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
72411 15256 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 7 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007417.64852 2109947.83449 37.7739337430824 -122.417781236147 (37.7739337430824, -122.417781236147) 8 2 9 28853 19
72688 124729 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
72803 32647 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
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
73524 101763 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 6 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
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
77006 108328 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
78216 148688 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 15 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010825.81515 2110877.63025 37.7766779522549 -122.406057277416 (37.7766779522549, -122.406057277416) 14 2 9 28853 34
79332 124728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
83229 51761 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2005 12:00:00 AM 8   Permit Number 48028 6011451.43524212 2112543.5849209 37.781287248696 -122.404010328515 (37.781287248696, -122.404010328515) 6 2 9 28853 34
83380 40353 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 13 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
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
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
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
90420 124731 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
91800 19370 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06TH ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
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
92451 15169 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 23 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
93090 108326 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 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
97139 15172 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 941 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010497.86985 2112769.44604 37.7818540873698 -122.40732513932 (37.7818540873698, -122.40732513932) 14 2 9 28853 34
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
99112 101762 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 5 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
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
103078 15168 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 22 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
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
104659 124727 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
105308 111809 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
105815 111210 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
108637 27712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
108812 101761 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 4 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
109251 17295 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007087.86369 2109540.24307 37.7727960300261 -122.418893105705 (37.7727960300261, -122.418893105705) 8 2 9 28853 19
109824 17315 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
110518 15161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 15 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)
);