trees

5,599 rows where qSpecies_id = 38 sorted by TreeID

✎ 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)
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                    
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
72431 10007 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005407.88099 2108072.95104 37.7686724598889 -122.424599967939 (37.7686724598889, -122.424599967939) 8 4 5 28853 19
68163 10008 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005410.95643 2108039.08035 37.7685796327732 -122.424586920555 (37.7685796327732, -122.424586920555) 8 4 5 28853 19
84704 10009 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 170 Guerrero St 3 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005412.73113 2108018.38384 37.7685229053392 -122.4245793096 (37.7685229053392, -122.4245793096) 8 4 5 28853 19
94130 100160 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1699 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     11   Permit Number 28164 6005505.58523 2118187.22554 37.7964492830571 -122.424981725648 (37.7964492830571, -122.424981725648) 13 9 1 28858 27
87452 100163 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1814 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     18     6004278.90656 2118759.95598 37.7979524872736 -122.429267157958 (37.7979524872736, -122.429267157958) 13 9 1 57 17
68208 100164 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 839 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6008231.9319 2115379.46118 37.7888934760005 -122.41534908182 (37.7888934760005, -122.41534908182) 13 1 10 28858 21
99569 100165 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 839 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6008234.89338 2115366.55149 37.7888581955857 -122.415337921201 (37.7888581955857, -122.415337921201) 13 1 10 28858 21
100479 100181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Ritch St 2 Sidewalk: Curb side : Cutout Tree Private 2     15     6013794.16577 2112184.81721 37.7804327665865 -122.39588042504 (37.7804327665865, -122.39588042504) 6 2 9 28856 34
2882 100182 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 230 Ritch St 3 Sidewalk: Curb side : Cutout Tree Private 2     20     6013808.29227 2112170.33848 37.7803937971776 -122.39583053966 (37.7803937971776, -122.39583053966) 6 2 9 28856 34
73963 100254 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2X Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 2x2   6015227.31131 2113576.31726 37.7843331361945 -122.391019745885 (37.7843331361945, -122.391019745885) 6 2 9 28856 6
170477 100256 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2X Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 2x2   6015186.92454 2113537.35467 37.7842239126372 -122.391156746807 (37.7842239126372, -122.391156746807) 6 2 9 28856 6
74523 100257 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2X Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 2x2   6015171.2792 2113522.46957 37.784182173302 -122.391209833759 (37.784182173302, -122.391209833759) 6 2 9 28856 6
90814 100266 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2017 12:00:00 AM 3 1x1 Permit Number 779105 6015095.83494 2113421.2206 37.7838999795421 -122.391463765467 (37.7838999795421, -122.391463765467) 6 2 9 28856 6
90950 100267 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015119.18661 2113440.63946 37.7839545953771 -122.391384334617 (37.7839545953771, -122.391384334617) 6 2 9 28856 6
47017 100268 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015133.4862 2113455.2111 37.7839953994148 -122.391335881848 (37.7839953994148, -122.391335881848) 6 2 9 28856 6
2982 100269 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015149.19988 2113471.58342 37.7840412261692 -122.391282662663 (37.7840412261692, -122.391282662663) 6 2 9 28856 6
160742 100270 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015164.42669 2113486.59389 37.7840832865491 -122.391231032594 (37.7840832865491, -122.391231032594) 6 2 9 28856 6
75484 100271 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 1x1   6015178.9141 2113499.10422 37.7841184410568 -122.391181785729 (37.7841184410568, -122.391181785729) 6 2 9 28856 6
65975 100272 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015193.56957 2113513.16529 37.7841578628497 -122.391132065814 (37.7841578628497, -122.391132065814) 6 2 9 28856 6
27303 100273 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015216.1617 2113535.8467 37.7842213945326 -122.391055490318 (37.7842213945326, -122.391055490318) 6 2 9 28856 6
185295 100274 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1 Federal St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 1x1   6015236.2818 2113554.41618 37.7842734985691 -122.390987179627 (37.7842734985691, -122.390987179627) 6 2 9 28856 6
189963 10030 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 307 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3PL   6005523.84407 2107170.82921 37.76620199705 -122.424134695569 (37.76620199705, -122.424134695569) 8 4 5 28853 19
91382 100306 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1434 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/14/2012 12:00:00 AM 2 3x3 Permit Number 769213 6008902.15418 2117844.1551 37.7956985695001 -122.413204553065 (37.7956985695001, -122.413204553065) 3 1 10 308 21
109751 100363 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 327 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5988363.5301 2113726.92065 37.7832193582839 -122.483968971104 (37.7832193582839, -122.483968971104) 11 6 2 55 26
70006 10050 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 390 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6005481.13253 2106756.02425 37.7650606296618 -122.424252922232 (37.7650606296618, -122.424252922232) 8 4 5 28853 19
174022 100530 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1434 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     16     6008903.53114 2117829.38309 37.7956580864982 -122.413198743428 (37.7956580864982, -122.413198743428) 3 1 10 308 21
27800 100681 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 1 Sidewalk: Curb side : Pot Tree Private 2     3     6012316.03692 2116830.75541 37.793107081281 -122.401320580594 (37.793107081281, -122.401320580594) 4 1 10 28854 6
49483 100683 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 2 Sidewalk: Curb side : Pot Tree Private 2     5     6012308.79613 2116830.37882 37.7931056432739 -122.401345607834 (37.7931056432739, -122.401345607834) 4 1 10 28854 6
108062 100685 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 4 Sidewalk: Curb side : Pot Tree Private 2     4     6012263.39214 2116825.45731 37.7930895966627 -122.401502363241 (37.7930895966627, -122.401502363241) 4 1 10 28854 6
77100 100686 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 400 California St 5 Sidewalk: Curb side : Pot Tree Private 2     7     6012251.79525 2116824.78932 37.7930871154393 -122.401542442434 (37.7930871154393, -122.401542442434) 4 1 10 28854 6
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
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
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
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
82932 100858 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014579.57181 2111752.86281 37.7792903802729 -122.393133082533 (37.7792903802729, -122.393133082533) 6 2 9 28856 6
81987 100860 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014540.39365 2111793.70056 37.7794003350072 -122.393271475613 (37.7794003350072, -122.393271475613) 6 2 9 28856 6
31115 100861 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014522.73449 2111811.16047 37.7794472948859 -122.393333788721 (37.7794472948859, -122.393333788721) 6 2 9 28856 6
108395 101022 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1979 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003568.32546 2118610.54777 37.7975019979781 -122.431715296927 (37.7975019979781, -122.431715296927) 13 9 1 57 17
99314 101074 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1969 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003610.72225 2118616.04144 37.7975194852926 -122.431568985315 (37.7975194852926, -122.431568985315) 13 9 1 57 17
144060 101320 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 6-8 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 6x6   6003417 2108348 37.7693150407363 -122.431505903511 (37.7693150407363, -122.431505903511) 15 9 5 28862 10
56836 101405 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 699 Rhode Island St 2 Sidewalk: Curb side : Cutout Tree Private 2     21 4x6   6011850.96946 2105175.58933 37.7610787230206 -122.402109978488 (37.7610787230206, -122.402109978488) 10 3 8 28856 29
42563 101411 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2301 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     15   Permit Number 11899 6001293.07197 2116312.72543 37.7910635454926 -122.43942345903 (37.7910635454926, -122.43942345903) 13 6 1 29490 27
126803 101412 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     18   Permit Number 11899 6001276.73705 2116291.83033 37.7910052433397 -122.439478478645 (37.7910052433397, -122.439478478645) 13 6 1 29490 27
177676 101413 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     19   Permit Number 11899 6001259.00574 2116290.75835 37.7910012908294 -122.439539751276 (37.7910012908294, -122.439539751276) 13 6 1 29490 27
72939 101414 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     18   Permit Number 11899 6001241.98232 2116288.95178 37.7909953615835 -122.439598521949 (37.7909953615835, -122.439598521949) 13 6 1 29490 27
146160 101415 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     21   Permit Number 11899 6001227.8336 2116286.36605 37.7909874565554 -122.439647290405 (37.7909874565554, -122.439647290405) 13 6 1 29490 27
26422 101416 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     18   Permit Number 11899 6001215.87512 2116284.81447 37.7909825156781 -122.439688554896 (37.7909825156781, -122.439688554896) 13 6 1 29490 27
167828 101417 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2800X Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2     22   Permit Number 11899 6001202.84016 2116283.64484 37.7909785622497 -122.439733571346 (37.7909785622497, -122.439733571346) 13 6 1 29490 27
36019 101434 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2200 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003613.04276 2116945.81626 37.7929336074401 -122.431441661119 (37.7929336074401, -122.431441661119) 13 9 1 29490 27
134294 10146 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 928 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2x3   6005660.514 2103530.38957 37.7562139222568 -122.423403155547 (37.7562139222568, -122.423403155547) 2 4 5 28859 19
128786 10148 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 948 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 2x3   6005665.54475 2103435.07342 37.7559524902372 -122.423378981771 (37.7559524902372, -122.423378981771) 2 4 5 28859 19
101167 10149 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 960 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x9   6005669.87513 2103378.5529 37.7557975424466 -122.423359988073 (37.7557975424466, -122.423359988073) 2 4 5 28859 19
95916 101521 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3010 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 4x4 Permit Number 23924 6000238.84647 2115823.44768 37.7896600644188 -122.443035877412 (37.7896600644188, -122.443035877412) 13 6 1 29490 27
84548 101522 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2115 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 6x5   5999832.67505 2116251.72145 37.7908128253031 -122.444471976922 (37.7908128253031, -122.444471976922) 13 6 1 29490 27
23580 101653 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1103 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6012239.53744 2103251.34702 37.7558168580866 -122.400630902213 (37.7558168580866, -122.400630902213) 10 3 8 28856 29
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
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
107347 101894 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 586X Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6011794.58236 2117751.94591 37.7956073431459 -122.403189683873 (37.7956073431459, -122.403189683873) 3 1 10 28860 4
149937 101896 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1030 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 769674 6008183.01108 2116026.65387 37.7906677592601 -122.415564181669 (37.7906677592601, -122.415564181669) 5 1 10 28858 21
66068 101897 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 1030 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 769674 6008181.44725 2116041.89613 37.7907095228698 -122.415570672075 (37.7907095228698, -122.415570672075) 5 1 10 28858 21
62416 102107 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 450 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3 Permit Number 769637 6014127 2112833 37.7822310395913 -122.394774393425 (37.7822310395913, -122.394774393425) 6 2 9 28856 6
40328 102265 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2029 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6001885.40612 2115556.68597 37.789021347891 -122.437319848541 (37.789021347891, -122.437319848541) 13 6 1 29490 27
109288 102318 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3200X 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008156.4 2105059 37.760551689018 -122.414879686077 (37.760551689018, -122.414879686077) 2 4 7 28859 19
107879 102323 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
155892 102326 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
30758 102329 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 10 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
161428 102330 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
93174 102332 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
78175 102333 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201X 18th St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
25988 102335 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
81479 102336 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
180449 102337 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
94808 102340 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
118558 102341 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
164318 102342 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
63931 102343 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
29549 102344 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 10 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
158743 102345 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 11 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
87230 102347 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 401X Shotwell St 13 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6007842 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168) 2 4 7 28859 19
145119 102571 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3577 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2016 12:00:00 AM 12 7x9 Permit Number 777028 6004545 2103063 37.7548675573137 -122.427227693889 (37.7548675573137, -122.427227693889) 2 4 5 28862 22
178306 102736 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009133.19234 2111209.09694 37.7774932659425 -122.411936008959 (37.7774932659425, -122.411936008959) 8 2 9 28853 34
28208 102737 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 665 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009147.89785 2111222.04181 37.7775296345182 -122.411886052493 (37.7775296345182, -122.411886052493) 8 2 9 28853 34
48826 102785 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3343 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5.5x6 Permit Number 772480 6003227.9831 2119876.64018 37.8009590611712 -122.432983472326 (37.8009590611712, -122.432983472326) 13 9 1 57 17
83701 102828 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3100 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 3x3   5999876.92736 2115772.90384 37.7895006424768 -122.444284443079 (37.7895006424768, -122.444284443079) 13 6 1 29490 27
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
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
165210 102887 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2940 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     28 3x3   6007175 2106758 37.7651615533416 -122.418394378814 (37.7651615533416, -122.418394378814) 8 4 7 28853 19
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
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
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
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
100617 103103 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 872 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006557.03043 2121514.50661 37.8056444885747 -122.4215799249 (37.8056444885747, -122.4215799249) 5 1 1 28858 32
53399 103104 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 872 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6006536.45203 2121512.20315 37.805637003504 -122.421650975821 (37.805637003504, -122.421650975821) 5 1 1 28858 32
7290 103105 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010638.43235 2115205.50204 37.7885507857476 -122.407010612771 (37.7885507857476, -122.407010612771) 5 1 10 28852 6
63909 103106 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010625.62871 2115201.67506 37.788539561288 -122.407054641768 (37.788539561288, -122.407054641768) 5 1 10 28852 6
166349 103107 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010612.4895 2115201.53409 37.7885384389361 -122.4071000917 (37.7885384389361, -122.4071000917) 5 1 10 28852 6
177276 103108 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010599.7189 2115199.34149 37.7885317039092 -122.407144121614 (37.7885317039092, -122.407144121614) 5 1 10 28852 6
62532 103109 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 300 Post St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6010585.29035 2115196.36518 37.7885227241995 -122.407193832533 (37.7885227241995, -122.407193832533) 5 1 10 28852 6

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