trees
861 rows where qSpecies_id = 18 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2229 | 227630 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 10 Arbor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002176.82031 | 2096986.40745 | 37.7380484541639 | -122.43498294672 | (37.7380484541639, -122.43498294672) | 2 | 7 | 5 | 63 | 7 | |||
| 182404 | 176938 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 10 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012264.96042 | 2087928.82829 | 37.7137458424772 | -122.399467299971 | (37.7137458424772, -122.399467299971) | 10 | 3 | 8 | 309 | 1 | |||
| 93851 | 39928 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | 9 | 7 | 8 | 309 | 39 | |||
| 115855 | 39927 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | 9 | 7 | 8 | 309 | 39 | |||
| 18349 | 171813 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6008462.06709 | 2093570.22923 | 37.7290232412306 | -122.413010176287 | (37.7290232412306, -122.413010176287) | 9 | 3 | 7 | 309 | 28 | ||
| 115276 | 122590 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6008161 | 2119143 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | 5 | 1 | 10 | 308 | 32 | |||||
| 2631 | 176979 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | 9 | 7 | 6 | 28861 | 5 | |||
| 108940 | 176977 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002472.36908 | 2086850.07188 | 37.7102331283354 | -122.433237015483 | (37.7102331283354, -122.433237015483) | 9 | 7 | 6 | 28861 | 5 | |||
| 129111 | 176978 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002453.71663 | 2086834.19677 | 37.7101884805901 | -122.433300348445 | (37.7101884805901, -122.433300348445) | 9 | 7 | 6 | 28861 | 5 | |||
| 189467 | 176976 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002487.99329 | 2086859.86644 | 37.7102609083974 | -122.433183714473 | (37.7102609083974, -122.433183714473) | 9 | 7 | 6 | 28861 | 5 | |||
| 63090 | 31965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.415729001311 | (37.7987324288073, -122.415729001311) | 5 | 1 | 10 | 308 | 32 | |||
| 94349 | 94202 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008232 | 2118962 | 37.7987302484859 | -122.415602598872 | (37.7987302484859, -122.415602598872) | 5 | 1 | 10 | 308 | 32 | |
| 134590 | 94203 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53605 | 6008148.35783 | 2118956.03523 | 37.7987091687558 | -122.415891605907 | (37.7987091687558, -122.415891605907) | 5 | 1 | 10 | 308 | 32 | |
| 9474 | 35363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 5 | Permit Number 38825 | 6011873.19867 | 2103659.86628 | 37.7569181237816 | -122.401926543791 | (37.7569181237816, -122.401926543791) | 10 | 3 | 8 | 28856 | 29 | |
| 59713 | 35365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | 10 | 3 | 8 | 28856 | 29 | |
| 64446 | 35364 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011875.91601 | 2103641.32434 | 37.7568673633546 | -122.401915842767 | (37.7568673633546, -122.401915842767) | 10 | 3 | 8 | 28856 | 29 | |
| 128245 | 55357 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | 2 | 4 | 5 | 28862 | 22 | |||
| 167266 | 227623 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6001957.40527 | 2101134.69618 | 37.7494262207603 | -122.436038328126 | (37.7494262207603, -122.436038328126) | 2 | 4 | 5 | 28862 | 22 | |||
| 58693 | 200018 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.379068779178 | (37.7254942451327, -122.379068779178) | 10 | 3 | 8 | 58 | 1 | |||
| 162945 | 53889 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1009 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/1972 12:00:00 AM | 6 | Permit Number 9600 | 6011157.21659 | 2090045.52637 | 37.7194960599821 | -122.403444914172 | (37.7194960599821, -122.403444914172) | 10 | 7 | 8 | 309 | 28 | ||
| 3046 | 258383 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3342 | 258384 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3785 | 258385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | ||||
| 16942 | 171730 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007892.79548 | 2093379.38085 | 37.7284672398478 | -122.414964695362 | (37.7284672398478, -122.414964695362) | 9 | 3 | 7 | 309 | 5 | ||
| 18180 | 172292 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1016 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001343.2172 | 2086829.28712 | 37.7101119374834 | -122.437138099169 | (37.7101119374834, -122.437138099169) | 9 | 7 | 6 | 28861 | 5 | |||
| 114966 | 98192 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1020 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008091.62981 | 2118948.72517 | 37.7986859077751 | -122.416087385628 | (37.7986859077751, -122.416087385628) | 5 | 1 | 10 | 308 | 32 | |||
| 80345 | 41525 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.7336937659006 | -122.37859297315 | (37.7336937659006, -122.37859297315) | 10 | 3 | 8 | 58 | 1 | |||
| 192933 | 191260 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1058 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012165.085 | 2103460.39568 | 37.7563867072014 | -122.400903071241 | (37.7563867072014, -122.400903071241) | 10 | 3 | 8 | 28856 | 29 | |||
| 157815 | 7404 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1060 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 24 | 3X3 | 6010543.2443 | 2111181.3457 | 37.777496075538 | -122.407056190657 | (37.777496075538, -122.407056190657) | 14 | 2 | 9 | 28853 | 34 | ||
| 194392 | 162798 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 107 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996432.70685 | 2090525.92628 | 37.7199816938867 | -122.454376546047 | (37.7199816938867, -122.454376546047) | 9 | 8 | 6 | 28861 | 24 | ||
| 166939 | 35235 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | 5 | 1 | 1 | 308 | 32 | |
| 174473 | 254175 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1089 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 3x3 | 6006628.18877 | 2120429.73547 | 37.8026699959528 | -122.421256591898 | (37.8026699959528, -122.421256591898) | 5 | 1 | 1 | 28858 | 32 | ||
| 116697 | 176928 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 110 Hester Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012745.68967 | 2087817.62997 | 37.71346729726 | -122.397797917233 | (37.71346729726, -122.397797917233) | 10 | 3 | 8 | 309 | 1 | |||
| 181193 | 176929 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 110 Hester Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012755.76956 | 2087791.93581 | 37.7133973075252 | -122.397761276185 | (37.7133973075252, -122.397761276185) | 10 | 3 | 8 | 309 | 1 | |||
| 175436 | 227601 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | 2 | 7 | 5 | 63 | 7 | ||||
| 2814 | 191330 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6014815.79386 | 2110104.24777 | 37.7747767728644 | -122.392200554832 | (37.7747767728644, -122.392200554832) | 14 | 3 | 9 | 310 | ||||
| 25240 | 191332 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014847.27565 | 2110066.45331 | 37.774674745669 | -122.392089008326 | (37.774674745669, -122.392089008326) | 14 | 3 | 9 | 310 | 20 | |||
| 103363 | 191335 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014898.40719 | 2110003.75259 | 37.774505422222 | -122.391907747266 | (37.774505422222, -122.391907747266) | 14 | 3 | 9 | 310 | 20 | |||
| 128790 | 191331 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014830.54088 | 2110082.99883 | 37.7747192468262 | -122.392148055082 | (37.7747192468262, -122.392148055082) | 14 | 3 | 9 | 310 | ||||
| 147945 | 191333 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014865.84277 | 2110042.35986 | 37.7746096212801 | -122.392023095184 | (37.7746096212801, -122.392023095184) | 14 | 3 | 9 | 310 | 20 | |||
| 152240 | 191334 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1108 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014881.31548 | 2110022.28226 | 37.7745553516884 | -122.391968167293 | (37.7745553516884, -122.391968167293) | 14 | 3 | 9 | 310 | 20 | |||
| 144937 | 93854 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875 | 2103807 | 37.7561278331456 | -122.474556183246 | (37.7561278331456, -122.474556183246) | 1 | 8 | 4 | 56 | 12 | ||
| 138785 | 247176 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 111 Buena Vista Ave East | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | 15 | 5 | 5 | 29492 | 9 | |||
| 90924 | 31792 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | 15 | 5 | 5 | 29492 | 9 | ||
| 102554 | 227658 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 111 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001589.01566 | 2106181.9491 | 37.7632638228943 | -122.437673651738 | (37.7632638228943, -122.437673651738) | 15 | 5 | 5 | 28862 | 3 | |||
| 5529 | 250619 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5987113.72203 | 2115192.60557 | 37.7871708695801 | -122.48840049988 | (37.7871708695801, -122.48840049988) | 11 | 6 | 1 | 55 | 33 | |||
| 98941 | 34270 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.488372976967 | (37.7872778329962, -122.488372976967) | 11 | 6 | 1 | 55 | 33 | ||
| 118708 | 34269 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.488372976967 | (37.7872778329962, -122.488372976967) | 11 | 6 | 1 | 55 | 33 | ||
| 126224 | 250620 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5987116.07946 | 2115204.5954 | 37.7872039277514 | -122.488393225281 | (37.7872039277514, -122.488393225281) | 11 | 6 | 1 | 55 | 33 | |||
| 38814 | 207094 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Kenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994559.61163 | 2093655.13931 | 37.7284661597625 | -122.461077839771 | (37.7284661597625, -122.461077839771) | 9 | 8 | 4 | 59 | 40 | |||
| 43158 | 227617 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | 10 | 7 | 7 | 28859 | 2 | |||
| 164798 | 37466 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | 10 | 7 | 7 | 28859 | 2 | ||
| 25613 | 37524 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1154 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779577 | 6007313.66795 | 2115327.60271 | 37.7886994328701 | -122.418522478123 | (37.7886994328701, -122.418522478123) | 13 | 9 | 10 | 28858 | 21 |
| 131351 | 61519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | 5 | 1 | 1 | 28858 | 32 | ||
| 190301 | 227657 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 117 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001570.04877 | 2106180.8326 | 37.7632596788053 | -122.437739171852 | (37.7632596788053, -122.437739171852) | 15 | 5 | 5 | 28862 | 3 | |||
| 187695 | 49756 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.7176031885257 | -122.402648943989 | (37.7176031885257, -122.402648943989) | 10 | 7 | 8 | 309 | 39 | |
| 109190 | 34272 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
| 180161 | 34271 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
| 141908 | 50485 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.7204059497171 | -122.454008375647 | (37.7204059497171, -122.454008375647) | 9 | 8 | 6 | 28861 | 24 | ||
| 1422 | 259801 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 11502 | 259802 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 18615 | 259800 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 43906 | 227618 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009077.39378 | 2097965.31988 | 37.7411257345706 | -122.411193275964 | (37.7411257345706, -122.411193275964) | 10 | 7 | 7 | 28859 | 2 | |||
| 68049 | 129448 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008230.44958 | 2115909.44994 | 37.7903486123517 | -122.415391745646 | (37.7903486123517, -122.415391745646) | 5 | 1 | 10 | 28858 | 21 | |||
| 102200 | 129447 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008246.65377 | 2115911.69756 | 37.7903556945065 | -122.415335839278 | (37.7903556945065, -122.415335839278) | 5 | 1 | 10 | 28858 | 21 | |||
| 142096 | 57397 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.415186043726 | (37.7903739066804, -122.415186043726) | 5 | 1 | 10 | 28858 | 21 | ||
| 191762 | 227619 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1193 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008092.35309 | 2100991.6752 | 37.7493801403813 | -122.414813334067 | (37.7493801403813, -122.414813334067) | 2 | 4 | 7 | 28859 | 19 | |||
| 62609 | 52479 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | 10 | 7 | 7 | 28859 | 2 | ||
| 111065 | 186817 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1200 Sunset Blvd | 110 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984826.8059 | 2106810.865 | 37.7640233139964 | -122.495694129376 | (37.7640233139964, -122.495694129376) | 1 | 8 | 3 | 56 | 35 | |||
| 2463 | 227603 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.07862 | 2096101.18791 | 37.7357497087738 | -122.42687342979 | (37.7357497087738, -122.42687342979) | 2 | 7 | 5 | 28861 | 2 | ||||
| 27188 | 227606 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | 2 | 7 | 5 | 28861 | 2 | ||||
| 56859 | 227608 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | 2 | 7 | 5 | 28861 | 2 | ||||
| 81506 | 227602 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 54 | Front Yard : Yard | Tree | Private 2 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657888 | -122.426906353066 | (37.735757657888, -122.426906353066) | 2 | 7 | 5 | 28861 | 2 | ||||
| 93391 | 227607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 61 | Front Yard : Yard | Tree | Private 2 | 2 | 6004513.17713 | 2096122.0643 | 37.7358075450783 | -122.426843458979 | (37.7358075450783, -122.426843458979) | 2 | 7 | 5 | 28861 | 2 | ||||
| 97150 | 227604 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 57 | Front Yard : Yard | Tree | Private 2 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | 2 | 7 | 5 | 28861 | 2 | ||||
| 101466 | 227605 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.61589 | 2096121.06345 | 37.7358043129022 | -122.426872987299 | (37.7358043129022, -122.426872987299) | 2 | 7 | 5 | 28861 | 2 | ||||
| 109016 | 176962 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 121 Saint Charles Ave | 1 | : | Tree | Private 2 | 12 | Width 2ft | 5992069.06615 | 2087619.04288 | 37.7117488798662 | -122.469248551103 | (37.7117488798662, -122.469248551103) | 9 | 8 | 4 | 64 | 24 | |||
| 83215 | 32892 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) | 11 | 5 | 11 | 56 | 12 |
| 20511 | 48733 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.7642109391741 | -122.489081723593 | (37.7642109391741, -122.489081723593) | 1 | 8 | 3 | 56 | 35 | ||
| 133271 | 62984 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 7 | Permit Number 33034 | 5984571.8482 | 2106766.3839 | 37.7638862475145 | -122.496572656852 | (37.7638862475145, -122.496572656852) | 1 | 8 | 3 | 56 | 35 | |
| 48165 | 50231 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | 1 | 8 | 3 | 56 | 35 | |
| 138875 | 181607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1255 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5987053.8771 | 2106742.5422 | 37.7639658865787 | -122.487986427971 | (37.7639658865787, -122.487986427971) | 1 | 8 | 3 | 56 | 35 | |||
| 112569 | 129450 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1257 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6006338.43207 | 2120038.90392 | 37.8015805322681 | -122.422231514268 | (37.8015805322681, -122.422231514268) | 13 | 9 | 1 | 28858 | 32 | |||
| 170885 | 109806 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.470479988054 | (37.764483341532, -122.470479988054) | 11 | 8 | 11 | 56 | 12 |
| 178429 | 207051 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992092.81688 | 2106815.43538 | 37.764458690039 | -122.470563705269 | (37.764458690039, -122.470563705269) | 11 | 8 | 11 | 56 | 12 | |||
| 75574 | 199962 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018011.037 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | 10 | 3 | 8 | 58 | 1 | |||
| 37381 | 207050 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | 11 | 8 | 3 | 56 | 12 | |||
| 7878 | 259091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 13366 | 259090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 14717 | 259092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 16225 | 227612 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1299 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010076.05716 | 2101688.52056 | 37.7514047850101 | -122.408002743036 | (37.7514047850101, -122.408002743036) | 2 | 4 | 7 | 28859 | 19 | |||
| 79185 | 199935 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1310 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017874.9241 | 2092620.1152 | 37.7269383150479 | -122.380402857754 | (37.7269383150479, -122.380402857754) | 10 | 3 | 8 | 58 | 1 | |||
| 172622 | 129446 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1329 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008344.2402 | 2117236.00141 | 37.7939973921104 | -122.415091973713 | (37.7939973921104, -122.415091973713) | 5 | 1 | 10 | 28858 | 21 | |||
| 133324 | 227621 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1335 Douglass St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6001398.3282 | 2099807.15248 | 37.7457493236871 | -122.437876554075 | (37.7457493236871, -122.437876554075) | 2 | 4 | 5 | 63 | 22 | |||
| 8854 | 75284 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | 10 | 3 | 8 | 58 | 1 | |||
| 93478 | 129444 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1338 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008418.05988 | 2116953.62618 | 37.7932262072758 | -122.414816555443 | (37.7932262072758, -122.414816555443) | 5 | 1 | 10 | 28858 | 21 | |||
| 96564 | 227615 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005000.95492 | 2099622.04361 | 37.7454452619845 | -122.42540601408 | (37.7454452619845, -122.42540601408) | 2 | 7 | 5 | 63 | 22 | |||
| 104978 | 48988 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2002 12:00:00 AM | Permit Number 46175 | 6005014.67029629 | 2099626.41666977 | 37.7454580443014 | -122.4253588996 | (37.7454580443014, -122.4253588996) | 2 | 7 | 5 | 63 | 22 | ||
| 66527 | 176969 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Craut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004020.786 | 2094067.71187 | 37.7301389032718 | -122.428399470475 | (37.7301389032718, -122.428399470475) | 9 | 7 | 6 | 28861 | 5 | |||
| 148558 | 176967 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Craut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004019.42662 | 2094104.53584 | 37.7302399367234 | -122.428406793639 | (37.7302399367234, -122.428406793639) | 9 | 7 | 6 | 28861 | 5 |
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) );