trees
2,421 rows where qSpecies_id = 8 sorted by qCaretaker_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144392 | 87531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3508X San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6012093.266153 | 2089389.252949 | 37.7177463042476 | -122.400163247094 | (37.7177463042476, -122.400163247094) | 10 | 7 | 8 | 309 | 39 | ||
146084 | 90189 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1844 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989807.27253 | 2111298.22245 | 37.7766347733404 | -122.478796570506 | (37.7766347733404, -122.478796570506) | 11 | 6 | 2 | 55 | 26 | ||
146668 | 90179 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1612 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990564.13249 | 2111328.53275 | 37.7767619152597 | -122.476180612609 | (37.7767619152597, -122.476180612609) | 11 | 6 | 2 | 55 | 26 | ||
147588 | 22920 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006146.18632 | 2107684.74759 | 37.767648213805 | -122.422018642617 | (37.767648213805, -122.422018642617) | 8 | 4 | 7 | 28853 | 19 | |||
148298 | 91004 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2421 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5988014.81063 | 2111176.25764 | 37.7761956494206 | -122.484988192411 | (37.7761956494206, -122.484988192411) | 11 | 6 | 2 | 55 | 26 | ||
148862 | 21341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
150157 | 85520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 3 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
151288 | 90216 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2440 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987916.1754 | 2111227.96813 | 37.7763318862341 | -122.485333189524 | (37.7763318862341, -122.485333189524) | 11 | 6 | 2 | 55 | 26 | ||
152020 | 90331 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1821 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989897.56523 | 2111248.76817 | 37.7765042280072 | -122.478480607879 | (37.7765042280072, -122.478480607879) | 11 | 6 | 2 | 55 | 26 | ||
153244 | 176248 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012084.62968 | 2089393.6592 | 37.7177579213627 | -122.400193408991 | (37.7177579213627, -122.400193408991) | 10 | 7 | 8 | 309 | 39 | ||
154045 | 85524 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 6008760.539184 | 2108527.457431 | 37.7701092002187 | -122.413035486584 | (37.7701092002187, -122.413035486584) | 8 | 2 | 9 | 28853 | 19 | |||
154413 | 90167 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5991524.58191 | 2111361.68634 | 37.7769085941456 | -122.472860582152 | (37.7769085941456, -122.472860582152) | 11 | 6 | 2 | 54 | 26 | ||
154718 | 26418 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1438 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 3 | 3 | 6015934.46626 | 2094872.09535 | 37.733014540811 | -122.387268060397 | (37.733014540811, -122.387268060397) | 10 | 3 | 8 | 58 | 1 | ||
154975 | 22919 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6006146.38467 | 2107662.66758 | 37.7675875985285 | -122.422016387826 | (37.7675875985285, -122.422016387826) | 8 | 4 | 7 | 28853 | 19 | |||
156569 | 26634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 959X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 3 | 3x3 | 6010948.2451591 | 2094911.3215655 | 37.7328448487082 | -122.404509586514 | (37.7328448487082, -122.404509586514) | 10 | 3 | 8 | 58 | 1 | ||
156822 | 4390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 56 Chilton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | 2 | 7 | 5 | 63 | 7 | |||
159134 | 85529 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 101 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 6 | 3x3 | 6007351.89443 | 2109342.45047 | 37.7722678019432 | -122.417965767207 | (37.7722678019432, -122.417965767207) | 8 | 2 | 9 | 28853 | 19 | ||
160291 | 90333 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990096.08573 | 2111253.98064 | 37.7765300633083 | -122.477794257242 | (37.7765300633083, -122.477794257242) | 11 | 6 | 2 | 55 | 26 | ||
160841 | 90351 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992345.34525 | 2111334.78441 | 37.7768822094186 | -122.470019378014 | (37.7768822094186, -122.470019378014) | 11 | 6 | 2 | 54 | 11 | ||
161015 | 123752 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2018 12:00:00 AM | 3 | Width 3ft | 5995621.16362 | 2110827.61225 | 37.77567847155 | -122.458650677058 | (37.77567847155, -122.458650677058) | 11 | 6 | 2 | 54 | 11 | ||
161241 | 90180 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1630 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990474.44986 | 2111322.51161 | 37.7767401818998 | -122.476490408326 | (37.7767401818998, -122.476490408326) | 11 | 6 | 2 | 55 | 26 | ||
161508 | 91021 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 30 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006519.340216 | 2109351.489576 | 37.7722457294122 | -122.420846293315 | (37.7722457294122, -122.420846293315) | 8 | 2 | 9 | 28853 | 19 | ||
162356 | 90214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2430 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5988003.75332 | 2111229.14654 | 37.7763402234557 | -122.485030323404 | (37.7763402234557, -122.485030323404) | 11 | 6 | 2 | 55 | 26 | ||
163366 | 26556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 228 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/09/1998 12:00:00 AM | 12 | 3x3 | 6011088.04001 | 2099355.12223 | 37.7450543887552 | -122.404338947303 | (37.7450543887552, -122.404338947303) | 10 | 3 | 7 | 58 | 2 | ||
165019 | 90434 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006339.227867 | 2109481.166325 | 37.7725916370239 | -122.42147852996 | (37.7725916370239, -122.42147852996) | 8 | 2 | 9 | 28853 | 19 | ||
166323 | 26112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1509 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015459.73624 | 2095054.56513 | 37.7334892639404 | -122.388922075695 | (37.7334892639404, -122.388922075695) | 10 | 3 | 8 | 58 | 1 | ||
166708 | 26100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.389944222732 | (37.7342605555935, -122.389944222732) | 10 | 3 | 8 | 58 | 1 | |||
166764 | 96201 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
167142 | 90162 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1000X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992470.47116 | 2111395.13018 | 37.7770551349921 | -122.469590927435 | (37.7770551349921, -122.469590927435) | 11 | 6 | 2 | 54 | 11 | ||
167839 | 90332 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1751 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990079.80484 | 2111253.67647 | 37.7765282832532 | -122.477850554666 | (37.7765282832532, -122.477850554666) | 11 | 6 | 2 | 55 | 26 | ||
167942 | 28261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3574 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 6012138.7194258 | 2089093.5243211 | 37.7169368272436 | -122.399985378545 | (37.7169368272436, -122.399985378545) | 10 | 7 | 8 | 309 | 39 | ||
168367 | 14641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.7799040650672 | -122.422330778736 | (37.7799040650672, -122.422330778736) | 7 | 9 | 11 | 28852 | 41 | ||
169765 | 90221 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2550 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5987624.2052 | 2111222.01926 | 37.7762985386745 | -122.486342745884 | (37.7762985386745, -122.486342745884) | 11 | 6 | 2 | 55 | 26 | ||
170210 | 176249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3500 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 1 | Width 3ft | 6012088.82637 | 2089370.3173 | 37.7176940632127 | -122.400177264384 | (37.7176940632127, -122.400177264384) | 10 | 7 | 8 | 309 | 39 | ||
170653 | 90541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 550X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993951.099186 | 2110760.95535 | 37.7753993224191 | -122.464422957483 | (37.7753993224191, -122.464422957483) | 11 | 6 | 2 | 54 | 11 | ||
171133 | 90439 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 48X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 3 | 3x3 | 6006368.067431 | 2109508.884182 | 37.7726693696552 | -122.421380739497 | (37.7726693696552, -122.421380739497) | 8 | 2 | 9 | 28853 | 19 | ||
172951 | 90345 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1419 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991167.27409 | 2111290.13504 | 37.7766914424564 | -122.474091384602 | (37.7766914424564, -122.474091384602) | 11 | 6 | 2 | 54 | 26 | ||
172955 | 26119 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015692.20395 | 2094932.76911 | 37.7331677192347 | -122.388109864863 | (37.7331677192347, -122.388109864863) | 10 | 3 | 8 | 58 | 1 | ||
177552 | 90549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 908 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992785.51591 | 2110727.39305 | 37.7752399121234 | -122.468452505936 | (37.7752399121234, -122.468452505936) | 11 | 6 | 2 | 54 | 11 | ||
178295 | 2782 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 410 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994308.62023 | 2110783.41218 | 37.7754815851777 | -122.463187847484 | (37.7754815851777, -122.463187847484) | 11 | 6 | 2 | 54 | 11 | ||
179244 | 90177 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990761.33941 | 2111332.28389 | 37.7767836486138 | -122.475498696085 | (37.7767836486138, -122.475498696085) | 11 | 6 | 2 | 54 | 26 | ||
180269 | 90907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993039.18023 | 2110679.45973 | 37.7751229489473 | -122.46757154432 | (37.7751229489473, -122.46757154432) | 11 | 6 | 2 | 54 | 11 | ||
181047 | 253628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
181705 | 90323 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989481.72771 | 2111237.09883 | 37.7764480366161 | -122.479918238394 | (37.7764480366161, -122.479918238394) | 11 | 6 | 2 | 55 | 26 | ||
182780 | 90908 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 743 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993344.60696 | 2110686.93317 | 37.7751610983623 | -122.466515557611 | (37.7751610983623, -122.466515557611) | 11 | 6 | 2 | 54 | 11 | ||
183538 | 21343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
184301 | 4333 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 5X Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001761.4698131 | 2095822.8308427 | 37.7348299498779 | -122.436335765698 | (37.7348299498779, -122.436335765698) | 2 | 7 | 5 | 63 | 7 | |||
185944 | 123751 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5995599.55133 | 2110826.05638 | 37.7756729573693 | -122.458725326168 | (37.7756729573693, -122.458725326168) | 11 | 6 | 2 | 54 | 11 | ||
186285 | 90322 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989457.99472 | 2111233.88007 | 37.7764378199226 | -122.480000100994 | (37.7764378199226, -122.480000100994) | 11 | 6 | 2 | 55 | 26 | ||
186436 | 90544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5993430.86154 | 2110749.39946 | 37.7753375909806 | -122.466221726766 | (37.7753375909806, -122.466221726766) | 11 | 6 | 2 | 54 | 11 | ||
186715 | 90190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1844 Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.55594 | 37.7766347733354 | -122.478851145848 | (37.7766347733354, -122.478851145848) | 11 | 6 | 2 | 55 | 26 | |||
187709 | 28242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | 7 | 9 | 11 | 29492 | 10 | ||
187749 | 90338 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990591.656258 | 2111279.589406 | 37.7766291263166 | -122.47608182516 | (37.7766291263166, -122.47608182516) | 11 | 6 | 2 | 55 | 26 | ||
188285 | 91001 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2501 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987771.13659 | 2111168.45411 | 37.7761600268515 | -122.485830543565 | (37.7761600268515, -122.485830543565) | 11 | 6 | 2 | 55 | 26 | ||
188405 | 90344 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1431 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991109.30378 | 2111288.54899 | 37.7766837293707 | -122.474291803216 | (37.7766837293707, -122.474291803216) | 11 | 6 | 2 | 54 | 26 | ||
189088 | 90545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5993401.41379 | 2110748.94947 | 37.7753346563587 | -122.466323559806 | (37.7753346563587, -122.466323559806) | 11 | 6 | 2 | 54 | 11 | ||
189658 | 224100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2x Gough St | 4 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006621.45587 | 2109260.75005 | 37.7720023355618 | -122.420486623569 | (37.7720023355618, -122.420486623569) | 8 | 2 | 9 | 28853 | 19 | |||
190833 | 90349 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992315.42608 | 2111334.89456 | 37.7768807822567 | -122.470122884589 | (37.7768807822567, -122.470122884589) | 11 | 6 | 2 | 54 | 11 | ||
191832 | 5105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2638 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2002 12:00:00 AM | 3 | 3X3 | 6002275.8937 | 2096498.71459 | 37.7367149871144 | -122.434605539024 | (37.7367149871144, -122.434605539024) | 2 | 7 | 5 | 63 | 7 | ||
192708 | 15051 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | 10 | 3 | 8 | 58 | 1 | ||
193351 | 90346 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1351X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991366.65333 | 2111298.67818 | 37.7767264470425 | -122.473402303093 | (37.7767264470425, -122.473402303093) | 11 | 6 | 2 | 54 | 26 | ||
10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
499 | 180799 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Mount Vernon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 8x8 | Permit Number 782754 | 5998557.73755 | 2089669.84713 | 37.7177527376786 | -122.446969503064 | (37.7177527376786, -122.446969503064) | 9 | 7 | 6 | 28861 | 25 | |
806 | 189267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Fairfax Ave | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6017011.55747 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | 10 | 3 | 8 | 58 | 1 | |||
814 | 261435 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 371 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007244 | 2095778 | 37.7350168462428 | -122.417377534221 | (37.7350168462428, -122.417377534221) | 2 | 7 | 7 | 28859 | 2 | ||||
893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
908 | 207538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993510.99578 | 2106611.92865 | 37.7639818164203 | -122.465643867796 | (37.7639818164203, -122.465643867796) | 1 | 8 | 11 | 56 | 12 | |||
1004 | 50532 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47171 | 5996679.82856356 | 2106618.62344586 | 37.7641824656847 | -122.454684361894 | (37.7641824656847, -122.454684361894) | 15 | 5 | 11 | 29492 | 12 | |||
1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
1085 | 223588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x Jarboe Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6009063.07444 | 2096876.26549 | 37.7381346254237 | -122.411165877211 | (37.7381346254237, -122.411165877211) | 10 | 7 | 7 | 28859 | 2 | |||
1123 | 72265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 358 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002353.80444 | 2091524.36294 | 37.7230609707806 | -122.433980702666 | (37.7230609707806, -122.433980702666) | 9 | 7 | 6 | 28861 | 5 | |||
1140 | 223581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 85 Bessie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008353.87265 | 2100058.32291 | 37.7468320543491 | -122.413842976384 | (37.7468320543491, -122.413842976384) | 2 | 7 | 7 | 28859 | 2 | |||
1153 | 223389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1156 | 31893 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 333 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 8 | Permit Number 35323 | 6008432.94494 | 2108718.71395 | 37.7706159506067 | -122.414182168285 | (37.7706159506067, -122.414182168285) | 8 | 2 | 9 | 28853 | 19 | |
1161 | 223387 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 99x Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005306 | 2104928 | 37.7600314174308 | -122.424728608314 | (37.7600314174308, -122.424728608314) | 2 | 4 | 5 | 28859 | 19 | |||
1238 | 144982 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 676 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990689.31249 | 2110785.3324 | 37.7752776943529 | -122.4757079065 | (37.7752776943529, -122.4757079065) | 11 | 6 | 2 | 54 | 26 | ||
1268 | 261097 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 | ||
1308 | 52427 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004786.32091155 | 2115731.58720361 | 37.7896660673411 | -122.427295522794 | (37.7896660673411, -122.427295522794) | 13 | 9 | 11 | 28858 | 27 |
1327 | 261443 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007142 | 2095710 | 37.7348243937619 | -122.417725367022 | (37.7348243937619, -122.417725367022) | 2 | 7 | 7 | 28859 | 2 | ||||
1419 | 148015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 703 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002502.98722 | 2088786.72578 | 37.7155524923237 | -122.433269485517 | (37.7155524923237, -122.433269485517) | 9 | 7 | 6 | 28861 | 5 | |||
1423 | 223556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701x Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007456 | 2095683 | 37.7347679226533 | -122.416637845271 | (37.7347679226533, -122.416637845271) | 2 | 7 | 7 | 28859 | 2 | |||
1507 | 74233 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2400 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6010292.05063 | 2106000.69739 | 37.7632571481177 | -122.407559806245 | (37.7632571481177, -122.407559806245) | 8 | 4 | 8 | 28859 | 19 | |||
1530 | 191101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012369.93883 | 2101402.46492 | 37.7507475020033 | -122.400050093052 | (37.7507475020033, -122.400050093052) | 10 | 3 | 8 | 28856 | 1 | |||
1541 | 70231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6005265.5585 | 2110935.6138 | 37.7765246008409 | -122.425295984643 | (37.7765246008409, -122.425295984643) | 7 | 9 | 11 | 28852 | 10 | |||
1628 | 72055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2161 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6008082.6141 | 2119894.27994 | 37.8012816578905 | -122.416185586193 | (37.8012816578905, -122.416185586193) | 5 | 1 | 1 | 308 | 32 | |||
1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
1997 | 61779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 9 | Permit Number 21800 | 6011831.44367 | 2102306.03776 | 37.7531984774519 | -122.401975779864 | (37.7531984774519, -122.401975779864) | 10 | 3 | 8 | 28856 | 29 | |
2148 | 154032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1662 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014879.40227 | 2097032.81009 | 37.7388889362706 | -122.391066694069 | (37.7388889362706, -122.391066694069) | 10 | 3 | 8 | 58 | 1 | |||
2215 | 49868 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
2303 | 223507 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006548.17508 | 2102589.95451 | 37.7536817641104 | -122.420266570244 | (37.7536817641104, -122.420266570244) | 2 | 4 | 7 | 28859 | 19 | |||
2337 | 223401 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3647 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6005476.77928 | 2102530.01598 | 37.7534567573481 | -122.423967438743 | (37.7534567573481, -122.423967438743) | 2 | 4 | 5 | 28859 | 19 | |||
2408 | 162789 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 237 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996026.23717 | 2090535.13208 | 37.71998365171 | -122.455782228671 | (37.71998365171, -122.455782228671) | 9 | 8 | 6 | 28861 | 24 | |||
2430 | 224109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006481.46308 | 2109309.64111 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) | 8 | 2 | 9 | 28853 | 19 | |||
2450 | 251744 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 70 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002620 | 2086992 | 37.710631205907 | -122.432736905509 | (37.710631205907, -122.432736905509) | 9 | 7 | 6 | 28861 | 5 | ||||
2532 | 72297 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 463 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002248.50751 | 2090769.44278 | 37.7209821527804 | -122.434290747523 | (37.7209821527804, -122.434290747523) | 9 | 7 | 6 | 28861 | 5 | |||
2581 | 170684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400X San Juan Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2020 12:00:00 AM | 3 | Width 3ft | 6000643.43225 | 2092709.34496 | 37.7262174472681 | -122.439978026889 | (37.7262174472681, -122.439978026889) | 9 | 7 | 6 | 28861 | 25 | ||
2884 | 46077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 814 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2001 12:00:00 AM | Permit Number 44458 | 6003949.63841524 | 2110800.90118746 | 37.7760802817088 | -122.429838518249 | (37.7760802817088, -122.429838518249) | 7 | 9 | 11 | 29492 | 10 | |||
3110 | 126516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3449 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5997745.83933 | 2116374.85745 | 37.7910316321555 | -122.451701179872 | (37.7910316321555, -122.451701179872) | 11 | 6 | 1 | 54 | 31 | |||
3218 | 84023 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 309 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 773233 | 6004808.26935881 | 2101900.57071737 | 37.7516906826671 | -122.42623448013 | (37.7516906826671, -122.42623448013) | 2 | 4 | 5 | 28862 | 22 |
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) );