trees
720 rows where qSpecies_id = 127
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );