Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
142918 | 142918 | 116595 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 800x SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002075.0 | 2111247.0 | 37.777198820389295 | -122.436355315705 | (37.7771988203893, -122.436355315705) | ||||
35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
99196 | 99196 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 461X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005199.36333 | 2111122.83043 | 37.777034912059605 | -122.425538300101 | (37.7770349120596, -122.425538300101) | |||||
144227 | 144227 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 455X Ivy St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | |||||
39669 | 39669 | 118709 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4201 Balboa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5982467.72104 | 2110969.09723 | 37.7753021852736 | -122.504161410758 | (37.7753021852736, -122.504161410758) | |||
6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
139139 | 139139 | 49324 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | Permit Number 46321 | 6013145.06683573 | 2110537.17362663 | 37.775872581057 | -122.39801035954599 | (37.775872581057, -122.398010359546) | |||
181886 | 181886 | 49328 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 19 | Permit Number 46321 | 6013181.12431 | 2110489.32106 | 37.775743196927294 | -122.397882269155 | (37.7757431969273, -122.397882269155) | ||
62777 | 62777 | 49327 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 17 | Permit Number 46321 | 6013204.31889 | 2110464.18207 | 37.77567546267289 | -122.397800268992 | (37.7756754626729, -122.397800268992) | ||
24710 | 24710 | 38696 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | |
112953 | 112953 | 118305 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
124295 | 124295 | 118306 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
54279 | 54279 | 33558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | |
69461 | 69461 | 49325 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013241.30936 | 2110424.30224 | 37.7755680215912 | -122.397669511153 | (37.7755680215912, -122.397669511153) | ||
181166 | 181166 | 33557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996239.10441 | 2110423.85984 | 37.774605369516394 | -122.456483876805 | (37.7746053695164, -122.456483876805) | ||
65233 | 65233 | 33556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996225.02102 | 2110420.81163 | 37.774596191384 | -122.456532373263 | (37.774596191384, -122.456532373263) | ||
62683 | 62683 | 33555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 14 | Permit Number 37664 | 5996213.16627 | 2110420.4696400003 | 37.7745945717567 | -122.456573356196 | (37.7745945717567, -122.456573356196) | ||
120058 | 120058 | 33554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996192.1418699995 | 2110415.99351 | 37.7745810743751 | -122.456645759522 | (37.7745810743751, -122.456645759522) | ||
59148 | 59148 | 49326 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013271.22314 | 2110393.4980200003 | 37.7754851058895 | -122.39756387047501 | (37.7754851058895, -122.397563870475) | ||
72808 | 72808 | 203199 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6013299.63411 | 2110362.29852 | 37.77540102106779 | -122.397463400913 | (37.7754010210678, -122.397463400913) | |||
1518 | 1518 | 243948 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.774615739356705 | -122.41928883630399 | (37.7746157393567, -122.419288836304) | |
1519 | 1519 | 243949 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 12 | Width 5ft | Permit Number 47529 | 6006997.017419999 | 2110160.92453 | 37.7744951573695 | -122.41925139124399 | (37.7744951573695, -122.419251391244) | |
1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
1516 | 1516 | 243951 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007014.66541 | 2110083.11128 | 37.774282494675795 | -122.419184822535 | (37.7742824946758, -122.419184822535) | |
1514 | 1514 | 243952 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007022.68787 | 2110044.22077 | 37.7741761624211 | -122.41915431212601 | (37.7741761624211, -122.419154312126) | |
154136 | 154136 | 119374 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 866 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5986063.1424 | 2109995.79652 | 37.7728405660437 | -122.49165253211099 | (37.7728405660437, -122.491652532111) | |||
1533 | 1533 | 243953 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 14 | Width 5ft | Permit Number 47529 | 6007037.92355 | 2109985.61989 | 37.7740161163944 | -122.41909745161301 | (37.7740161163944, -122.419097451613) | |
1521 | 1521 | 243954 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007048.80869 | 2109949.46518 | 37.773917457170796 | -122.41905723302 | (37.7739174571708, -122.41905723302) | |
168704 | 168704 | 199467 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015455.2503 | 2109935.9180799997 | 37.774350061636795 | -122.389976763437 | (37.7743500616368, -122.389976763437) | |||
1512 | 1512 | 243955 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 15 | Width 5ft | Permit Number 47529 | 6007056.3814199995 | 2109908.18867 | 37.773804548164705 | -122.419028109365 | (37.7738045481647, -122.419028109365) | |
66564 | 66564 | 199468 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015459.06425 | 2109878.23066 | 37.77419187628129 | -122.38995953961799 | (37.7741918762813, -122.389959539618) | |||
77197 | 77197 | 199469 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015461.94108 | 2109832.83992 | 37.7740674029079 | -122.389946416702 | (37.7740674029079, -122.389946416702) | |||
39967 | 39967 | 199470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543001 | (37.7739526530238, -122.38994067543) | |||
109889 | 109889 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 546 Page St | Front Yard : 25 | Tree 1 | Private 1 | 6003947.0 | 2109752.0 | 37.773200107256606 | -122.42977281454901 | (37.7732001072566, -122.429772814549) | ||||||
163780 | 163780 | 199471 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015471.47006 | 2109635.49599 | 37.773526068606294 | -122.389899666361 | (37.7735260686063, -122.389899666361) | |||
156279 | 156279 | 199472 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015475.23167 | 2109575.21201 | 37.7733607507341 | -122.389882442542 | (37.7733607507341, -122.389882442542) | |||
110465 | 110465 | 49637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
139662 | 139662 | 51396 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
95580 | 95580 | 100555 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) | |||
110334 | 110334 | 100554 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) | |||
139272 | 139272 | 51395 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) |
132921 | 132921 | 199473 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | |||
189141 | 189141 | 199474 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015480.23631 | 2109482.55519 | 37.7731066131226 | -122.389858657266 | (37.7731066131226, -122.389858657266) | |||
90309 | 90309 | 26392 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1615X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007128.16796 | 2109448.9564900002 | 37.772547648160895 | -122.418747213269 | (37.7725476481609, -122.418747213269) | |||
160937 | 160937 | 243944 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007141.91365 | 2109397.79413 | 37.7724079424095 | -122.418696036515 | (37.7724079424095, -122.418696036515) | |||
27658 | 27658 | 246312 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1601 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007098.251 | 2109393.5574 | 37.7723938509682 | -122.418846769596 | (37.7723938509682, -122.418846769596) | |||
34846 | 34846 | 243945 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007159.400359999 | 2109389.15821 | 37.7723852147468 | -122.41863493565901 | (37.7723852147468, -122.418634935659) | |||
135810 | 135810 | 243946 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007170.22447 | 2109376.5199 | 37.77235112234529 | -122.418596597579 | (37.7723511223453, -122.418596597579) | |||
152448 | 152448 | 199475 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015486.6604 | 2109366.2584700002 | 37.7727876442643 | -122.38982831052799 | (37.7727876442643, -122.389828310528) | |||
44536 | 44536 | 243947 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007173.3402 | 2109359.55607 | 37.772304719112704 | -122.418584616798 | (37.7723047191127, -122.418584616798) | |||
139382 | 139382 | 30858 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
33786 | 33786 | 199476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015490.48538 | 2109320.84762 | 37.772663168207 | -122.389811906894 | (37.772663168207, -122.389811906894) | |||
151765 | 151765 | 199477 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015494.09745 | 2109276.6214799997 | 37.772541933290206 | -122.389796322564 | (37.7725419332902, -122.389796322564) | |||
167263 | 167263 | 199478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015495.305819999 | 2109230.7911799997 | 37.7724161604052 | -122.38978894091801 | (37.7724161604052, -122.389788940918) | |||
156118 | 156118 | 199479 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015497.26335 | 2109186.83428 | 37.772295573003895 | -122.389779098738 | (37.7722955730039, -122.389779098738) | |||
175922 | 175922 | 199480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015500.51903 | 2109136.7123 | 37.7721581296349 | -122.389764335453 | (37.7721581296349, -122.389764335453) | |||
164223 | 164223 | 244905 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 31 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6000349.4407 | 2109066.7154 | 37.7711141128681 | -122.44216801058799 | (37.7711141128681, -122.442168010588) | |||
148816 | 148816 | 199461 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015597.30963 | 2109009.9155099997 | 37.7718153404253 | -122.389420669423 | (37.7718153404253, -122.389420669423) | |||
57434 | 57434 | 199481 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015507.548169999 | 2109003.40137 | 37.77179247697679 | -122.389730708003 | (37.7717924769768, -122.389730708003) | |||
149805 | 149805 | 199482 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015508.8068699995 | 2108983.54244 | 37.7717380185256 | -122.38972496674 | (37.7717380185256, -122.38972496674) | |||
68878 | 68878 | 199460 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015600.77794 | 2108970.35206 | 37.771706900189294 | -122.389405908858 | (37.7717069001893, -122.389405908858) | |||
23753 | 23753 | 199483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.38972250619801 | (37.7716855044225, -122.389722506198) | |||
65089 | 65089 | 199459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015601.45578 | 2108929.3451900003 | 37.7715943419254 | -122.389400699999 | (37.7715943419254, -122.389400699999) | |||
177521 | 177521 | 199484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015511.156140001 | 2108923.75767 | 37.7715739929801 | -122.38971266400401 | (37.7715739929801, -122.389712664004) | |||
77203 | 77203 | 199458 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015604.63296 | 2108887.78773 | 37.77148041042871 | -122.389386807278 | (37.7714804104287, -122.389386807278) | |||
63273 | 63273 | 199485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015513.12326 | 2108880.27223 | 37.7714547006117 | -122.389702821822 | (37.7714547006117, -122.389702821822) | |||
131078 | 131078 | 199486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015515.33955 | 2108860.86593 | 37.771401538077704 | -122.389693799846 | (37.7714015380777, -122.389693799846) | |||
64963 | 64963 | 199457 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015609.11002 | 2108848.45381 | 37.7713726563476 | -122.389368573515 | (37.7713726563476, -122.389368573515) | |||
65873 | 65873 | 199487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015516.37079 | 2108841.48357 | 37.7713483755645 | -122.38968887873399 | (37.7713483755645, -122.389688878734) | |||
32638 | 32638 | 199456 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.77126421521471 | -122.38935989056299 | (37.7712642152147, -122.389359890563) | |||
35626 | 35626 | 199488 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015518.167640001 | 2108801.30732 | 37.7712381600557 | -122.38967985676099 | (37.7712381600557, -122.389679856761) | |||
44059 | 44059 | 199443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 625 King St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6012254.773469999 | 2108757.11148 | 37.7709353106325 | -122.400965034535 | (37.7709353106325, -122.400965034535) | |||
31881 | 31881 | 199455 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015625.9056 | 2108540.0716 | 37.7705268376657 | -122.389288938555 | (37.7705268376657, -122.389288938555) | |||
184524 | 184524 | 199454 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015626.42459 | 2108505.26742 | 37.7704313017932 | -122.38928471262 | (37.7704313017932, -122.38928471262) | |||
16923 | 16923 | 24346 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 95 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6006149.34547 | 2108468.08439 | 37.769799248359796 | -122.422063370746 | (37.7697992483598, -122.422063370746) | |||
52239 | 52239 | 199453 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015629.79574 | 2108466.51232 | 37.7703250756792 | -122.389270345061 | (37.7703250756792, -122.389270345061) | |||
167534 | 167534 | 199452 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015631.41317 | 2108425.60277 | 37.7702128366907 | -122.38926189323799 | (37.7702128366907, -122.389261893238) | |||
173828 | 173828 | 199451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6015633.06498 | 2108386.39567 | 37.77010527416 | -122.389253441416 | (37.77010527416, -122.389253441416) | |||
132521 | 132521 | 199450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015636.18722 | 2108347.40225 | 37.7699983798625 | -122.389239918305 | (37.7699983798625, -122.389239918305) | |||
60522 | 60522 | 247645 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001626.8491400005 | 2108303.83597 | 37.7690921528084 | -122.437694773193 | (37.7690921528084, -122.437694773193) | |||
23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
131340 | 131340 | 247647 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001603.04575 | 2108301.54357 | 37.7690845049709 | -122.437776943351 | (37.7690845049709, -122.437776943351) | |||
130003 | 130003 | 247648 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001589.80232 | 2108300.84932 | 37.76908184567821 | -122.43782270177 | (37.7690818456782, -122.43782270177) | |||
52425 | 52425 | 247649 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 5 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001576.55462 | 2108299.96127 | 37.7690786539981 | -122.437868461073 | (37.7690786539981, -122.437868461073) | |||
155493 | 155493 | 247650 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 6 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001564.47006 | 2108298.85523 | 37.7690749298967 | -122.437910181532 | (37.7690749298967, -122.437910181532) | |||
133845 | 133845 | 247651 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 7 | : 4 | Tree 1 | Private 1 | 16 | Width 5ft | 6001551.81383 | 2108298.34241 | 37.7690728021064 | -122.437953921852 | (37.7690728021064, -122.437953921852) | |||
28662 | 28662 | 247652 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001539.54665 | 2108297.82153 | 37.7690706742937 | -122.437996315894 | (37.7690706742937, -122.437996315894) | |||
27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
43387 | 43387 | 247655 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 11 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.769063227919105 | -122.43811744198601 | (37.7690632279191, -122.438117441986) | |||
36914 | 36914 | 247654 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | |||
79565 | 79565 | 84717 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
81310 | 81310 | 84715 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
83280 | 83280 | 84707 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
90707 | 90707 | 84712 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
99232 | 99232 | 84714 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
100997 | 100997 | 84709 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
102510 | 102510 | 84710 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
106675 | 106675 | 84713 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
118894 | 118894 | 84711 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) | ||||
119296 | 119296 | 84708 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49325 | 6001553.346940001 | 2108280.88879 | 37.7690249659747 | -122.437947368595 | (37.7690249659747, -122.437947368595) |
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");