trees

1,626 rows where qSpecies_id = 53 sorted by Fire Prevention Districts descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts ▲ Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
33092 92818 Permitted Site 7 Ficus nitida :: Laurel Fig 53 95 Burlwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2009 12:00:00 AM   3x3 Permit Number 53027 5996883 2096019 37.7350901820695 -122.453216393363 (37.7350901820695, -122.453216393363) 9 7 4 59 40
34686 101290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 830 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769326 6001055.4 2088979.9 37.7160006775821 -122.438286819162 (37.7160006775821, -122.438286819162) 9 7 6 28861 5
57261 111200 Undocumented 4 Ficus nitida :: Laurel Fig 53 801x CAYUGA AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001252 2092235 37.7249496290087 -122.437840285791 (37.7249496290087, -122.437840285791) 9 7 6 28861 25
77697 26275 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1770 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 1X1   6000824.4471487 2093863.5491185 37.7293969298827 -122.439434969516 (37.7293969298827, -122.439434969516) 9 7 6 28861 25
112578 112394 Undocumented 4 Ficus nitida :: Laurel Fig 53 2 AMAZON AVE   Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6000472 2089324 37.7169122992795 -122.440327982322 (37.7169122992795, -122.440327982322) 9 7 6 28861 5
130776 25271 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1800 Ocean Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   5994503.82801 2092400.83619 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839) 9 8 4 28861 40
137544 25272 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1800 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   5994503.82801 2092400.83619 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839) 9 8 4 28861 40
145671 15751 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4621 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6002118.32394 2091946.54904 37.7242068323306 -122.434824887315 (37.7242068323306, -122.434824887315) 9 7 6 28861 5
146767 119279 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
148900 57604 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Hearst Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1976 12:00:00 AM   3x3 Permit Number 16491 5999828.22001193 2094390.77346711 37.7307878188175 -122.442916855234 (37.7307878188175, -122.442916855234) 9 7 4 63 40
150275 28300 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Broad St 2 Sidewalk: Curb side : Cutout Tree DPW 1     13 3X3   5995887 2088090 37.713261901345 -122.456086835381 (37.713261901345, -122.456086835381) 9 8 6 28861 24
151589 25270 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1800 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 2X2   5994503.82801 2092400.83619 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839) 9 8 4 28861 40
168485 25273 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1800 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   5994503.82801 2092400.83619 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839) 9 8 4 28861 40
178024 173876 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009764 2087931 37.7136120890563 -122.408111727364 (37.7136120890563, -122.408111727364) 9 7 8 309 39
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
7359 121255 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
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
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
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
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
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
24579 96732 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
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
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
32730 5389 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004827.24095 2106401.30238 37.7640497043733 -122.426489313449 (37.7640497043733, -122.426489313449) 8 4 5 28859 3
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
35179 95222 Undocumented 4 Ficus nitida :: Laurel Fig 53 299 on 16th St Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
35952 120884 Undocumented 4 Ficus nitida :: Laurel Fig 53 2140x 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011295 2105636 37.7623118602886 -122.404065249735 (37.7623118602886, -122.404065249735) 8 3 8 28856 29
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
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
43367 116602 Undocumented 4 Ficus nitida :: Laurel Fig 53 3260x 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 9x9   6005124 2106632 37.764699916645 -122.425479329399 (37.764699916645, -122.425479329399) 8 4 5 28859 19
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
44451 96734 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
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
48272 95217 Undocumented 4 Ficus nitida :: Laurel Fig 53 135 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005910 2106464 37.7642830068396 -122.422748818687 (37.7642830068396, -122.422748818687) 8 4 5 28859 19
50489 18364 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 598 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6010361.2141646 2105516.7578044 37.7619322307219 -122.407286474232 (37.7619322307219, -122.407286474232) 8 4 8 28859 19
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
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
53748 110363 Undocumented 4 Ficus nitida :: Laurel Fig 53 1899x MARIPOSA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011823 2106021 37.7633984709679 -122.402266155018 (37.7633984709679, -122.402266155018) 8 3 8 28856 29
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
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
57818 111388 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 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
58860 111391 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
59221 48449 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1971 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2002 12:00:00 AM     Permit Number 45821 6004348.70626507 2107156.39257844 37.7660959373339 -122.428198241647 (37.7660959373339, -122.428198241647) 8 4 5 28862 3
60087 86905 Permitted Site 7 Ficus nitida :: Laurel Fig 53 36 Camp St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2007 12:00:00 AM   3x3 Permit Number 49869 6005775 2106383 37.7640529822515 -122.423209987967 (37.7640529822515, -122.423209987967) 8 4 5 28859 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
62309 111394 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 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
70053 15430 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2125 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6006871.65728 2105982.3734 37.7630147835921 -122.419388541195 (37.7630147835921, -122.419388541195) 8 4 7 28859 19
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
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
73104 5386 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 4 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 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
73677 18366 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6010418.5901612 2105518.9759028 37.7619415321313 -122.407088188566 (37.7619415321313, -122.407088188566) 8 4 8 28859 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
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
78654 96735 Undocumented 4 Ficus nitida :: Laurel Fig 53 520 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007401.6 2106571.6 37.7646624959011 -122.417597409955 (37.7646624959011, -122.417597409955) 8 4 7 28859 19
78708 120673 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3876 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780.8 2105549.3 37.761651098806 -122.430047862208 (37.761651098806, -122.430047862208) 8 4 5 28862 3
79996 96733 Undocumented 4 Ficus nitida :: Laurel Fig 53 514 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3.5   6007319.4 2106562.9 37.7646339820142 -122.417881101898 (37.7646339820142, -122.417881101898) 8 4 7 28859 19
80775 15434 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2137 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006871.30054 2105936.92899 37.7628899837695 -122.419386550959 (37.7628899837695, -122.419386550959) 8 4 7 28859 19
81846 61476 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1942 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1984 12:00:00 AM 20 4x3 Permit Number 21419 6004543.5 2107230.3 37.7663098890238 -122.427529754413 (37.7663098890238, -122.427529754413) 8 4 5 28862 3
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
87381 5388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004825.95108 2106424.13775 37.7641123319355 -122.426495400824 (37.7641123319355, -122.426495400824) 8 4 5 28859 3
87589 121254 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
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
90745 18351 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 469 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   6010382.7073264 2106125.7302845 37.7636055342277 -122.407255067708 (37.7636055342277, -122.407255067708) 8 4 8 28859 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
93022 5387 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 5 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
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
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
99259 111393 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 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
103761 121256 Undocumented 4 Ficus nitida :: Laurel Fig 53 283 Dorland St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003780 2105549 37.7616502297697 -122.430050607682 (37.7616502297697, -122.430050607682) 8 4 5 28862 3
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
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

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