trees
953 rows where qSpecies_id = 60 sorted by qLegalStatus_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30698 | 125889 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.422573634365 | (37.781778500422, -122.422573634365) | 7 | 9 | 11 | 28852 | 41 | |||
31225 | 204651 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 27 Majestic Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.450979745524 | (37.7179774953307, -122.450979745524) | 9 | 8 | 6 | 28861 | 24 | |||
31303 | 188306 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015455.75158 | 2106081.00048 | 37.7637653298293 | -122.38970572754 | (37.7637653298293, -122.38970572754) | 14 | 3 | 8 | 28856 | 29 | |||
31918 | 222594 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1701 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003405.54742 | 2098267.585 | 37.7416359640346 | -122.430826033811 | (37.7416359640346, -122.430826033811) | 2 | 7 | 5 | 63 | 7 | |||
32080 | 175788 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008132.91971 | 2093497.94914 | 37.7288062932694 | -122.414142956056 | (37.7288062932694, -122.414142956056) | 9 | 3 | 7 | 309 | 28 | |||
32161 | 123707 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 698 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 5993511.46751 | 2111432.07 | 37.7772166713285 | -122.465992510852 | (37.7772166713285, -122.465992510852) | 11 | 6 | 2 | 54 | 11 | |||
32334 | 221326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005468.19863 | 2101476.92488 | 37.7505647282985 | -122.423922233444 | (37.7505647282985, -122.423922233444) | 2 | 4 | 5 | 28859 | 19 | |||
32778 | 47219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | 9 | 3 | 7 | 309 | 28 | |
32876 | 188339 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.404294355303 | (37.7324490889606, -122.404294355303) | 10 | 3 | 8 | 58 | 1 | |||
33277 | 69157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | 1 | 8 | 3 | 56 | 35 | |
33970 | 181677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2704 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987307.2214 | 2106457.8989 | 37.7631991100618 | -122.487089290148 | (37.7631991100618, -122.487089290148) | 1 | 8 | 3 | 56 | 35 | |||
34069 | 247043 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 596 Valley St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6002094.89222 | 2099164.93967 | 37.7440255436471 | -122.435422008318 | (37.7440255436471, -122.435422008318) | 2 | 7 | 5 | 63 | 22 | ||||
34267 | 188311 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | 14 | 3 | 8 | 28856 | 29 | |||
34401 | 27126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2095X Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259 | 2096047.4553772 | 37.7360458965855 | -122.399543203223 | (37.7360458965855, -122.399543203223) | 10 | 3 | 8 | 58 | 1 | ||
34465 | 222549 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.7406038022373 | -122.417680295405 | (37.7406038022373, -122.417680295405) | 2 | 7 | 7 | 28859 | 2 | |||
34470 | 188309 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012912.61356 | 2106204.46931 | 37.763962999013 | -122.398510384468 | (37.763962999013, -122.398510384468) | 14 | 3 | 8 | 28856 | 29 | |||
34526 | 22825 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/1993 12:00:00 AM | 25 | 3X3 | 5999298.50958 | 2099073.67343 | 37.7436157369876 | -122.445084674243 | (37.7436157369876, -122.445084674243) | 2 | 7 | 5 | 63 | 7 | ||
34591 | 251286 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 02/09/1998 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
34856 | 188343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6012604.8118 | 2096159.09388 | 37.7363634115335 | -122.398869919026 | (37.7363634115335, -122.398869919026) | 10 | 3 | 8 | 58 | 1 | |||
35110 | 188332 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013443.088 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | 14 | 3 | 8 | 28856 | 29 | |||
35216 | 204656 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 201 Sargent St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5993464.3561 | 2089166.28112 | 37.7160777557502 | -122.464538359982 | (37.7160777557502, -122.464538359982) | 9 | 8 | 6 | 64 | 24 | |||
35674 | 222588 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4380 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000121.81513 | 2105788.1369 | 37.762098979601 | -122.44271991951 | (37.762098979601, -122.44271991951) | 15 | 5 | 5 | 28862 | 3 | |||
36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
36265 | 181761 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989269.0192 | 2106863.9805 | 37.7644282944678 | -122.480333887539 | (37.7644282944678, -122.480333887539) | 1 | 8 | 3 | 56 | 35 | |||
37203 | 143861 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985565.10939 | 2113174.24077 | 37.7815385460111 | -122.493609507183 | (37.7815385460111, -122.493609507183) | 11 | 6 | 2 | 55 | 26 | ||
37364 | 175787 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 913 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008123.23514 | 2093495.17198 | 37.7287981238093 | -122.414176239965 | (37.7287981238093, -122.414176239965) | 9 | 3 | 7 | 309 | 28 | |||
37366 | 181746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989272.8487 | 2106849.4285 | 37.7643885611619 | -122.480319577317 | (37.7643885611619, -122.480319577317) | 1 | 8 | 3 | 56 | 35 | |||
37552 | 101159 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013387.24003 | 2105243.87751 | 37.7613518552239 | -122.396801432457 | (37.7613518552239, -122.396801432457) | 10 | 3 | 8 | 28856 | 29 | |||
37578 | 221355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008404.74116 | 2103860.62661 | 37.757275180723 | -122.413936009452 | (37.757275180723, -122.413936009452) | 2 | 4 | 7 | 28859 | 19 | |||
37723 | 96932 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011002.04218 | 2094782.56307 | 37.7324943113535 | -122.404314536086 | (37.7324943113535, -122.404314536086) | 10 | 3 | 8 | 58 | 1 | |||
37810 | 222597 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002444.78145 | 2096589.20481 | 37.7369730385666 | -122.434028087935 | (37.7369730385666, -122.434028087935) | 2 | 7 | 5 | 63 | 7 | |||
37830 | 31102 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 215 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34832 | 6000072.59523 | 2094462.74015 | 37.7309993521219 | -122.442077177628 | (37.7309993521219, -122.442077177628) | 9 | 7 | 4 | 63 | 40 | |
39230 | 222571 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001358.40825 | 2101420.45569 | 37.7501768003212 | -122.438130138611 | (37.7501768003212, -122.438130138611) | 2 | 4 | 5 | 28862 | 22 | |||
39368 | 43890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.7758395125283 | -122.41192485917 | (37.7758395125283, -122.41192485917) | 8 | 2 | 9 | 28853 | 34 | ||
39556 | 26989 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1327 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009306.59459 | 2094318.78355 | 37.7311259838562 | -122.410143394801 | (37.7311259838562, -122.410143394801) | 9 | 3 | 7 | 309 | 28 | ||
39796 | 222546 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2825 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002452.45425 | 2095510.12485 | 37.734010568315 | -122.433924450977 | (37.734010568315, -122.433924450977) | 2 | 7 | 5 | 63 | 7 | |||
40262 | 221321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | 2 | 4 | 5 | 28859 | 19 | |||
40526 | 121353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.7641755703197 | -122.496596073864 | (37.7641755703197, -122.496596073864) | 1 | 8 | 3 | 56 | 35 | ||
41037 | 2244 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 15X Brompton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002231.00143 | 2095678.63178 | 37.7344606799209 | -122.434702126219 | (37.7344606799209, -122.434702126219) | 2 | 7 | 5 | 63 | 7 | |||
41211 | 188316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.400058184238 | (37.7578394396596, -122.400058184238) | 10 | 3 | 8 | 28856 | 29 | |||
42079 | 252895 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282 | 2090432 | 37.7197724640349 | -122.45143407539 | (37.7197724640349, -122.45143407539) | 9 | 8 | 6 | 28861 | 24 | ||
42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
42376 | 27049 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 910 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3x3 | 6007348.52678 | 2093482.21971 | 37.7287190140661 | -122.416853547777 | (37.7287190140661, -122.416853547777) | 9 | 3 | 7 | 309 | 5 | ||
42439 | 221348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.417896696594 | (37.7380362287807, -122.417896696594) | 2 | 7 | 7 | 28859 | 2 | |||
43425 | 222591 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 310 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003760.57016 | 2108690.93214 | 37.7702761156764 | -122.430341981792 | (37.7702761156764, -122.430341981792) | 15 | 9 | 11 | 29492 | 10 | |||
43444 | 188313 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 299 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012940.76459 | 2105761.15041 | 37.7627473116745 | -122.398381910012 | (37.7627473116745, -122.398381910012) | 14 | 3 | 8 | 28856 | 29 | |||
43630 | 26977 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 526 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6004737.76851 | 2093468.91574 | 37.728535287917 | -122.425878161452 | (37.728535287917, -122.425878161452) | 9 | 7 | 6 | 28861 | 5 | ||
44101 | 4392 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.7345352795846 | -122.436474498408 | (37.7345352795846, -122.436474498408) | 2 | 7 | 5 | 63 | 7 | |||
44198 | 27203 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2001 12:00:00 AM | 6 | 3X3 | 6003520.15249 | 2093475.1012 | 37.7284833853765 | -122.430087965589 | (37.7284833853765, -122.430087965589) | 9 | 7 | 6 | 28861 | 5 | ||
44295 | 204649 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 508 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5994044.08453 | 2090032.62859 | 37.7184899416364 | -122.46259736577 | (37.7184899416364, -122.46259736577) | 9 | 8 | 6 | 28861 | 24 | |||
44456 | 37238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.7557291928217 | -122.48675431687 | (37.7557291928217, -122.48675431687) | 1 | 8 | 3 | 56 | 35 | ||
44477 | 204639 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.447788509344 | (37.7273803570158, -122.447788509344) | 9 | 7 | 4 | 28861 | 40 | ||||
44525 | 27187 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 250 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 6 | 2X3 | 6002862.24087 | 2093754.97277 | 37.7292145657007 | -122.432382378945 | (37.7292145657007, -122.432382378945) | 9 | 7 | 6 | 28861 | 25 | ||
44825 | 52659 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280509 | (37.8056520959413, -122.44242280509) | 13 | 9 | 1 | 57 | 17 | ||
44831 | 125887 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006289.37196 | 2113344.72886 | 37.7831972322057 | -122.421925487583 | (37.7831972322057, -122.421925487583) | 7 | 9 | 11 | 28858 | 41 | |||
45337 | 251284 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 06/21/1996 12:00:00 AM | 3x3 | 6017207 | 2095414 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | 10 | 3 | 8 | 58 | 1 | ||
45571 | 244276 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 480 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | 7 | 9 | 11 | 28852 | 10 | |||
45604 | 204647 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5996124.76777 | 2089322.40375 | 37.7166594390698 | -122.455354045254 | (37.7166594390698, -122.455354045254) | 9 | 8 | 6 | 28861 | 24 | |||
45916 | 175782 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.7290892244848 | -122.419690364741 | (37.7290892244848, -122.419690364741) | 9 | 7 | 7 | 309 | 5 | |||
46332 | 27197 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003357.92548 | 2093496.29859 | 37.7285323993286 | -122.430650304475 | (37.7285323993286, -122.430650304475) | 9 | 7 | 6 | 28861 | 5 | ||
46413 | 218271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1456 Portola Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 5ft | 5992773.33281 | 2097243.56743 | 37.7382161345768 | -122.467513887457 | (37.7382161345768, -122.467513887457) | 1 | 8 | 4 | 59 | 40 | |||
46632 | 21528 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.82958 | 2114935.40618 | 37.7875609181413 | -122.422279128893 | (37.7875609181413, -122.422279128893) | 13 | 9 | 1 | 28858 | 41 | ||
47063 | 124082 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993384.86337 | 2110069.41246 | 37.7734678747583 | -122.466331413768 | (37.7734678747583, -122.466331413768) | 11 | 6 | 2 | 54 | 11 | |||
47354 | 18799 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 36 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017963.3534873 | 2094445.0871971 | 37.7319542116677 | -122.380223926679 | (37.7319542116677, -122.380223926679) | 10 | 3 | 8 | 58 | 1 | |||
47358 | 27206 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 302 Silver Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003601.03384 | 2093471.82188 | 37.7284789616114 | -122.429808120849 | (37.7284789616114, -122.429808120849) | 9 | 7 | 6 | 28861 | 5 | ||
47527 | 204634 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 451 Hearst Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998426.77789 | 2094369.13977 | 37.7306484177936 | -122.44776028591 | (37.7306484177936, -122.44776028591) | 9 | 7 | 4 | 28861 | 40 | |||
47848 | 175757 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003296.85898 | 2090487.74665 | 37.7202681261541 | -122.430646818702 | (37.7202681261541, -122.430646818702) | 9 | 7 | 6 | 28861 | 5 | |||
48420 | 27011 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1468 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010181.11487 | 2094586.49515 | 37.7319100425197 | -122.407138874981 | (37.7319100425197, -122.407138874981) | 10 | 3 | 7 | 309 | 28 | ||
48460 | 175792 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.7285379877196 | -122.409369173844 | (37.7285379877196, -122.409369173844) | 10 | 3 | 7 | 309 | 28 | |||
49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
49530 | 188327 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1810 23rd St | 2 | : | Tree | Private 2 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.7548568731497 | -122.398083326981 | (37.7548568731497, -122.398083326981) | 10 | 3 | 8 | 28856 | 29 | |||
50057 | 188346 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1716 Revere Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.392227779994 | (37.7329022519179, -122.392227779994) | 10 | 3 | 8 | 58 | 1 | |||
50910 | 222561 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | 2 | 7 | 7 | 28859 | 2 | |||
51550 | 175773 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990089.90179 | 2089410.48117 | 37.7165531625873 | -122.476219779021 | (37.7165531625873, -122.476219779021) | 1 | 8 | 4 | 64 | 14 | ||||
51674 | 221343 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | 15 | 5 | 11 | 29492 | 9 | |||
51972 | 254108 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3249 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4 | 5985350 | 2113144 | 37.781442927388 | -122.494351441891 | (37.781442927388, -122.494351441891) | 11 | 6 | 2 | 55 | 26 | ||
52154 | 26999 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6008714.80501 | 2094009.36438 | 37.7302431967539 | -122.412167462084 | (37.7302431967539, -122.412167462084) | 9 | 3 | 7 | 309 | 28 | ||
52425 | 204640 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 25 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998733.11218 | 2093060.00406 | 37.7270713418516 | -122.446607092452 | (37.7270713418516, -122.446607092452) | 9 | 7 | 4 | 28861 | 40 | |||
52469 | 183924 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2118 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5988539.4126 | 2100905.5456 | 37.7480256114084 | -122.482420751779 | (37.7480256114084, -122.482420751779) | 1 | 8 | 3 | 29491 | 35 | |||
52734 | 222578 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Hartford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002709.15868 | 2104802.31344 | 37.7595393031055 | -122.433700841745 | (37.7595393031055, -122.433700841745) | 2 | 4 | 5 | 28862 | 3 | |||
52807 | 123817 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1925 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992665.27685 | 2112027.39662 | 37.7788024241016 | -122.468963063439 | (37.7788024241016, -122.468963063439) | 11 | 6 | 2 | 54 | 11 | |||
52854 | 123824 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | 11 | 6 | 2 | 54 | 11 | |||
52915 | 188310 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012910.65853 | 2106249.78561 | 37.7640873186114 | -122.398520326465 | (37.7640873186114, -122.398520326465) | 14 | 3 | 8 | 28856 | 29 | |||
52992 | 4194 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004745.48765 | 2100483.94122 | 37.7477973974515 | -122.4263507348 | (37.7477973974515, -122.4263507348) | 2 | 4 | 5 | 63 | 22 | |||
53393 | 188350 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Dukes Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016183.29888 | 2096350.88685 | 37.7370887822104 | -122.386510848195 | (37.7370887822104, -122.386510848195) | 10 | 3 | 8 | 58 | 1 | |||
53895 | 175785 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006201.21806 | 2093598.82119 | 37.7289745752989 | -122.420828147413 | (37.7289745752989, -122.420828147413) | 9 | 7 | 6 | 28861 | 5 | |||
53960 | 47228 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.39624 | 2091994.05057 | 37.724845479317 | -122.403633167442 | (37.724845479317, -122.403633167442) | 10 | 3 | 7 | 309 | 28 | |
53975 | 10882 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
54841 | 27170 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2080 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012569.10474 | 2096085.04169 | 37.7361580900166 | -122.398988178079 | (37.7361580900166, -122.398988178079) | 10 | 3 | 8 | 58 | 1 | ||
55247 | 124076 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 701 Funston Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991934.28865 | 2110305.99584 | 37.7740336644487 | -122.471366355947 | (37.7740336644487, -122.471366355947) | 11 | 6 | 2 | 54 | 11 | |||
55248 | 96934 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 901 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010990.76512 | 2094811.66283 | 37.7325735829947 | -122.404355571269 | (37.7325735829947, -122.404355571269) | 10 | 3 | 8 | 58 | 1 | |||
55938 | 175783 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 771 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006465.53434 | 2093625.53998 | 37.7290628338846 | -122.419916279827 | (37.7290628338846, -122.419916279827) | 9 | 7 | 7 | 309 | 5 | |||
56097 | 188358 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1334 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017132.81962 | 2095655.66164 | 37.7352323503922 | -122.383179517428 | (37.7352323503922, -122.383179517428) | 10 | 3 | 8 | 58 | 1 | |||
56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
56273 | 43665 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296 | (37.7832926725519, -122.47097524296) | 11 | 6 | 2 | 54 | 11 | |
56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
56360 | 181646 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986485.3888 | 2106651.0455 | 37.7636814828681 | -122.489945903056 | (37.7636814828681, -122.489945903056) | 1 | 8 | 3 | 56 | 35 | |||
57614 | 25940 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2018 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2000 12:00:00 AM | 3 | 3x3 | 6012740.13667 | 2097232.43261 | 37.739318114344 | -122.398477333477 | (37.739318114344, -122.398477333477) | 10 | 3 | 8 | 58 | 1 | ||
57687 | 27191 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 270 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002970.12798 | 2093687.91706 | 37.729036562883 | -122.432004617843 | (37.729036562883, -122.432004617843) | 9 | 7 | 6 | 28861 | 25 | ||
57867 | 188291 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 40 Sheridan St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.7728575647512 | -122.410944589137 | (37.7728575647512, -122.410944589137) | 8 | 2 | 9 | 28853 | 34 |
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) );