trees

5,599 rows where qSpecies_id = 38 sorted by DBH

✎ 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)
2456 260910 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 241 Laussat St 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003564.7514 2109147.66361 37.7715190947724 -122.431051921008 (37.7715190947724, -122.431051921008) 15 9 11 29492 10
4474 109514 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1501x FULTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000537 2110949 37.7762930788063 -122.441654341711 (37.7762930788063, -122.441654341711) 15 5 11 29492 16
8837 251690 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 98 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779453 6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
11735 260909 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 241 Laussat St 4 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003564.7514 2109147.66361 37.7715190947724 -122.431051921008 (37.7715190947724, -122.431051921008) 15 9 11 29492 10
14007 260416 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 360 Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003567.24671 2108663.75145 37.7701905316964 -122.431008746366 (37.7701905316964, -122.431008746366) 15 9 11 29492 10
15244 260908 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 241 Laussat St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003564.7514 2109147.66361 37.7715190947724 -122.431051921008 (37.7715190947724, -122.431051921008) 15 9 11 29492 10
16148 255011 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 245 North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6009525.60238 2121869.50761 37.806786171612 -122.411331809333 (37.806786171612, -122.411331809333) 3 1 10 308 23
19192 173595 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779216 6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
20101 102885 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2940 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2106758 37.7651615533416 -122.418394378814 (37.7651615533416, -122.418394378814) 8 4 7 28853 19
20857 57294 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3030 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM     Permit Number 16115 6006612.86147234 2106740.75991177 37.7650825555261 -122.420337459951 (37.7650825555261, -122.420337459951) 8 4 7 28853 19
21248 98029 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 493 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003709.9 2105435.7 37.7613351647369 -122.430284971477 (37.7613351647369, -122.430284971477) 8 4 5 28862 3
21823 98030 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 493 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003709.9 2105435.7 37.7613351647369 -122.430284971477 (37.7613351647369, -122.430284971477) 8 4 5 28862 3
22084 251694 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 98 11th St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779453 6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
22256 104835 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4595-4599 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000476 2105174 37.7604328955242 -122.441450863046 (37.7604328955242, -122.441450863046) 2 4 5 28862 3
25344 103031 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
28246 105037 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 60 Hiliritas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770444 6001403.1 2096820.4 37.7375486740807 -122.437646191192 (37.7375486740807, -122.437646191192) 2 7 5 63 7
30596 97093 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
30684 97622 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
30934 56353 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 157 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1973 12:00:00 AM   5x5 Permit Number 12495 6002706.41661255 2104989.75216117 37.7600538090993 -122.433723721804 (37.7600538090993, -122.433723721804) 2 4 5 28862 3
34276 104696 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 953 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770164 6008633.4 2103067 37.7551089013639 -122.413089099766 (37.7551089013639, -122.413089099766) 2 4 7 28859 19
34282 102882 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2886-2888 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 21288 6007521 2106777 37.765233194266 -122.41719899188 (37.765233194266, -122.41719899188) 8 4 7 28853 19
34689 251592 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1999X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6007220 2119146 37.799178528828 -122.419117510386 (37.799178528828, -122.419117510386) 5 1 10 28858 32
35668 100851 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1043-1049 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
42508 103032 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
43869 67061 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3751 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1992 12:00:00 AM     Permit Number 30442 6004747.16045801 2102483.32750571 37.7532873427532 -122.426487293458 (37.7532873427532, -122.426487293458) 2 4 5 28862 22
47418 97098 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1096 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
55676 59495 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3131 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/02/1981 12:00:00 AM     Permit Number 18870 6005949.30607357 2106651.86371307 37.7648010537929 -122.422626220724 (37.7648010537929, -122.422626220724) 8 4 5 28859 19
60374 59971 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 953 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1982 12:00:00 AM     Permit Number 770164 6008622.11827174 2103000.09497074 37.7549245619495 -122.413123384766 (37.7549245619495, -122.413123384766) 2 4 7 28859 19
64926 104439 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200X Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
69701 97616 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
80559 99314 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 690X 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5 12 5993197.5 2110786.1 37.7754248939418 -122.46703164043 (37.7754248939418, -122.46703164043) 11 6 2 54 11
81966 60170 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3530 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1982 12:00:00 AM     Permit Number 19739 6006073.64013371 2104949.4412081 37.7601336156662 -122.4220752293 (37.7601336156662, -122.4220752293) 2 4 5 28859 19
82579 97624 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 5 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
86239 251331 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2232 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003295 2116396 37.791405922267 -122.432502815233 (37.791405922267, -122.432502815233) 13 9 1 29490 27
88337 97091 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
89249 256570 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003295 2116396 37.791405922267 -122.432502815233 (37.791405922267, -122.432502815233) 13 9 1 29490 27
89410 55438 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2179 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/1972 12:00:00 AM   3x3 Permit Number 11386 6003157.5538321 2107090.38264344 37.7658472217414 -122.432313483733 (37.7658472217414, -122.432313483733) 15 5 5 28862 3
96279 255302 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1576 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1           5998599.10204 2108661.87853 37.7699026256233 -122.448193312417 (37.7699026256233, -122.448193312417) 15 5 11 29492 9
99723 57859 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 243 Banks St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1977 12:00:00 AM     Permit Number 16802 6008653.70601919 2097500.21669417 37.7398248927239 -122.412625369635 (37.7398248927239, -122.412625369635) 10 7 7 28859 2
100855 100010 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X Mission St 5 Sidewalk: Curb side : Pot Tree Private 2         Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
102068 254584 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1800 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004329.59797 2118765.91025 37.7979717057735 -122.429092175982 (37.7979717057735, -122.429092175982) 13 9 1 57 17
103401 97621 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
103587 100852 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1043-1049 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
106002 98031 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 493 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003709.9 2105435.7 37.7613351647369 -122.430284971477 (37.7613351647369, -122.430284971477) 8 4 5 28862 3
106974 97623 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 4 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
109344 251330 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2232 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003295 2116396 37.791405922267 -122.432502815233 (37.791405922267, -122.432502815233) 13 9 1 29490 27
109471 253154 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1454 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008456.02855 2117561.49656 37.7948974030383 -122.414728219525 (37.7948974030383, -122.414728219525) 5 1 10 28857 21
109526 100854 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 496X Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769289 6003126.9 2103316.7 37.7554838581871 -122.432149992401 (37.7554838581871, -122.432149992401) 2 4 5 28862 22
109995 104442 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200X Chattanooga St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
112191 103030 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
112221 97102 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1096@Jones Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008668 2115966 37.7905284677514 -122.413881848265 (37.7905284677514, -122.413881848265) 5 1 10 28857 21
113033 97662 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1909 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2011 12:00:00 AM   5x6 Permit Number 768299 5999946 2115458 37.7886399393615 -122.444022824205 (37.7886399393615, -122.444022824205) 13 6 1 29490 27
113497 251693 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 98 11th St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779453 6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
117254 58316 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1501-1519X 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1978 12:00:00 AM     Permit Number 17339 6007402 2107334 37.7667558904507 -122.417650067636 (37.7667558904507, -122.417650067636) 8 4 7 28853 19
118744 104695 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 953 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770164 6008633.4 2103067 37.7551089013639 -122.413089099766 (37.7551089013639, -122.413089099766) 2 4 7 28859 19
123495 101891 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 196X Wool St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 21188 6007299.5 2097331.3 37.7392849882208 -122.417295688779 (37.7392849882208, -122.417295688779) 2 7 7 28859 2
125918 253903 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1225 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5995446.34406 2107212.89211 37.7657433464104 -122.45899363306 (37.7657433464104, -122.45899363306) 15 5 11 56 12
129184 218897 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1285 09th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 2ft   5993290.82714 2106725.73936 37.7642816090429 -122.46641363171 (37.7642816090429, -122.46641363171) 11 8 11 56 12
130617 96930 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 649 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2011 12:00:00 AM   3x3 Permit Number 768122 6009413.8 2111202 37.7774895185086 -122.410964788592 (37.7774895185086, -122.410964788592) 8 2 9 28853 34
132627 113238 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3030 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6006612.86147234 2106740.75991177 37.7650825555261 -122.420337459951 (37.7650825555261, -122.420337459951) 8 4 7 28853 19
133176 97092 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
135695 173594 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 75 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 779216 6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
141104 55731 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2226 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM   6x6 Permit Number 11757 6002704.74665442 2107117.26012075 37.7658953354732 -122.433881568302 (37.7658953354732, -122.433881568302) 15 5 5 28862 3
141780 104839 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Clover St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000464.1 2105186.9 37.7604676378061 -122.44149294524 (37.7604676378061, -122.44149294524) 2 4 5 28862 3
146774 97094 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2756@Vallejo Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002132 2117587 37.7946100813673 -122.436612052598 (37.7946100813673, -122.436612052598) 13 9 1 29490 27
154504 103033 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300X Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769938 6014508.3 2114897.4 37.787920602156 -122.393599785715 (37.787920602156, -122.393599785715) 6 2 9 28855 6
157176 118688 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4645 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   5981105.94918 2110928.32696 37.7751100630106 -122.508868980798 (37.7751100630106, -122.508868980798) 11 6 2 55 26
158578 51678 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 672 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/13/2005 12:00:00 AM     Permit Number 770377 6007616.9101817 2096263.07678619 37.7363697350759 -122.416122590192 (37.7363697350759, -122.416122590192) 2 7 7 28859 2
159233 103956 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4263-4265 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000811 2102861 37.7541010401035 -122.44012639143 (37.7541010401035, -122.44012639143) 2 4 5 28862 22
161929 104441 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 200X Chattanooga St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004765.42963 2102220.02594 37.7525654108037 -122.426405368946 (37.7525654108037, -122.426405368946) 2 4 5 28862 22
162918 58851 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 615 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/1979 12:00:00 AM   3x3 Permit Number 18110 6008337.3940243 2114564.58255444 37.7866619441951 -122.414926498345 (37.7866619441951, -122.414926498345) 13 1 9 28858 36
163961 104836 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Clover St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000464.1 2105186.9 37.7604676378061 -122.44149294524 (37.7604676378061, -122.44149294524) 2 4 5 28862 3
165142 97620 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 333@Clay Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012618 2117355 37.7945633749541 -122.400312601987 (37.7945633749541, -122.400312601987) 3 1 10 28860 4
168047 104840 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Clover St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000464.1 2105186.9 37.7604676378061 -122.44149294524 (37.7604676378061, -122.44149294524) 2 4 5 28862 3
175917 104838 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Clover St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770743 6000464.1 2105186.9 37.7604676378061 -122.44149294524 (37.7604676378061, -122.44149294524) 2 4 5 28862 3
177559 98028 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3888-3896 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003694 2105395 37.7612225116628 -122.430337058991 (37.7612225116628, -122.430337058991) 8 4 5 28862 3
179993 57439 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 4401 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/1976 12:00:00 AM     Permit Number 16282 6001390.76806136 2105222.86680343 37.7606191434319 -122.438290610369 (37.7606191434319, -122.438290610369) 2 4 5 28862 3
185702 253367 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 600 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1999 12:00:00 AM     Permit Number 23367 6010620.1417 2118945.4017 37.798818623722 -122.407337650556 (37.798818623722, -122.407337650556) 3 1 10 308 23
185988 104837 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Clover St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000464.1 2105186.9 37.7604676378061 -122.44149294524 (37.7604676378061, -122.44149294524) 2 4 5 28862 3
188219 100853 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 490X Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6003181 2102169 37.7523356131155 -122.431880952183 (37.7523356131155, -122.431880952183) 2 4 5 28862 22
193281 255776 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 281 Geary St 5 Sidewalk: Curb side : Pot Tree Private 2       Width 4ft   6010453.10569 2114773.50548 37.7873542539382 -122.407621346845 (37.7873542539382, -122.407621346845) 5 1 10 28852 6
193679 101838 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3815-3817 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003483 2105926 37.762668556024 -122.431104719068 (37.762668556024, -122.431104719068) 15 4 5 28862 3
1426 84231 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 178 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5988065.20329 2114809.31405 37.7861739305031 -122.48508048983 (37.7861739305031, -122.48508048983) 11 6 1 55 33
54388 224848 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3087 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6006285.38222 2106667.40678 37.7648626861762 -122.421464922278 (37.7648626861762, -122.421464922278) 8 4 7 28859 19
69219 218890 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 434 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5993124.01114 2105981.91795 37.7622296439042 -122.466936517307 (37.7622296439042, -122.466936517307) 1 8 11 56 12
84278 123093 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 619 11th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   5992509.28892 2111212.18975 37.7765550735304 -122.469443326141 (37.7765550735304, -122.469443326141) 11 6 2 54 11
103604 218910 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 623 Laguna Honda Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5995736.44002 2099882.18046 37.7456317427251 -122.457459843802 (37.7456317427251, -122.457459843802) 1 5 4 59 40
114733 218911 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 623 Laguna Honda Blvd 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5995731.43182 2099885.12493 37.7456395398376 -122.457477374284 (37.7456395398376, -122.457477374284) 1 5 4 59 40
125015 246679 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 65 Randall St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 4ft   6005202.46496 2097607.42576 37.7399249624788 -122.424565943861 (37.7399249624788, -122.424565943861) 2 7 5 63 7
169025 15280 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1551 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     1 3X3   6007333.49611 2109742.48343 37.7733651619099 -122.418057773243 (37.7733651619099, -122.418057773243) 8 2 9 28853 19
181506 190267 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 101 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6014731.82819 2116284.57708 37.7917418879363 -122.392923502728 (37.7917418879363, -122.392923502728) 12 2 9 28855 6
648 189633 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 45 11th St 10 : Tree Private 2     10 Width 3ft   6007281.55408 2110475.16176 37.775373998252 -122.418289406239 (37.775373998252, -122.418289406239) 8 2 9 28853 34
802 126843 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 Avila St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001073.31574 2121444.93358 37.8051427271077 -122.440552066845 (37.8051427271077, -122.440552066845) 13 9 1 57 17
1807 128108 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 102 North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009837.41929 2121966.51853 37.8070700228254 -122.410259554851 (37.8070700228254, -122.410259554851) 3 1 10 308 23
2395 224762 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 301 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6004982.47318 2110039.87008 37.7740491098102 -122.426211472077 (37.7740491098102, -122.426211472077) 7 9 11 28852 10
5432 189807 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 220 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6010828.58743 2107359.89419 37.7670192127893 -122.405799840205 (37.7670192127893, -122.405799840205) 8 4 8 28853 19
5506 225470 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2231 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002657.30889 2107063.70687 37.765745599218 -122.434041816972 (37.765745599218, -122.434041816972) 15 5 5 28862 3
5769 127718 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1377 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008134.11977 2116552.38078 37.7921085280447 -122.415770585055 (37.7921085280447, -122.415770585055) 5 1 10 28858 21
5834 126875 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401 Walnut St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5998625 2115075 37.7875128775034 -122.448565673536 (37.7875128775034, -122.448565673536) 13 6 1 54 31

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