trees

963 rows where qCaretaker_id = 2 and qSpecies_id = 53 sorted by qLegalStatus_id

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 963 ✖
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)
349 253694 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 536 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 7 9 11 28852 10
2723 140583 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 FILLMORE ST 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003424.6737 2111485.9504 37.7779315149131 -122.431703431668 (37.7779315149131, -122.431703431668) 15 9 11 29492 41
2956 139431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005398.6042 2111220.8061 37.7773151849796 -122.424856035409 (37.7773151849796, -122.424856035409) 7 9 11 28852 10
3916 261241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
5715 140049 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 651 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6005353.1353 2111583.6293 37.778308840554 -122.42503914867 (37.778308840554, -122.42503914867) 7 9 11 28852 10
6288 254356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 3 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
6753 140065 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 612 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005425.1416 2111379.12 37.7777513751906 -122.424775499228 (37.7777513751906, -122.424775499228) 7 9 11 28852 10
7207 249360 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008338.71076 2114562.35621 37.7866559051821 -122.41492178511 (37.7866559051821, -122.41492178511) 13 1 9 28858 36
9010 253870 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW       Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection                    
11231 57646 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 666 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1981 12:00:00 AM 16 7x7 Permit Number 19439 6005402.5793 2111576.4092 37.7782918087921 -122.424867589608 (37.7782918087921, -122.424867589608) 7 9 11 28852 10
11744 56147 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2311 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/21/1973 12:00:00 AM 16   Permit Number 12254 6001277.58181 2116437.20889 37.7914044631939 -122.439485981699 (37.7914044631939, -122.439485981699) 13 6 1 29490 27
12223 59958 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 515 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 17   Permit Number 19435 6005418.82 2111104.349 37.7769965639956 -122.424777815426 (37.7769965639956, -122.424777815426) 7 9 11 28852 10
12493 140066 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 614 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005423.0428 2111393.287 37.7777901557735 -122.424783767818 (37.7777901557735, -122.424783767818) 7 9 11 28852 10
13231 248334 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1569 Waller St 1 Sidewalk: Property side : Cutout Tree Private 2     0 Width 0ft   5998104.0324 2108202.8007 37.7686138007777 -122.449872650062 (37.7686138007777, -122.449872650062) 15 5 11 29492 9
15312 59957 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 12   Permit Number 19434 6005396.005 2111241.6 37.7773721331465 -122.424866506623 (37.7773721331465, -122.424866506623) 7 9 11 28852 10
15375 57511 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 636 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1976 12:00:00 AM 17   Permit Number 16364 6005408.351 2111510.821 37.7781120456222 -122.424842955768 (37.7781120456222, -122.424842955768) 7 9 11 28852 10
15896 140067 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 616 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005420.4192 2111411.6517 37.7778404325738 -122.424794150591 (37.7778404325738, -122.424794150591) 7 9 11 28852 10
16842 261242 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 840 El Camino Del Mar 2 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2020 12:00:00 AM 3 Width 4ft   5985843 2115056 37.786721565729 -122.492786794237 (37.786721565729, -122.492786794237) 11 6 1 55 33
16922 59787 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1755 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1981 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585) 13 9 1 57 17
17302 59963 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 523 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 15   Permit Number 19442 6005413.5665 2111133.9591 37.777077569392 -122.424798095948 (37.777077569392, -122.424798095948) 7 9 11 28852 10
17892 254355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW                            
18271 139433 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005406.0306 2111183.3028 37.7772126295238 -122.424827676313 (37.7772126295238, -122.424827676313) 7 9 11 28852 10
18607 139432 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005403.0601 2111196.299 37.77724814614 -122.424838877048 (37.77724814614, -122.424838877048) 7 9 11 28852 10
19484 77283 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1210 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6001986.2323 2110871.5472 37.7761628769629 -122.436635509753 (37.7761628769629, -122.436635509753) 15 5 11 29492 10
23596 105340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1401 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2014 12:00:00 AM 12   Permit Number 770950 6000144.5 2113810 37.7841262805256 -122.443217635242 (37.7841262805256, -122.443217635242) 15 6 11 29490 31
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
26376 107654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
34974 253521 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2626 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6006643 2120264 37.8022157634914 -122.42119356192 (37.8022157634914, -122.42119356192) 5 1 1 28858 32
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
39288 116011 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1448 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2016 12:00:00 AM 3     6000920 2110390.8 37.7747822166773 -122.440289401956 (37.7747822166773, -122.440289401956) 15 5 11 29492 10
40868 173774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2239 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002625 2107043 37.7656869095489 -122.434152085943 (37.7656869095489, -122.434152085943) 15 5 5 28862 3
42506 121635 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 506 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2017 12:00:00 AM 3 3x3   5992560 2111978 37.7786607112968 -122.469323657797 (37.7786607112968, -122.469323657797) 11 6 2 54 11
46064 106808 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 10 LOYOLA TER 2 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 772884 5998469.3 2110801.2 37.7757692329232 -122.448796407891 (37.7757692329232, -122.448796407891) 15 6 2 29492 16
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
48975 21630 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1615 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1990 12:00:00 AM 6 4X4   6004701.1521 2114671.0024 37.786749150585 -122.427514608894 (37.786749150585, -122.427514608894) 13 9 11 28858 13
51694 173776 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 89 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001439 2105287 37.7607979807122 -122.438128392537 (37.7607979807122, -122.438128392537) 15 4 5 28862 3
59694 127215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 4 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999937.99418 2117121.61309 37.7932073277938 -122.44417011406 (37.7932073277938, -122.44417011406) 13 9 1 57 27
61629 117600 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 565 39TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5983700 2111975 37.7781364952795 -122.499973114435 (37.7781364952795, -122.499973114435) 11 6 2 55 26
66858 173948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1300 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999106 2105162 37.7603218028196 -122.446188178838 (37.7603218028196, -122.446188178838) 15 5 5 28862 3
70074 173891 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 24 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007185 2099410 37.7449861923813 -122.417838888286 (37.7449861923813, -122.417838888286) 2 7 7 28859 2
71007 116518 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 480 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2016 12:00:00 AM 3 9x6   6003703 2109976 37.7738013362642 -122.430632829648 (37.7738013362642, -122.430632829648) 7 9 11 29492 10
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
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
75176 173949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1306 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999102 2105133 37.7602419475954 -122.446199926833 (37.7602419475954, -122.446199926833) 15 5 5 28862 3
76207 127218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 7 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999923.49955 2117118.25276 37.7931972742965 -122.44422002466 (37.7931972742965, -122.44422002466) 13 9 1 57 27
77904 56931 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1909 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 17   Permit Number 14175 6004317.92538 2118019.69798 37.795922137343 -122.429079333669 (37.795922137343, -122.429079333669) 13 9 1 28858 27
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
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
93895 173772 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2235 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002649 2107045 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237) 15 5 5 28862 3
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
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
109441 127217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 6 Front Yard : Yard Tree Private 2     7 Width 4ft Permit Number 782825 5999928.92975 2117120.95639 37.7932050075467 -122.444201430254 (37.7932050075467, -122.444201430254) 13 9 1 57 27
111411 253520 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2626 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6006643 2120264 37.8022157634914 -122.42119356192 (37.8022157634914, -122.42119356192) 5 1 1 28858 32
115288 107652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
116014 107653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
116714 59226 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 530 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 779363 5992552.44717 2111818.61025 37.7782226338783 -122.469338181035 (37.7782226338783, -122.469338181035) 11 6 2 54 11
119084 173642 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 657 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012793 2114089 37.7856054636163 -122.399477673173 (37.7856054636163, -122.399477673173) 6 2 9 28853 6
122122 127204 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 46 Presidio Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 4ft Permit Number 781066 5998981 2116428 37.7912482078936 -122.447431413946 (37.7912482078936, -122.447431413946) 13 6 1 29490 31
123903 173773 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2235 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002649 2107045 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237) 15 5 5 28862 3
126346 148685 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 12 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010843.84821 2110857.5872 37.776623927287 -122.405993483135 (37.776623927287, -122.405993483135) 14 2 9 28853 34
127664 499 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2751 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2017 12:00:00 AM 3 4x4 Permit Number 780031 6010232.5569 2102206.4482 37.7528356605554 -122.407498057365 (37.7528356605554, -122.407498057365) 2 4 7 28859 19
129746 117649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 82 ROSSI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   5996392 2111672 37.778041211542 -122.456045238979 (37.778041211542, -122.456045238979) 11 6 2 54 16
131361 21679 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1809 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003858.3353 2114554.3239 37.7863810745889 -122.430422226637 (37.7863810745889, -122.430422226637) 13 9 11 29490 13
132056 116509 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500x Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
135837 124730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division 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
140006 173777 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 89 Eureka St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001439 2105287 37.7607979807122 -122.438128392537 (37.7607979807122, -122.438128392537) 15 4 5 28862 3
144703 220211 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1399 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 7ft   6005241 2100194 37.747029282671 -122.424616654405 (37.747029282671, -122.424616654405) 2 7 5 28859 22
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
145761 173892 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 24 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007185 2099410 37.7449861923813 -122.417838888286 (37.7449861923813, -122.417838888286) 2 7 7 28859 2
147341 127216 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 5 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999932.8876 2117120.87416 37.7932050075595 -122.444187729973 (37.7932050075595, -122.444187729973) 13 9 1 57 27
150160 148684 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 11 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010855.51157 2110848.16765 37.7765987157057 -122.405952472245 (37.7765987157057, -122.405952472245) 14 2 9 28853 34
154414 148689 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 16 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010821.9718 2110882.95558 37.7766923594104 -122.406070948019 (37.7766923594104, -122.406070948019) 14 2 9 28853 34
158763 111774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 215 CLAYTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5998260 2109886 37.7732443583423 -122.449454468346 (37.7732443583423, -122.449454468346) 15 5 11 29492 16
158811 225015 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 157 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780170 6002699.82559 2104972.04176 37.7600048066089 -122.433745251143 (37.7600048066089, -122.433745251143) 2 4 5 28862 3
159363 58908 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 353 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1980 12:00:00 AM 13 3x3 Permit Number 780019 6009109.47745 2109280.29041 37.7721958858688 -122.411881715065 (37.7721958858688, -122.411881715065) 8 2 9 28853 34
164124 57410 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 109 Wilmot St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/1976 12:00:00 AM 15   Permit Number 770100 6002753.5601 2114939.9175 37.7873771736852 -122.434272041026 (37.7873771736852, -122.434272041026) 13 9 11 29490 27
165464 148687 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 14 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010830.11496 2110873.17046 37.7766659471997 -122.406042088772 (37.7766659471997, -122.406042088772) 14 2 9 28853 34
172861 117048 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2183 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6002170 2114323 37.7856501363162 -122.436246868292 (37.7856501363162, -122.436246868292) 13 6 11 29490 13
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
182236 117650 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 79 ROSSI AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   5996337 2111626 37.7779117506286 -122.456232175702 (37.7779117506286, -122.456232175702) 11 6 2 54 16
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
188426 148686 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 13 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010834.41502 2110868.71034 37.7766539412504 -122.406026899245 (37.7766539412504, -122.406026899245) 14 2 9 28853 34
190159 225029 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 4543 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/14/2017 12:00:00 AM 3 Width 3ft Permit Number 17041 6000793.7951 2105198.47261 37.7605181908718 -122.440353514511 (37.7605181908718, -122.440353514511) 2 4 5 28862 3
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
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
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
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
4294 117126 Undocumented 4 Ficus nitida :: Laurel Fig 53 766 NOE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6003023 2103770 37.7567226205836 -122.432541687014 (37.7567226205836, -122.432541687014) 2 4 5 28862 3
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
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
8269 99967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2270 Folsom St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007986.9 2105322.2 37.7612648499102 -122.415484545241 (37.7612648499102, -122.415484545241) 2 4 7 28859 19
8384 104821 Undocumented 4 Ficus nitida :: Laurel Fig 53 2173 15TH ST   Sidewalk: Curb side : Cutout Tree Private 2     20     6003063.7 2107068.1 37.7657807169148 -122.432636512343 (37.7657807169148, -122.432636512343) 15 5 5 28862 3
8496 115992 Undocumented 4 Ficus nitida :: Laurel Fig 53 438 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2016 12:00:00 AM 3   Permit Number 778644 5989723.9 2112354.3 37.7795296278249 -122.479162248453 (37.7795296278249, -122.479162248453) 11 6 2 55 26
8565 105233 Undocumented 4 Ficus nitida :: Laurel Fig 53 1508 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5998474.1 2108297 37.7688936152058 -122.448599407064 (37.7688936152058, -122.448599407064) 15 5 11 29492 9
8959 113224 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244 23RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001623 2102374 37.7528100494278 -122.437283434624 (37.7528100494278, -122.437283434624) 2 4 5 28862 22
9438 115058 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
10358 120965 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22

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