Street_Tree_List

Data source: data.sfgov.org

272 rows where qLegalStatus = 3 and qSpecies = 36 sorted by SiteOrder

View and edit SQL

Suggested facets: qSiteInfo, qCaretaker

qLegalStatus

  • DPW Maintained · 272
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1153 17806 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1881 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6004903.5356 2115394.9801 37.7887484569995 -122.42686598915199 (37.7887484569995, -122.426865989152)
1520 199389 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 16 Reuel Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 Width 4ft   6017439.78771 2096071.60272 37.7363914002406 -122.38214713169901 (37.7363914002406, -122.382147131699)
2560 138642 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3059 PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 Width 0ft   5999277.8969 2114611.151 37.7862765793233 -122.446273410182 (37.7862765793233, -122.446273410182)
2569 139637 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1780 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 0ft   6001520.6292 2112190.4921 37.7797578963919 -122.438340667374 (37.7797578963919, -122.438340667374)
3956 15038 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1017 Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X3   6015648.0 2096190.0 37.7366173719863 -122.388350408836 (37.7366173719863, -122.388350408836)
5348 26872 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 969 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6003227.2163 2110650.5623 37.7756265519671 -122.432326827371 (37.7756265519671, -122.432326827371)
6238 8189 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1279 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001660.1742 2111123.4233 37.7768359307235 -122.437781474603 (37.7768359307235, -122.437781474603)
6636 2588 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1710 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/12/1999 12:00:00 AM 18 3   6005206.687000001 2115142.0135 37.788071009916 -122.42579911500499 (37.788071009916, -122.425799115005)
7223 10658 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 957 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/14/2007 12:00:00 AM 3 3x3   6003278.1745 2110658.3168 37.7756507331964 -122.43215110447599 (37.7756507331964, -122.432151104476)
7779 10661 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 958 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6003257.9574 2110699.3049 37.7757621301077 -122.432223968227 (37.7757621301077, -122.432223968227)
8329 8190 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1280 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   6001658.902000001 2111173.1154 37.7769723003903 -122.437789435412 (37.7769723003903, -122.437789435412)
8867 10653 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 930 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003401.4158 2110719.799 37.775826534714106 -122.43172917338 (37.7758265347141, -122.43172917338)
8898 10643 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 906 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   6003494.47 2110732.5385 37.77586678850471 -122.431408185002 (37.7758667885047, -122.431408185002)
10605 1293 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 4000X Alemany Blvd 1 Median : Cutout 11 Tree 1 DPW 2     50 10   5991961.87152 2087160.6390900002 37.7104840184951 -122.46958569253701 (37.7104840184951, -122.469585692537)
13576 3696 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 401X Cargo Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6016376.57655 2099377.09307 37.7454088259626 -122.386053488085 (37.7454088259626, -122.386053488085)
13610 11963 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1009X Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6015687.60896 2096283.0567700001 37.736875081728705 -122.38821995489599 (37.7368750817287, -122.388219954896)
15523 26807 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1487 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6015996.3267 2095429.905 37.7345495997276 -122.38709308337098 (37.7345495997276, -122.387093083371)
16820 11511 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 101X Jennings St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5   6018385.91854 2096547.1526 37.7377493756286 -122.378908940096 (37.7377493756286, -122.378908940096)
16927 24534 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 128 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/11/1996 12:00:00 AM 8 3X3   6006387.02802 2097608.2195099997 37.7399939683457 -122.420470266705 (37.7399939683457, -122.420470266705)
16934 4202 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3902 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004480.6649 2100468.03712 37.7477387553393 -122.427265346224 (37.7477387553393, -122.427265346224)
17259 4834 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 108 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 5x5   6006318.50135 2097642.9115299997 37.7400853628581 -122.420709666225 (37.7400853628581, -122.420709666225)
17352 16120 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 303 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6000032.3049 2094633.40383 37.7314656586952 -122.44222871430401 (37.7314656586952, -122.442228714304)
17573 16029 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 146 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001109.44487 2094693.26414 37.7316913516547 -122.43850913181002 (37.7316913516547, -122.43850913181)
17697 4413 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1108 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 6x9   6004403.04195 2102416.52833 37.753084468576205 -122.427672567341 (37.7530844685762, -122.427672567341)
18215 4462 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1454 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6004517.68898 2100379.8296 37.7474986516535 -122.42713103697099 (37.7474986516535, -122.427131036971)
18226 4848 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 229 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     32 2x3   6006739.96805 2097466.29285 37.7396241527309 -122.419239878116 (37.7396241527309, -122.419239878116)
18235 4828 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 85 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   6006188.87424 2097766.1175 37.740416352027204 -122.421166610858 (37.7404163520272, -122.421166610858)
18348 16020 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 107 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6001336.16248 2094611.17288 37.731478841871706 -122.437719447913 (37.7314788418717, -122.437719447913)
18512 4810 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 20 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   6005841.28363 2097904.31782 37.7407762175496 -122.42237826114099 (37.7407762175496, -122.422378261141)
18582 4840 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 138 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     65 3X3   6006436.16175 2097581.71528 37.7399239624285 -122.42029850157499 (37.7399239624285, -122.420298501575)
18996 28137 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 418 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 4X5   6006961.256569999 2097891.09385 37.740803021841295 -122.418504870321 (37.7408030218413, -122.418504870321)
19096 4431 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1195 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004486.69317 2101949.49973 37.7518068485257 -122.427350018309 (37.7518068485257, -122.427350018309)
19540 4835 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 115 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6006362.63783 2097667.32197 37.7401548759573 -122.420558792379 (37.7401548759573, -122.420558792379)
19938 16038 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 163 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000989.84379 2094618.6563099998 37.7314796917131 -122.43891727113301 (37.7314796917131, -122.438917271133)
20001 4839 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 135 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6006426.94909 2097635.5595299997 37.7400712875725 -122.42033417588699 (37.7400712875725, -122.420334175887)
20184 16030 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 147 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6001102.99289 2094615.6926099998 37.731477991115796 -122.438525881668 (37.7314779911158, -122.438525881668)
20202 5091 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2600 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6002242.42307 2096653.9998400002 37.7371394644141 -122.434732362321 (37.7371394644141, -122.434732362321)
20228 4824 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 73 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006137.31563 2097787.40171 37.740471886955 -122.42134639164301 (37.740471886955, -122.421346391643)
20730 4823 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 66 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 3X3   6006092.06915 2097770.47064 37.74042284693579 -122.421501634396 (37.7404228469358, -122.421501634396)
21184 4827 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 80 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6006160.77573 2097729.74879 37.74031490761921 -122.421261182679 (37.7403149076192, -122.421261182679)
21191 4812 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 28 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     46 3X3   6005885.45019 2097879.1399 37.7407095759957 -122.422223761224 (37.7407095759957, -122.422223761224)
21443 4396 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1005 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6004431.4266800005 2103008.65854 37.754711924921295 -122.427616590837 (37.7547119249213, -122.427616590837)
21637 4817 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 51 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6005995.99863 2097868.77885 37.7406873618291 -122.42184079032499 (37.7406873618291, -122.421840790325)
21650 1996 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 175 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3x3   6007331.5108 2098053.7261799998 37.741270411207296 -122.41723618861201 (37.7412704112073, -122.417236188612)
21920 4841 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 142 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 6x9   6006480.033919999 2097559.50493 37.7398654498357 -122.420145233727 (37.7398654498357, -122.420145233727)
21993 16119 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 301 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6000050.07874 2094632.71852 37.7314647899581 -122.442167217764 (37.7314647899581, -122.442167217764)
22088 16025 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 131 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001203.7257900005 2094613.91575 37.7314788418574 -122.438177502293 (37.7314788418574, -122.438177502293)
22196 4409 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1097 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   6004456.37766 2102543.07479 37.753434952361495 -122.427497136583 (37.7534349523615, -122.427497136583)
22222 4815 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 36 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     80 3X3   6005920.0488599995 2097862.788 37.740666628859294 -122.42210297059799 (37.7406666288593, -122.422102970598)
23051 10656 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 940 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     17 3X3   6003283.9904 2110703.7361 37.7757757730917 -122.432134230107 (37.7757757730917, -122.432134230107)
23270 11971 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1022X Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3X3   6015641.62594 2096289.89853 37.736891319872896 -122.388379417299 (37.7368913198729, -122.388379417299)
27310 199370 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3550 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     27 Width 4ft   6016015.91083 2099228.15232 37.74497989792071 -122.38729023576799 (37.7449798979207, -122.387290235768)
79043 4201 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3902 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004475.85975 2100470.10248 37.7477441545905 -122.427282109286 (37.7477441545905, -122.427282109286)
83724 26803 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1470 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6016001.5116582 2095486.8668237 37.734706292549205 -122.387079128733 (37.7347062925492, -122.387079128733)
93664 6117 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 199X Elk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
96484 6324 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1895X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6001829.84497 2112881.90897 37.7816739348974 -122.437320479018 (37.7816739348974, -122.437320479018)
96819 14870 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1460X McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6016026.3862344 2095468.2889327 37.734656658788296 -122.38699183277399 (37.7346566587883, -122.386991832774)
97378 18108 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3071X PINE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5999273.0 2114556.0 37.7861248694209 -122.44628638333499 (37.7861248694209, -122.446286383335)
97379 15039 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1017 Mendell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6015648.596419999 2096190.1744099997 37.736617883929604 -122.388348358907 (37.7366178839296, -122.388348358907)
98031 16026 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 134 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6001180.6151014995 2094696.8372785 37.7317052108344 -122.438263338431 (37.7317052108344, -122.438263338431)
100144 5241 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1780X Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6001669.86946 2112366.9914599997 37.78025100635529 -122.437837026039 (37.7802510063553, -122.437837026039)
101721 18107 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3067 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 3x3   5999321.271546599 2114616.8679369 37.7862947536085 -122.446123757059 (37.7862947536085, -122.446123757059)
107337 10662 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 966 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6003229.58025 2110778.15442 37.7759770223646 -122.43232776456199 (37.7759770223646, -122.432327764562)
109314 10665 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 980 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003182.65121 2110752.66431 37.7759043717652 -122.432488283197 (37.7759043717652, -122.432488283197)
111640 10664 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 972 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6003204.82079 2110774.69478 37.7759661191121 -122.43241316679399 (37.7759661191121, -122.432413166794)
115125 22101 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3550 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6015976.463219999 2099134.576 37.744720771915496 -122.38742011299999 (37.7447207719155, -122.387420113)
116261 18633 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2 Reuel Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6017006.0134624 2096129.8208529998 37.7365272887181 -122.38365093789899 (37.7365272887181, -122.383650937899)
127665 20126 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 999X Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X4   6003226.6736 2110648.3783 37.7756205244718 -122.432328548686 (37.7756205244718, -122.432328548686)
129383 4430 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1195 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6004484.1301445 2101944.4411304 37.751792813836104 -122.427358521283 (37.7517928138361, -122.427358521283)
141075 17993 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2650X Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6001258.2893795 2114937.1034436002 37.7872844637831 -122.43944515397101 (37.7872844637831, -122.439445153971)
143617 16166 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 405 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5999388.049433099 2094640.7964516003 37.7314492181413 -122.44445655139799 (37.7314492181413, -122.444456551398)
792 199372 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2 Newhall St 2 : 4 Tree 1 DPW 2   11/12/2014 12:00:00 AM 15 Width 3ft Permit Number 774049 6018530.30847 2097200.55685 37.7395514542225 -122.37845506126499 (37.7395514542225, -122.378455061265)
1843 9890 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1700 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6005344.337040001 2115550.48459 37.7892003471598 -122.42535194865299 (37.7892003471598, -122.425351948653)
3849 10659 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 957 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 5x5   6003302.5458 2110662.7479 37.775664281642 -122.43206711469601 (37.775664281642, -122.432067114696)
5984 10644 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 906 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   6003470.6525 2110728.6613 37.775854792789296 -122.431490298947 (37.7758547927893, -122.431490298947)
6681 10654 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 930 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6003365.9666 2110715.3678 37.7758123582585 -122.431851484644 (37.7758123582585, -122.431851484644)
7023 23544 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2800X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2     24 9   6005656.2038 2120054.10262 37.80158375904121 -122.424593418169 (37.8015837590412, -122.424593418169)
7523 87408 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 2400X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2   04/18/2008 12:00:00 AM 3 3x3   6005843.02152 2118712.53051 37.7979106921903 -122.42385149366501 (37.7979106921903, -122.423851493665)
7531 8183 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1216 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   6001748.9425 2111188.325 37.777019181607706 -122.437479047598 (37.7770191816077, -122.437479047598)
12006 1294 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 4000X Alemany Blvd 2 Median : Cutout 11 Tree 1 DPW 2     25 10   5991953.08243 2087152.92109 37.7104623187479 -122.469615507754 (37.7104623187479, -122.469615507754)
14940 26805 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1491 McKinnon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6015969.8239 2095448.3954 37.734598903014295 -122.38718600253901 (37.7345989030143, -122.387186002539)
15508 11512 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 101X Jennings St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6018400.60741 2096569.54507 37.7378116707805 -122.378859707612 (37.7378116707805, -122.378859707612)
15758 22102 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 3550 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016009.792669999 2099202.98145 37.744910445068896 -122.387309635952 (37.7449104450689, -122.387309635952)
16658 22427 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 5919 03rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6013743.1817 2091759.1378 37.724345394142 -122.39462604842699 (37.724345394142, -122.394626048427)
16854 11488 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 100 Jennings St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/05/1993 12:00:00 AM 6 4X4   6018872.157000001 2097296.32677 37.7398332567899 -122.377279727371 (37.7398332567899, -122.377279727371)
19295 5760 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 398 Duboce Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3x3   6003950.51884 2108401.53413 37.7694922566853 -122.42966430666999 (37.7694922566853, -122.42966430667)
22500 17776 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1762 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005516.07608 2115531.08967 37.7891567948058 -122.424756371721 (37.7891567948058, -122.424756371721)
22653 17778 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1770 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6005458.75733 2115520.73995 37.7891251395545 -122.424953950985 (37.7891251395545, -122.424953950985)
22805 17745 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1600X Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6006152.6648 2115617.75127 37.7894306797229 -122.422560011429 (37.7894306797229, -122.422560011429)
23178 11964 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1009X Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     28 3X3   6015715.011390001 2096321.03931 37.7369808923559 -122.38812786163 (37.7369808923559, -122.38812786163)
23186 17762 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1700 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     23     6005688.226009999 2115553.43335 37.7892278664309 -122.424162343438 (37.7892278664309, -122.424162343438)
81336 26808 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1485 McKinnon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   6015936.7189767 2095472.8520506 37.7346642227188 -122.387302163855 (37.7346642227188, -122.387302163855)
82431 6309 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1807 Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002200.5977300005 2112898.1085099997 37.7817394844201 -122.43603901136999 (37.7817394844201, -122.43603901137)
83509 11417 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 721X Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016212.49704 2096975.20091 37.7388046385926 -122.386453413297 (37.7388046385926, -122.386453413297)
85513 11303 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1201X Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/03/1993 12:00:00 AM 40 3X3   6017591.0151778 2093928.8426978001 37.7305161553992 -122.38147530581499 (37.7305161553992, -122.381475305815)
88912 14871 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1460X McKinnon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 3X3   6016026.3862344 2095468.2889327 37.734656658788296 -122.38699183277399 (37.7346566587883, -122.386991832774)
92387 6315 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 1829 Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002129.29202 2112924.84308 37.781808839600394 -122.43628760910102 (37.7818088396004, -122.436287609101)
103050 6118 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 199X Elk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000815.0314327 2096222.3312360002 37.7358730629277 -122.439636554407 (37.7358730629277, -122.439636554407)
104962 97215 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10     20 4x12   5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
122202 11556 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 830X Mendell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/07/1996 12:00:00 AM 18 3X3   6015938.87476 2096683.24967 37.737987849284394 -122.387379118862 (37.7379878492844, -122.387379118862)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2208.929ms · Data source: data.sfgov.org