563 rows where qSpecies_id = 52 sorted by qLegalStatus_id

View and edit SQL

rowid TreeID qLegalStatus_id ▼ qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
98318 113498 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 200x Mansell St 4 Median : Cutout Tree DPW 1     23 3x3   6011210.15679 2090562.2005 37.7209176983622 -122.403298245537 (37.7209176983622, -122.403298245537) 10 7 7 309 28
99234 176299 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 10x Mansell St 7 Median : Cutout Tree DPW 1     24 Width 0ft   6011728.48955 2090724.05613 37.7213910565415 -122.40151788377 (37.7213910565415, -122.40151788377) 10 7 8 309 28
99638 17273 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 53 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017144.20686 2094317.06632 37.7315574623644 -122.383047012358 (37.7315574623644, -122.383047012358) 10 3 8 58 1
99944 17279 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 75 Osceola Dr 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016964.0762842 2094462.847211 37.731947792828 -122.383679910748 (37.731947792828, -122.383679910748) 10 3 8 58 1
101516 17263 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 35 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017206.9997371 2094294.0023377 37.7314976027276 -122.38282831855 (37.7314976027276, -122.38282831855) 10 3 8 58 1
103774 106579 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 3 Median : Yard Tree DPW 1     26     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
104779 224208 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 66 Front Yard : Yard Tree Private 2     22 Width 8ft   6005339.07699 2097371.10972 37.7392838060945 -122.424076794516 (37.7392838060945, -122.424076794516) 2 7 5 28859 2
104945 22432 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 6000 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6013579.8961 2091555.5712 37.7237773618259 -122.39517625529 (37.7237773618259, -122.39517625529) 10 3 8 58 1
105013 54847 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2056 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1972 12:00:00 AM 20 3x3 Permit Number 10705 5997976.78501928 2110316.64994342 37.7744106068743 -122.450465194002 (37.7744106068743, -122.450465194002) 15 5 11 29492 16
105021 12071 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1225X La Salle Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017323.1868972 2094393.2571117 37.7317765554235 -122.382433536417 (37.7317765554235, -122.382433536417) 10 3 8 58 1
105059 224211 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1000 San Jose Ave 1 Front Yard : Yard Tree Private 2     32     6005190.34912 2097382.93272 37.739307871066 -122.424591870417 (37.739307871066, -122.424591870417) 2 7 5 28859 7
105108 29918 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 810 Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     14     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071) 9 8 4 64 40
105578 185059 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 700x Sloat Blvd 3 Median : Cutout Tree DPW 1     13 Width 0ft   5988840.8776 2095965.7184 37.7344796690595 -122.481016672562 (37.7344796690595, -122.481016672562) 1 8 4 64 35
106280 17270 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 47 Osceola Dr 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017170.52754 2094318.49412 37.7315628371719 -122.382956115072 (37.7315628371719, -122.382956115072) 10 3 8 58 1
106421 9285 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 13X George Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017208.5497632 2094048.0250587 37.7308222832509 -122.382805848563 (37.7308222832509, -122.382805848563) 10 3 8 58 1
106932 20988 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2002X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     200 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
107255 106599 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 12 Median : Yard Tree DPW 1     42     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
108092 11344 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1300X Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6017347.6886145 2093992.5867035 37.7306777467756 -122.382320962891 (37.7306777467756, -122.382320962891) 10 3 8 58 1
108653 224196 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 16 Front Yard : Yard Tree Private 2     15     6005192.42807 2096936.6445 37.7380825816538 -122.424552945066 (37.7380825816538, -122.424552945066) 2 7 5 28859 2
108995 6102 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500X 08th St 4 Sidewalk: Property side : Cutout Tree DPW 1     6 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
109483 218283 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2x Sloat Blvd 8 Median : Yard Tree DPW 1     10     5990775.7158 2095986.69925 37.7346495609245 -122.474328895956 (37.7346495609245, -122.474328895956) 1 8 4 64 40
110737 199410 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 822 Mendell St 3 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 4ft   6015932.24155 2096672.73443 37.7379586091972 -122.387401320018 (37.7379586091972, -122.387401320018) 10 3 8 58 1
111489 252877 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1400 Baker St 2 Front Yard : Yard Tree Private 2   01/30/2018 12:00:00 AM 3 3x3 Permit Number 779185 6000422 2113928 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376) 15 6 11 29490 13
111630 176316 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 600x Mansell St 4 Median : Cutout Tree DPW 1     20 Width 0ft   6009975.17316 2090196.62711 37.7198448575227 -122.40754147176 (37.7198448575227, -122.40754147176) 10 3 8 309 18
111721 11291 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1199X Ingalls St 3 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6017612.0195749 2093925.7037957 37.7305086962257 -122.381402471608 (37.7305086962257, -122.381402471608) 10 3 8 58 1
112858 11316 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1216X Ingalls St 7 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6017561.7867095 2093983.7658262 37.7306653497809 -122.38158017208 (37.7306653497809, -122.38158017208) 10 3 8 58 1
113132 108685 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 301X CHESTER AVE 1 Sidewalk: Property side : Cutout Tree DPW 1     18     5991720 2087146 37.7104298409998 -122.470420579231 (37.7104298409998, -122.470420579231) 9 8 4 64 24
113187 12032 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1250X La Salle Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017218.4556902 2094518.641349 37.7321150500381 -122.382804339533 (37.7321150500381, -122.382804339533) 10 3 8 58 1
114508 17282 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 85 Osceola Ln 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6016960.7843 2094470.78287 37.7319694006113 -122.38369184425 (37.7319694006113, -122.38369184425) 10 3 8 58 1
115522 24058 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 21X Whitfield Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6017547.7495644 2094131.2536992 37.7310695474783 -122.381638954529 (37.7310695474783, -122.381638954529) 10 3 8 58 1
116280 1854 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2500 Bay Shore Blvd 1 Median : Cutout Tree DPW 1     12 6   6010837.5147418 2086759.4488697 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881) 9 7 8 309 39
117209 11280 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1176X Ingalls St 19 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
119646 106585 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 6 Median : Yard Tree DPW 1     25     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
119813 176311 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500x Mansell St 16 Median : Cutout Tree DPW 1     15 Width 0ft   6010356.57072 2090296.4274 37.7201402299675 -122.406230135225 (37.7201402299675, -122.406230135225) 10 7 8 309 28
120756 217803 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2x Sloat Blvd 3 Median : Yard Tree DPW 1     34     5991018.47185 2095992.29774 37.7346789939345 -122.473490022742 (37.7346789939345, -122.473490022742) 1 8 4 64 40
121348 187032 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2501 Sunset Blvd 51 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984967.607 2097835.0603 37.7393864646033 -122.494545412715 (37.7393864646033, -122.494545412715) 1 8 3 29491 35
121468 106584 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 5 Median : Yard Tree DPW 1     22     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
122093 3794 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 85 Cashmere St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6017127.2120173 2095821.2433114 37.7356866947795 -122.383210426751 (37.7356866947795, -122.383210426751) 10 3 8 58 1
123800 12070 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1225X La Salle Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017323.1868972 2094393.2571117 37.7317765554235 -122.382433536417 (37.7317765554235, -122.382433536417) 10 3 8 58 1
124032 24062 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 21X Whitfield Ct 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017547.7495644 2094131.2536992 37.7310695474783 -122.381638954529 (37.7310695474783, -122.381638954529) 10 3 8 58 1
124647 6173 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1075 Ellis St 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005893.15301 2113273.27935 37.782978696051 -122.423291166859 (37.782978696051, -122.423291166859) 7 9 11 28858 41
124698 11213 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X Ingalls St 11 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 12 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777) 10 3 8 58 1
126368 224202 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1300 San Jose Ave 27 Front Yard : Yard Tree Private 2     14     6003508.62731 2095617.8291 37.7343661800531 -122.430280617458 (37.7343661800531, -122.430280617458) 2 7 5 63 7
127318 12042 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1250X La Salle Ave 24 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017218.4556902 2094518.641349 37.7321150500381 -122.382804339533 (37.7321150500381, -122.382804339533) 10 3 8 58 1
127674 11214 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X Ingalls St 12 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 12 3X4   6018170.9910099 2094117.1281791 37.7310651541831 -122.379483297777 (37.7310651541831, -122.379483297777) 10 3 8 58 1
127698 257930 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1000X Hudson Ave   Unaccepted Street : Cutout Tree DPW 1       3x3   6018755 2095128 37.7338730033489 -122.377534379141 (37.7338730033489, -122.377534379141) 10 3 8 58 1
130043 17280 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 75 Osceola Dr 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017053.17764 2094406.15972 37.7317970648608 -122.38336792075 (37.7317970648608, -122.38336792075) 10 3 8 58 1
130862 24059 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 21X Whitfield Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017547.7495644 2094131.2536992 37.7310695474783 -122.381638954529 (37.7310695474783, -122.381638954529) 10 3 8 58 1
132040 176314 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500x Mansell St 19 Median : Cutout Tree DPW 1     35 Width 0ft   6010185.66613 2090251.18564 37.7200064441173 -122.406817710885 (37.7200064441173, -122.406817710885) 10 7 8 309 28
132930 11365 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1351X Ingalls St 4 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017270.42563 2093912.097264 37.730452470679 -122.38258247713 (37.730452470679, -122.38258247713) 10 3 8 58 1
133966 187652 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 46 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992908 2101735 37.7505562410762 -122.467374782979 (37.7505562410762, -122.467374782979) 1 8 4 29491 12
134254 11262 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1176X Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
134558 176305 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 300x Mansell St 3 Median : Cutout Tree DPW 1     28 Width 0ft   6010925.66518 2090483.18833 37.7206848540134 -122.404276094583 (37.7206848540134, -122.404276094583) 10 7 7 309 28
135169 106597 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 10 Median : Yard Tree DPW 1     19     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
136060 176328 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 700x Mansell St 32 Median : Cutout Tree DPW 1     11 Width 0ft   6009200.77281 2089956.05158 37.7191409096134 -122.410201337249 (37.7191409096134, -122.410201337249) 9 3 8 309 18
136242 181588 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1227 37th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5984569.5881 2106811.9615 37.7640112583591 -122.496583837339 (37.7640112583591, -122.496583837339) 1 8 3 56 35
136784 12103 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1281X La Salle Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017033.141006 2094557.4754692 37.7322114406026 -122.383447721977 (37.7322114406026, -122.383447721977) 10 3 8 58 1
137140 112418 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 268X Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2       2.5x3   6005334.87738 2110100.0463 37.7742342515583 -122.424996726643 (37.7742342515583, -122.424996726643) 7 9 11 28852 10
137795 176310 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500x Mansell St 8 Median : Cutout Tree DPW 1     29 Width 0ft   6010469.51848 2090335.25755 37.7202531668397 -122.405842444672 (37.7202531668397, -122.405842444672) 10 7 8 309 28
137830 199403 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 299x Cashmere St 22 Median : Yard Tree DPW 1     15     6016641.57283 2096000.10584 37.7361509664773 -122.384901942178 (37.7361509664773, -122.384901942178) 10 3 8 58 1
138384 187029 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2501 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     38 Width 0ft   5984947.4301 2097843.1311 37.7394074439231 -122.49461576934 (37.7394074439231, -122.49461576934) 1 8 3 29491 35
138456 176300 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 10x Mansell St 8 Median : Cutout Tree DPW 1     22 Width 0ft   6011702.06583 2090731.87272 37.7214110448664 -122.401609772869 (37.7214110448664, -122.401609772869) 10 3 8 309 28
138784 199409 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 822 Mendell St 2 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 4ft   6015943.97928 2096692.65499 37.738013957089 -122.387362125771 (37.738013957089, -122.387362125771) 10 3 8 58 1
140238 6100 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500X 08th St 2 Median : Cutout Tree DPW 1     24 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
141199 176304 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 200x Mansell St 17 Median : Cutout Tree DPW 1     12 Width 0ft   6011109.46654 2090529.17456 37.7208213917675 -122.403643980895 (37.7208213917675, -122.403643980895) 10 7 7 309 28
141466 224206 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 59 Front Yard : Yard Tree Private 2     24     6005333.6743 2097319.76234 37.7391425127264 -122.424091823995 (37.7391425127264, -122.424091823995) 2 7 5 28859 2
143783 106577 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001X SAN JOSE AVE 1 Median : Cutout Tree DPW 1     10     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
144569 117548 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 24X KEMPTON AVE 2 Side Yard : Yard Tree DPW 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
144698 199406 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 301x Cashmere St 6 Median : Yard Tree DPW 1     22     6016219.39095 2096203.76694 37.7366868185504 -122.386375806006 (37.7366868185504, -122.386375806006) 10 3 8 58 1
145233 54757 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 330 Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/1972 12:00:00 AM 14   Permit Number 10606 6012426.81669 2086731.57127 37.7104674323033 -122.398823887208 (37.7104674323033, -122.398823887208) 10 3 8 309 1
145650 176329 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 700x Mansell St 33 Median : Cutout Tree DPW 1     11 Width 0ft   6009197.90265 2089964.97601 37.719165253359 -122.410211888084 (37.719165253359, -122.410211888084) 9 3 8 309 18
146044 19366 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500X Lake St 3 Sidewalk: Curb side : Cutout Tree DPW 1     125 3X3   5993786.07945 2114905.65207 37.7867700254284 -122.465294925074 (37.7867700254284, -122.465294925074) 11 6 1 54 11
146575 122380 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 557 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005149 2111246 37.777370259808 -122.425721291473 (37.777370259808, -122.425721291473) 7 9 11 28852 10
146690 199400 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 299 Cashmere St 16 : Tree Private 2     38     6016698.52819 2095954.85127 37.7360298565815 -122.384701870897 (37.7360298565815, -122.384701870897) 10 3 8 58 1
146973 12108 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1281X La Salle Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/1992 12:00:00 AM 20 3X3   6017033.141006 2094557.4754692 37.7322114406026 -122.383447721977 (37.7322114406026, -122.383447721977) 10 3 8 58 1
148359 10846 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1139X Hudson Ave 53 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/1990 12:00:00 AM 12 3X4   6018074.11801 2094612.24201 37.7324192966959 -122.379852595874 (37.7324192966959, -122.379852595874) 10 3 8 58 1
148903 12079 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1241X La Salle Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017245.0743814 2094442.9323579 37.7319086387255 -122.382707045529 (37.7319086387255, -122.382707045529) 10 3 8 58 1
149269 187038 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2501 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984961.8902 2097789.6624 37.7392614795793 -122.494561832752 (37.7392614795793, -122.494561832752) 1 8 3 29491 35
149539 176333 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 12x Canyon Dr 12 Median : Cutout Tree DPW 1     12 Width 0ft   6002752.1139 2086168.71447 37.7083781345093 -122.432221533399 (37.7083781345093, -122.432221533399) 9 7 6 28861 5
150919 224210 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 72 Front Yard : Yard Tree Private 2     37     6005362.14637 2097481.1402 37.7395872274562 -122.424004853264 (37.7395872274562, -122.424004853264) 2 7 5 28859 2
151055 11352 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1339 Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017292.9099838 2093920.0801467 37.7304756321775 -122.382505299944 (37.7304756321775, -122.382505299944) 10 3 8 58 1
151085 106464 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 3500X MISSION ST 5 Median : Cutout Tree DPW 1     28     6005565.6 2097823.9 37.7405398531137 -122.42332575716 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
151453 111293 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 3500X MISSION ST 1 Median : Cutout Tree DPW 1     30     6005565 2097823 37.7405373480538 -122.423327767767 (37.7405373480538, -122.423327767767) 2 7 7 28859 2
152049 11353 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1339 Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017292.9099838 2093920.0801467 37.7304756321775 -122.382505299944 (37.7304756321775, -122.382505299944) 10 3 8 58 1
152370 69180 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1310 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 8   Permit Number 33219 5982156.72464205 2106168.22486515 37.7621020835294 -122.504881372035 (37.7621020835294, -122.504881372035) 1 8 3 56 35
152575 6105 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 500X 08th St 7 Sidewalk: Property side : Cutout Tree DPW 1     3 18   6010526.8124541 2109340.6023904 37.7724409020578 -122.406983260044 (37.7724409020578, -122.406983260044) 14 2 9 28853 34
153065 254084 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 170x Kensington Way 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5994883 2098695 37.7423229834884 -122.460324888843 (37.7423229834884, -122.460324888843) 1 8 4 59 40
153115 199401 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 299x Cashmere St 18 Median : Yard Tree DPW 1     30     6016684.16305 2095970.28806 37.7360714484387 -122.384752612468 (37.7360714484387, -122.384752612468) 10 3 8 58 1
153238 224215 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1000 San Jose Ave 14 Front Yard : Yard Tree Private 2     26     6005165.86979 2097298.42463 37.739074448424 -122.424670499065 (37.739074448424, -122.424670499065) 2 7 5 28859 7
153608 117546 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 24X KEMPTON AVE 1 Side Yard : Yard Tree DPW 1       30x30   5992274 2087683 37.7119363308651 -122.468544900416 (37.7119363308651, -122.468544900416) 9 8 4 64 24
153721 17255 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 17 Osceola Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017331.5843984 2094252.3198967 37.7313900334691 -122.382394702172 (37.7313900334691, -122.382394702172) 10 3 8 58 1
154295 187031 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 2501 Sunset Blvd 50 Sidewalk: Property side : Yard Tree Private 2     19 Width 0ft   5984966.2618 2097842.7948 37.7394076227298 -122.494550633787 (37.7394076227298, -122.494550633787) 1 8 3 29491 35
155411 11362 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1351X Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017270.42563 2093912.097264 37.730452470679 -122.38258247713 (37.730452470679, -122.38258247713) 10 3 8 58 1
157768 115772 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1204 Egbert Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 775363 6015358.9 2090410.1 37.7207308974409 -122.388946547811 (37.7207308974409, -122.388946547811) 10 3 8 58 1
159428 11277 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1176X Ingalls St 16 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
159523 218793 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 616 Joost Ave 2 Sidewalk: Property side : Yard Tree Private 2     23 Width 10ft   5998053.08406 2095010.86684 37.7323890825862 -122.449098408785 (37.7323890825862, -122.449098408785) 9 7 4 59 40
159561 11323 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1223 Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6017540.6929483 2093936.3628532 37.7305340258377 -122.381649801703 (37.7305340258377, -122.381649801703) 10 3 8 58 1
160280 191716 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 561 Rhode Island St 1 : Tree Private 2     15 Width 3ft   6011818.5901 2105765.65198 37.7626970962079 -122.402263453208 (37.7626970962079, -122.402263453208) 8 3 8 28856 29
160353 11332 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1279 Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6017412.9471167 2093950.7223454 37.7305663998171 -122.382092440811 (37.7305663998171, -122.382092440811) 10 3 8 58 1
160479 224199 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 1001 San Jose Ave 35 Front Yard : Yard Tree Private 2     16     6005272.32245 2097108.71152 37.7385595505918 -122.424288944593 (37.7385595505918, -122.424288944593) 2 7 5 28859 2

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