720 rows where qSpecies_id = 127

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)
659 11520 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 10 Sidewalk: Curb side : Cutout Tree DPW 1   05/01/2017 12:00:00 AM 6 3X3   6018495.90717 2096693.85175 37.738158246093 -122.378538834904 (37.738158246093, -122.378538834904) 10 3 8 58 1
690 19651 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 50 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
750 11540 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 30 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018782.49291 2097080.98118 37.7392370206652 -122.37757481115 (37.7392370206652, -122.37757481115) 10 3 8 58 1
1270 140150 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 280 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 0ft   5998837.1325 2109760.3619 37.7729323858329 -122.447449052578 (37.7729323858329, -122.447449052578) 15 5 11 29492 16
1658 62209 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 227 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/1985 12:00:00 AM 16   Permit Number 22331 5988338.57879 2114482.10714 37.7852914335725 -122.484110690197 (37.7852914335725, -122.484110690197) 11 6 2 55 26
1786 19661 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 60 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
1871 261422 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2025 97297 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 450 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994062.8 2112448.2 37.7800384821655 -122.464159075962 (37.7800384821655, -122.464159075962) 11 6 2 54 11
2037 62579 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 741 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1986 12:00:00 AM 10   Permit Number 22784 6011303.77085 2104898.93824 37.7602885436105 -122.403983043294 (37.7602885436105, -122.403983043294) 10 3 8 28856 29
2258 264781 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 90x Guy Pl 15 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
2309 11966 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1009X Mendell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6015728.77645 2096327.58352 37.736999624078 -122.388080725796 (37.736999624078, -122.388080725796) 10 3 8 58 1
2313 260963 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2447 19649 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 48 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
3167 199344 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1801 03rd St 3 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 4ft   6015727.94816 2106771.64308 37.7656767749832 -122.388812492998 (37.7656767749832, -122.388812492998) 14 3 9 310 29
4337 106918 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 274 PUTNAM ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009044.8 2096077.1 37.7359392652864 -122.411172625582 (37.7359392652864, -122.411172625582) 10 7 7 28859 2
4670 107425 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 1600X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2           5997832.17799 2108247.26578 37.7687203321672 -122.450816174345 (37.7687203321672, -122.450816174345) 15 5 11 29492 9
4852 218789 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 380 Monterey Blvd 1 Sidewalk: Property side : Yard Tree Private 2     30     5999445.61392 2094740.51345 37.7317263020196 -122.444264703861 (37.7317263020196, -122.444264703861) 9 7 4 63 40
4905 224435 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 599X Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 5ft   6007163 2097853 37.7407097800121 -122.417804616035 (37.7407097800121, -122.417804616035) 2 7 7 28859 2
5068 4202 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 3902 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004480.6649 2100468.03712 37.7477387553393 -122.427265346224 (37.7477387553393, -122.427265346224) 2 4 5 63 22
5181 4830 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     44 5x5   6006270.256805 2097668.3997492 37.740152628556 -122.420878285554 (37.740152628556, -122.420878285554) 2 7 7 28859 2
5193 19660 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 59 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
5353 199364 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 300x Division St 3 Median : Cutout Tree DPW 1     28 Width 6ft   6009993.3485 2108173.38824 37.7692061355694 -122.408746211675 (37.7692061355694, -122.408746211675) 8 4 8 28853 19
5369 38224 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1099 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/21/1998 12:00:00 AM 14   Permit Number 40351 6014264.59569 2102044.43409 37.7526156672934 -122.393543078061 (37.7526156672934, -122.393543078061) 10 3 8 28856 29
5501 250103 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 2 : Tree Private 2     2 Width 4ft   6006023.8446 2115600.71368 37.7893766304877 -122.423004504073 (37.7893766304877, -122.423004504073) 13 9 1 28858 41
6089 19680 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 79 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6125 19650 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 49 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6394 19671 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 70 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6529 19672 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 71 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
6739 102293 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 801 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016486.61621 2101147.40436 37.7502758246674 -122.385796353939 (37.7502758246674, -122.385796353939) 10 3 8 58 1
6861 11269 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1176X Ingalls St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/03/1990 12:00:00 AM 3 3x3   6017716.362196 2093961.1645628 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671) 10 3 8 58 1
7136 62578 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 739 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1986 12:00:00 AM 9   Permit Number 22783 6011302.74241 2104925.74778 37.7603620991639 -122.403988486898 (37.7603620991639, -122.403988486898) 10 3 8 28856 29
7357 11962 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 945X Mendell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6015820.0973 2096449.8462 37.7373403917231 -122.38777351408 (37.7373403917231, -122.38777351408) 10 3 8 58 1
7423 260961 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
7464 224445 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 20 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003875.0564 2108571.54256 37.7699547852142 -122.429937456853 (37.7699547852142, -122.429937456853) 7 9 5 29492 10
7486 224010 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1000 San Jose Ave 31 Front Yard : Yard Tree Private 2     18     6005156.6976 2097181.32171 37.7387523922042 -122.424693884126 (37.7387523922042, -122.424693884126) 2 7 5 28859 7
7791 199356 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2151 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6011640.657 2104629.31608 37.759567037301 -122.402798942823 (37.759567037301, -122.402798942823) 10 3 8 28856 29
8025 10826 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1139X Hudson Ave 33 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/1990 12:00:00 AM 12 3X4   6017834.53501 2094620.05501 37.732427530713 -122.380681442077 (37.732427530713, -122.380681442077) 10 3 8 58 1
8066 141287 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1855 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 0ft   6001856.4282 2112885.6951 37.7816858418255 -122.437228784957 (37.7816858418255, -122.437228784957) 15 5 11 29490 41
8456 99698 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1750 Divisadero St 1 Front Yard : Cutout Tree Private 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
8639 199392 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1199 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6018085.49835 2093997.29329 37.7307313955254 -122.379770541 (37.7307313955254, -122.379770541) 10 3 8 58 1
8697 224438 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 401X Powhattan Ave 5 Sidewalk: Property side : Yard Tree Private 2     17 Width 3ft   6008219.66372 2098116.47311 37.7414926273921 -122.414169698278 (37.7414926273921, -122.414169698278) 2 7 7 28859 2
8761 19674 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 73 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
9178 10645 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 906 Hayes St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6003455.1435 2110726.9996 37.7758493511517 -122.431543829861 (37.7758493511517, -122.431543829861) 15 9 11 29492 10
9216 261431 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9297 139640 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1780 Turk St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 0ft   6001669 2112367 37.7802509803634 -122.437840034507 (37.7802509803634, -122.437840034507) 15 5 11 29490 41
9378 218791 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 138 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6001157.9301 2094692.71106 37.731692590922 -122.438341469381 (37.731692590922, -122.438341469381) 9 7 4 63 40
9794 26872 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 969 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6003239 2110629 37.7755680153799 -122.432284524402 (37.7755680153799, -122.432284524402) 15 9 11 29492 10
10119 261688 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10440 246120 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1285 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1979 12:00:00 AM 17 Width 0ft Permit Number 17675 5999565 2108371 37.7691591171027 -122.444831391499 (37.7691591171027, -122.444831391499) 15 5 11 29492 9
11151 206269 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 576 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 6ft   5994053.8446 2099403.66341 37.7442210643587 -122.463243244477 (37.7442210643587, -122.463243244477) 1 8 4 29491 40
11257 199342 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1801 03rd St 1 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 4ft   6015732.89393 2106644.75831 37.7653286510121 -122.388786527772 (37.7653286510121, -122.388786527772) 14 3 9 310 29
11451 19677 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 76 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11558 116508 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1500x Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
11564 141296 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1835 ELLIS ST 8 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 0ft   6002071.6645 2112917.5067 37.7817854213105 -122.436486447843 (37.7817854213105, -122.436486447843) 15 5 11 29490 41
11565 19675 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 74 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
11704 19657 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 56 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
11706 58511 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1430 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1979 12:00:00 AM     Permit Number 17687 5998871.25967783 2108358.36156462 37.7690847998305 -122.447230081169 (37.7690847998305, -122.447230081169) 15 5 11 29492 9
12418 4841 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 142 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 6x9 Permit Number 784458 6006480.03392 2097559.50493 37.7398654498357 -122.420145233727 (37.7398654498357, -122.420145233727) 2 7 7 28859 2
12634 264775 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 90x Guy Pl 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014171 2114529 37.7868903128003 -122.3947409816 (37.7868903128003, -122.3947409816) 6 2 9 28855 6
13665 109201 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 2401x CASTRO ST 4 Median : Yard Tree DPW 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
13883 11536 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 26 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018721.15121 2096997.58655 37.739004655647 -122.377781119206 (37.739004655647, -122.377781119206) 10 3 8 58 1
13911 199353 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2201 20th St 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 4ft   6011453.77249 2104619.23603 37.7595289231366 -122.403444576915 (37.7595289231366, -122.403444576915) 10 3 8 28856 29
14154 19656 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 55 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
14191 11527 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 101X Jennings St 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6018609.30332 2096848.22468 37.7385883738483 -122.378157476493 (37.7385883738483, -122.378157476493) 10 3 8 58 1
14243 19683 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 82 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
14650 199380 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 200 Jennings St 18 : Tree Private 2     15 Width 3ft   6018370.09073 2096624.46593 37.7379607900541 -122.378969032793 (37.7379607900541, -122.378969032793) 10 3 8 58 1
15810 19653 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 52 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
16132 123506 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2630 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 8ft   5995210.57552 2110304.28467 37.774217945514 -122.460033072871 (37.774217945514, -122.460033072871) 11 6 2 54 11
16513 263639 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 970 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003214 2110722 37.7758219527997 -122.432377649116 (37.7758219527997, -122.432377649116) 15 9 11 29492 10
17121 199343 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1801 03rd St 2 Sidewalk: Property side : Yard Tree Private 2   10/16/2019 12:00:00 AM 3 Width 4ft   6015732.25453 2106672.58002 37.7654050079639 -122.388790681754 (37.7654050079639, -122.388790681754) 14 3 9 310 29
17175 105511 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 400X Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772834 6003196.1616 2109801.36502 37.7732931051579 -122.432373588443 (37.7732931051579, -122.432373588443) 15 9 11 29492 9
17206 121988 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 528 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   5991288.02079 2111782.83574 37.7780512574537 -122.473709641027 (37.7780512574537, -122.473709641027) 11 6 2 54 26
17264 260645 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 3905 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
17360 5760 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 400 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     36 3x3   6003950.51884 2108401.53413 37.7694922566853 -122.42966430667 (37.7694922566853, -122.42966430667) 7 9 5 29492 10
17378 206294 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1291 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/1972 12:00:00 AM 14 Width 5ft Permit Number 10303 5995770.00748 2106810.2745 37.7646564626472 -122.457845020728 (37.7646564626472, -122.457845020728) 15 5 11 56 12
17620 138647 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 600 PRESIDIO AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999215.4534 2114556.1413 37.7861219706649 -122.446485488681 (37.7861219706649, -122.446485488681) 15 6 1 29490 31
17736 199387 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1335 Hudson Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6017568.18175 2094804.88271 37.7329203283169 -122.381615146745 (37.7329203283169, -122.381615146745) 10 3 8 58 1
18030 260962 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
18935 258611 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 982 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6003166 2110704 37.7757698073842 -122.432542407207 (37.7757698073842, -122.432542407207) 15 9 11 29492 10
19102 19678 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 STAIRWAY5 77 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
19346 199370 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 3550 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     27 Width 4ft   6016015.91083 2099228.15232 37.7449798979207 -122.387290235768 (37.7449798979207, -122.387290235768) 10 3 8 58 1
19505 116636 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2100 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   6011793.53885 2104686.09338 37.7597314702416 -122.402274190217 (37.7597314702416, -122.402274190217) 10 3 8 28856 29
19848 250104 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 1 : Tree Private 2     2 Width 4ft   6006039.94152 2115602.86884 37.7893834563277 -122.422948963731 (37.7893834563277, -122.422948963731) 13 9 1 28858 41
20541 51528 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 2900 Hawes St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.391228469926 (37.7180658851091, -122.391228469926) 10 3 8 58 1
22312 116999 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 880x MCALLISTER ST 2 Front Yard : Cutout Tree Private 2           6005306 2112177 37.779935428414 -122.425244441442 (37.779935428414, -122.425244441442) 7 9 11 28852 41
22390 107072 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 400X Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2014 12:00:00 AM 3 50x5 Permit Number 773144 6015855.63323 2106318.50292 37.7644396262057 -122.388339224777 (37.7644396262057, -122.388339224777) 14 3 9 310 29
22434 16120 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 303 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6000032.3049 2094633.40383 37.7314656586952 -122.442228714304 (37.7314656586952, -122.442228714304) 9 7 4 63 40
22529 248372 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1609 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   5997820.1302 2108164.6442 37.7684927847419 -122.450851888359 (37.7684927847419, -122.450851888359) 15 5 11 29492 9
22721 199372 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 2 Newhall St 2 : Tree DPW 1   11/12/2014 12:00:00 AM 15 Width 3ft Permit Number 774049 6018530.30847 2097200.55685 37.7395514542225 -122.378455061265 (37.7395514542225, -122.378455061265) 10 3 8 58 1
22823 224022 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1300 San Jose Ave 21 Front Yard : Yard Tree Private 2     25     6003540.82213 2095652.97051 37.7344644939234 -122.4301718157 (37.7344644939234, -122.4301718157) 2 7 5 63 7
22932 11963 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1009X Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6015687.60896 2096283.05677 37.7368750817287 -122.388219954896 (37.7368750817287, -122.388219954896) 10 3 8 58 1
23731 50377 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1620 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734) 3 1 10 28860 6
23908 199351 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 875 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     19     6011310.44581 2104289.70696 37.7586161031593 -122.403917085224 (37.7586161031593, -122.403917085224) 10 3 8 28856 29
24371 11231 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 1050X Ingalls St 17 Sidewalk: Curb side : Cutout Tree DPW 1   04/02/1990 12:00:00 AM 50 3X4   6018085.6618829 2094069.8743192 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493) 10 3 8 58 1
24539 17758 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 8 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005894.5926 2115584.12973 37.7893238007876 -122.423450522313 (37.7893238007876, -122.423450522313) 13 9 1 28858 41
24916 20126 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 999X Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6003226.6736 2110648.3783 37.7756205244718 -122.432328548686 (37.7756205244718, -122.432328548686) 15 9 11 29492 10
25125 109198 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 2401x CASTRO ST 2 Median : Yard Tree DPW 1           6002698 2098487 37.7421983129634 -122.433288166914 (37.7421983129634, -122.433288166914) 2 7 5 63 7
25295 4834 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 108 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 5x5   6006318.50135 2097642.91153 37.7400853628581 -122.420709666225 (37.7400853628581, -122.420709666225) 2 7 7 28859 2
25556 1293 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 4000X Alemany Blvd 1 Median : Cutout Tree DPW 1     50 10   5991961.87152 2087160.63909 37.7104840184951 -122.469585692537 (37.7104840184951, -122.469585692537) 9 8 4 64 24
25790 11503 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 17 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1

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