Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
358 | 358 | 251286 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
375 | 375 | 251284 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/21/1996 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
385 | 385 | 251282 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 04/07/2016 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
392 | 392 | 251280 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
398 | 398 | 251281 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1275x Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/23/2006 12:00:00 AM | 3x3 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
402 | 402 | 251283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/06/1997 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
410 | 410 | 251287 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 02/09/1998 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
5851 | 5851 | 9507 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.42604476220501 | (37.7802522713917, -122.426044762205) | |||
10007 | 10007 | 99273 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | DPW for City Agency 2 | 02/01/2013 12:00:00 AM | 3 | 3x3 | 6002499.0 | 2095479.8 | 37.733929944538204 | -122.43376136145201 | (37.7339299445382, -122.433761361452) | |
10826 | 10826 | 27011 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1468 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6010181.11487 | 2094586.49515 | 37.7319100425197 | -122.407138874981 | (37.7319100425197, -122.407138874981) | ||
10857 | 10857 | 27206 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/2012 12:00:00 AM | 3 | 3X3 | 6003601.03384 | 2093471.82188 | 37.7284789616114 | -122.429808120849 | (37.7284789616114, -122.429808120849) | ||
10969 | 10969 | 26989 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1327 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009306.59459 | 2094318.78355 | 37.7311259838562 | -122.41014339480101 | (37.7311259838562, -122.410143394801) | ||
10976 | 10976 | 26998 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.41212466153499 | (37.7303936047791, -122.412124661535) | ||
11427 | 11427 | 27057 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 945 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 7 | 2X3 | 6007415.89764 | 2093543.05958 | 37.72888985646029 | -122.416624950003 | (37.7288898564603, -122.416624950003) | ||
11557 | 11557 | 27528 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/25/2002 12:00:00 AM | 3 | 6008310.55132 | 2093825.05625 | 37.729714434952506 | -122.413551995327 | (37.7297144349525, -122.413551995327) | |||
12081 | 12081 | 27218 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 393 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/10/1999 12:00:00 AM | 6 | 3x3 | 6004009.64112 | 2093507.9183200002 | 37.728601204683706 | -122.42839811609699 | (37.7286012046837, -122.428398116097) | ||
12742 | 12742 | 27190 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 266 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002951.03979 | 2093700.24177 | 37.729069321573604 | -122.432071486902 | (37.7290693215736, -122.432071486902) | ||
12768 | 12768 | 27200 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6003430.014219999 | 2093478.3653900002 | 37.728487242572605 | -122.430399810923 | (37.7284872425726, -122.430399810923) | ||
14326 | 14326 | 27149 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1735 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6011161.84153 | 2095168.8132099998 | 37.7335638013107 | -122.403789237593 | (37.7335638013107, -122.403789237593) | ||
15016 | 15016 | 27146 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011294.03802 | 2095268.15566 | 37.7338439590333 | -122.403339179952 | (37.7338439590333, -122.403339179952) | ||
15677 | 15677 | 27163 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1824 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1999 12:00:00 AM | 6 | 3X3 | 6011556.81745 | 2095410.2686400001 | 37.734248844606206 | -122.402440656527 | (37.7342488446062, -122.402440656527) | ||
17253 | 17253 | 26483 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2001 12:00:00 AM | 10 | 3X3 | 6001028.50664 | 2098685.10655 | 37.7426474144589 | -122.43907493846001 | (37.7426474144589, -122.43907493846) | ||
18107 | 18107 | 4392 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001719.13999 | 2095716.38889 | 37.734535279584605 | -122.43647449840799 | (37.7345352795846, -122.436474498408) | |||
18825 | 18825 | 3878 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 7 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2014 11:33:00 AM | 12 | 3X3 | 6002011.6108099995 | 2108665.28098 | 37.7701064612771 | -122.436389779582 | (37.7701064612771, -122.436389779582) | ||
20005 | 20005 | 9345 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 216 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/1992 12:00:00 AM | 25 | 2X2 | 6000780.1302 | 2098439.42056 | 37.7419586830354 | -122.439916138241 | (37.7419586830354, -122.439916138241) | ||
21100 | 21100 | 4336 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 870 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001641.12667 | 2095893.9772400002 | 37.7350184628259 | -122.436756924204 | (37.7350184628259, -122.436756924204) | |||
23127 | 23127 | 27661 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2211 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6012766.85578 | 2096252.7885099999 | 37.7366297052834 | -122.398316233412 | (37.7366297052834, -122.398316233412) | ||
80831 | 80831 | 26977 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 526 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6004737.76851 | 2093468.91574 | 37.728535287917 | -122.425878161452 | (37.728535287917, -122.425878161452) | ||
83301 | 83301 | 10882 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
84720 | 84720 | 18799 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 36 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017963.3534873 | 2094445.0871971 | 37.731954211667706 | -122.380223926679 | (37.7319542116677, -122.380223926679) | |||
85326 | 85326 | 106091 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6017390.0 | 2095089.0 | 37.733690618402704 | -122.382250932174 | (37.7336906184027, -122.382250932174) | |||
85541 | 85541 | 30142 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 410X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
93893 | 93893 | 24248 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 265X Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1990 12:00:00 AM | 3 | 4x4 | 6006141.132777 | 2113311.4044124 | 37.783097370149 | -122.422435967678 | (37.783097370149, -122.422435967678) | ||
94410 | 94410 | 10855 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
97270 | 97270 | 27128 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
98718 | 98718 | 19415 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600X Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.831209299 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | ||
99616 | 99616 | 26698 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 89 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016127.069051901 | 2096424.3370057999 | 37.73728734855921 | -122.386710382374 | (37.7372873485592, -122.386710382374) | |||
100175 | 100175 | 10387 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1352 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999669.18514 | 2108830.5589 | 37.7704268951205 | -122.44450405514799 | (37.7704268951205, -122.444504055148) | |||
100453 | 100453 | 27079 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 8 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
101415 | 101415 | 24476 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99X Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002281.226578901 | 2096676.7830479 | 37.73720422475029 | -122.43459982975 | (37.7372042247503, -122.43459982975) | |||
102034 | 102034 | 19417 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
107624 | 107624 | 24238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 200X Willow St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 6 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | ||
107953 | 107953 | 19416 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989518.2187007 | 2096039.5354251 | 37.7347217027544 | -122.4786803033 | (37.7347217027544, -122.4786803033) | ||
108854 | 108854 | 27124 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 3 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
110016 | 110016 | 27122 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2003 12:00:00 AM | 12 | 2x2 | 6013082.27872 | 2096428.43607 | 37.7371295622807 | -122.39723798628401 | (37.7371295622807, -122.397237986284) | ||
113106 | 113106 | 27129 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
113808 | 113808 | 89718 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1655 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5993507.69164 | 2112056.80986 | 37.778931820846296 | -122.46605098131501 | (37.7789318208463, -122.466050981315) | ||
114797 | 114797 | 5808 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 22 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2012 12:00:00 AM | 3 | 6016199.5009328 | 2096264.8663221002 | 37.736853484109794 | -122.38644883389 | (37.7368534841098, -122.38644883389) | |||
115921 | 115921 | 10852 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 12:00:00 AM | 3 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
119626 | 119626 | 12947 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 35 Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017849.360696499 | 2094492.6056632 | 37.7320783980043 | -122.38062132992901 | (37.7320783980043, -122.380621329929) | |||
127783 | 127783 | 27126 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
129366 | 129366 | 26984 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1381 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1999 12:00:00 AM | 6 | 3X3 | 6009547.85305 | 2094416.1727 | 37.7314069136466 | -122.40931618879401 | (37.7314069136466, -122.409316188794) | ||
135572 | 135572 | 221334 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90x Peralta Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6010340.53234 | 2100283.1811900004 | 37.747560836176 | -122.406989109071 | (37.747560836176, -122.406989109071) | |||
139848 | 139848 | 27127 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
140514 | 140514 | 10856 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
140827 | 140827 | 4393 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001738.943443701 | 2095739.8615836997 | 37.7346008554747 | -122.436407710795 | (37.7346008554747, -122.436407710795) | |||
143415 | 143415 | 27238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 275 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 6 | 3X3 | 6003040.40904 | 2093714.4077 | 37.729113284389 | -122.43176354159401 | (37.729113284389, -122.431763541594) | ||
144749 | 144749 | 16346 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 900X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996119.1686597 | 2094698.5315602 | 37.7314206866198 | -122.45576179592301 | (37.7314206866198, -122.455761795923) | ||
146218 | 146218 | 12283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");