trees
1,985 rows where qSpecies_id = 83 sorted by Neighborhoods (old) descending
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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2378 | 239239 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | : | Tree | Private 2 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | 15 | 5 | 11 | 29492 | 9 | |||
| 4284 | 244079 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998854.6041 | 2109046.905 | 37.7709744135065 | -122.447337256007 | (37.7709744135065, -122.447337256007) | 15 | 5 | 11 | 29492 | 9 | |||
| 6199 | 244531 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | 15 | 5 | 11 | 29492 | 9 | |||
| 8064 | 240144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998176.37667 | 2106172.12741 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | 15 | 5 | 11 | 29492 | 9 | |||
| 17871 | 244081 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 43 | Width 0ft | 5998790.9441 | 2109040.9235 | 37.7709543519473 | -122.447557026238 | (37.7709543519473, -122.447557026238) | 15 | 5 | 11 | 29492 | 9 | ||
| 22548 | 10416 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1399 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999442.73592 | 2108734.00442 | 37.7701488573322 | -122.445280397708 | (37.7701488573322, -122.445280397708) | 15 | 5 | 11 | 29492 | 9 | |||
| 26708 | 240143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.7630981164972 | -122.449494935145 | (37.7630981164972, -122.449494935145) | 15 | 5 | 11 | 29492 | 9 | |||
| 26875 | 240157 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 563 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998602.31996 | 2105951.33852 | 37.7624603514868 | -122.447986997796 | (37.7624603514868, -122.447986997796) | 15 | 5 | 11 | 29492 | 9 | |||
| 28051 | 240145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.449469012203 | (37.7629937870534, -122.449469012203) | 15 | 5 | 11 | 29492 | 9 | |||
| 31021 | 244040 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 540 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5997548.4099 | 2108554.3655 | 37.7695473010692 | -122.451819858751 | (37.7695473010692, -122.451819858751) | 15 | 5 | 11 | 29492 | 9 | |||
| 31837 | 240162 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 497 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998550.13742 | 2106327.4431 | 37.7634900572362 | -122.448194560431 | (37.7634900572362, -122.448194560431) | 15 | 5 | 11 | 29492 | 9 | |||
| 34605 | 10379 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1316 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1990 12:00:00 AM | 18 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635 | (37.7705521343685, -122.44395792635) | 15 | 5 | 11 | 29492 | 9 | ||
| 36008 | 246033 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 17 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998175.5001 | 2108450.8177 | 37.769298881123 | -122.44964332461 | (37.769298881123, -122.44964332461) | 15 | 5 | 11 | 29492 | 9 | |||
| 39005 | 248441 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 739 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998553.128 | 2108007.4759 | 37.7681031739849 | -122.448305204231 | (37.7681031739849, -122.448305204231) | 15 | 5 | 11 | 29492 | 9 | |||
| 49521 | 88262 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1630 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51249 | 5998765 | 2109030 | 37.7709228760915 | -122.447645980764 | (37.7709228760915, -122.447645980764) | 15 | 5 | 11 | 29492 | 9 | ||
| 53522 | 246010 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1509 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998926.3648 | 2108660.5268 | 37.7699176174446 | -122.447061224692 | (37.7699176174446, -122.447061224692) | 15 | 5 | 11 | 29492 | 9 | |||
| 56740 | 240156 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 507 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998563.13557 | 2106225.25844 | 37.7632102269035 | -122.448142245984 | (37.7632102269035, -122.448142245984) | 15 | 5 | 11 | 29492 | 9 | |||
| 60316 | 10444 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1508 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/1999 12:00:00 AM | 6 | 3x3 | 5998873.5099 | 2108710.5533 | 37.7700519575457 | -122.447247648975 | (37.7700519575457, -122.447247648975) | 15 | 5 | 11 | 29492 | 9 | ||
| 61246 | 240155 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 505 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998561.12995 | 2106238.99269 | 37.7632478230497 | -122.448150171714 | (37.7632478230497, -122.448150171714) | 15 | 5 | 11 | 29492 | 9 | |||
| 67663 | 245987 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999858.6241 | 2108792.1061 | 37.7703321208314 | -122.44384602423 | (37.7703321208314, -122.44384602423) | 15 | 5 | 11 | 29492 | 9 | |||
| 70375 | 240170 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1210 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997763.42944 | 2106350.69035 | 37.7635088827648 | -122.450917194987 | (37.7635088827648, -122.450917194987) | 15 | 5 | 11 | 29492 | 9 | |||
| 72868 | 240146 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1217 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998179.28174 | 2106131.69521 | 37.7629313749956 | -122.449463120725 | (37.7629313749956, -122.449463120725) | 15 | 5 | 11 | 29492 | 9 | |||
| 80812 | 102673 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 616 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997561 | 2108438 | 37.7692285123205 | -122.451767914676 | (37.7692285123205, -122.451767914676) | 15 | 5 | 11 | 29492 | 9 | ||||
| 83164 | 10381 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1324 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 2X3 | 5999783.9663 | 2108832.8405 | 37.7704397084666 | -122.44410719204 | (37.7704397084666, -122.44410719204) | 15 | 5 | 11 | 29492 | 9 | |||
| 88696 | 41132 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 11X Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.7695829350813 | -122.449696907216 | (37.7695829350813, -122.449696907216) | 15 | 5 | 11 | 29492 | 9 | |
| 92377 | 240153 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1008 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998136.29263 | 2106764.45676 | 37.7646663192052 | -122.449657403985 | (37.7646663192052, -122.449657403985) | 15 | 5 | 11 | 29492 | 9 | |||
| 93691 | 240166 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 955 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998780.13001 | 2106624.27042 | 37.7643182159335 | -122.447420459091 | (37.7643182159335, -122.447420459091) | 15 | 5 | 11 | 29492 | 9 | |||
| 95593 | 246032 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 11 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998172.7746 | 2108470.8044 | 37.7693536035765 | -122.449654192385 | (37.7693536035765, -122.449654192385) | 15 | 5 | 11 | 29492 | 9 | |||
| 96335 | 244178 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1628 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998757.1914 | 2109033.6603 | 37.7709324800681 | -122.447673254342 | (37.7709324800681, -122.447673254342) | 15 | 5 | 11 | 29492 | 9 | |||
| 97504 | 41131 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 11X Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.7695829350813 | -122.449696907216 | (37.7695829350813, -122.449696907216) | 15 | 5 | 11 | 29492 | 9 | |
| 97981 | 46138 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2001 12:00:00 AM | Permit Number 44488 | 5998167.19673673 | 2106203.84420023 | 37.763128786615 | -122.449510117352 | (37.763128786615, -122.449510117352) | 15 | 5 | 11 | 29492 | 9 | ||
| 98710 | 244177 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1628 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998770.8634 | 2109036.2238 | 37.7709403001609 | -122.447626147287 | (37.7709403001609, -122.447626147287) | 15 | 5 | 11 | 29492 | 9 | |||
| 101882 | 240147 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1225 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998185.55708 | 2106089.49619 | 37.7628158660928 | -122.449438375894 | (37.7628158660928, -122.449438375894) | 15 | 5 | 11 | 29492 | 9 | |||
| 108679 | 244923 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1318 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999810.5322 | 2108837.5844 | 37.7704542495024 | -122.444015641705 | (37.7704542495024, -122.444015641705) | 15 | 5 | 11 | 29492 | 9 | |||
| 110729 | 117314 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | 15 | 5 | 11 | 29492 | 9 | |||
| 114679 | 10408 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1391 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999500.983 | 2108743.0478 | 37.7701770128525 | -122.445079572577 | (37.7701770128525, -122.445079572577) | 15 | 5 | 11 | 29492 | 9 | |||
| 114834 | 246026 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 8 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998207.6 | 2108524.1023 | 37.7695019383238 | -122.449537574469 | (37.7695019383238, -122.449537574469) | 15 | 5 | 11 | 29492 | 9 | |||
| 116797 | 41900 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42265 | 6002336.18060938 | 2108825.44123893 | 37.7705646588804 | -122.435278555813 | (37.7705646588804, -122.435278555813) | 15 | 5 | 11 | 29492 | 9 | |||
| 117239 | 244046 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998376.5126 | 2109253.6935 | 37.771514871031 | -122.449005879607 | (37.771514871031, -122.449005879607) | 15 | 5 | 11 | 29492 | 9 | |||
| 120037 | 245986 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1317 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999797.1498 | 2108783.9297 | 37.7703061638219 | -122.444058075462 | (37.7703061638219, -122.444058075462) | 15 | 5 | 11 | 29492 | 9 | |||
| 122120 | 240169 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 204 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998975.98045 | 2106976.10403 | 37.7652954525443 | -122.446768387673 | (37.7652954525443, -122.446768387673) | 15 | 5 | 11 | 29492 | 9 | |||
| 133144 | 240161 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 504 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998591.56873 | 2106281.83073 | 37.7633671855679 | -122.448047979048 | (37.7633671855679, -122.448047979048) | 15 | 5 | 11 | 29492 | 9 | |||
| 136154 | 10478 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5998139.6149 | 2108553.6282 | 37.7695791194599 | -122.449774859218 | (37.7695791194599, -122.449774859218) | 15 | 5 | 11 | 29492 | 9 | |||
| 136453 | 246014 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1555 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998699 | 2108609 | 37.7697631450249 | -122.447843961466 | (37.7697631450249, -122.447843961466) | 15 | 5 | 11 | 29492 | 9 | |||
| 138552 | 10459 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1569 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1994 12:00:00 AM | 25 | 3X3 | 5998651.396 | 2108625.3987 | 37.7698054506603 | -122.448009802562 | (37.7698054506603, -122.448009802562) | 15 | 5 | 11 | 29492 | 9 | ||
| 139056 | 247402 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 944 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 6002027.7583 | 2109490.1505 | 37.7723722659737 | -122.436392970615 | (37.7723722659737, -122.436392970615) | 15 | 5 | 11 | 29492 | 9 | |||
| 140423 | 246027 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998205.4802 | 2108541.9693 | 37.76955087528 | -122.449546194352 | (37.76955087528, -122.449546194352) | 15 | 5 | 11 | 29492 | 9 | |||
| 140456 | 240168 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 116 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998899.29279 | 2107504.14215 | 37.7667409310672 | -122.447071634562 | (37.7667409310672, -122.447071634562) | 15 | 5 | 11 | 29492 | 9 | |||
| 140786 | 244474 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1909 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997392.6079 | 2108791.0607 | 37.7701882806465 | -122.452375851759 | (37.7701882806465, -122.452375851759) | 15 | 5 | 11 | 29492 | 9 | |||
| 141329 | 240165 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 955 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998776.9827 | 2106633.40006 | 37.7643431037773 | -122.447432001889 | (37.7643431037773, -122.447432001889) | 15 | 5 | 11 | 29492 | 9 | |||
| 142063 | 240142 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 137 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997839.49621 | 2106779.62864 | 37.7646909930258 | -122.450685033183 | (37.7646909930258, -122.450685033183) | 15 | 5 | 11 | 29492 | 9 | |||
| 149466 | 240163 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 499 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998551.61498 | 2106310.67674 | 37.7634441054949 | -122.448188242691 | (37.7634441054949, -122.448188242691) | 15 | 5 | 11 | 29492 | 9 | |||
| 149929 | 10443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1501 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5998901.98983 | 2108638.08127 | 37.7698545950424 | -122.447143921289 | (37.7698545950424, -122.447143921289) | 15 | 5 | 11 | 29492 | 9 | |||
| 154685 | 246059 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 602 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997560.3028 | 2108454.9059 | 37.7692748916577 | -122.451771545977 | (37.7692748916577, -122.451771545977) | 15 | 5 | 11 | 29492 | 9 | |||
| 160200 | 10423 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1401 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 5999371.8264 | 2108722.9096 | 37.7701143458549 | -122.44552487423 | (37.7701143458549, -122.44552487423) | 15 | 5 | 11 | 29492 | 9 | |||
| 161106 | 240167 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.7642609731824 | -122.44740261924 | (37.7642609731824, -122.44740261924) | 15 | 5 | 11 | 29492 | 9 | |||
| 166025 | 240154 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 568 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998646.15561 | 2105899.30537 | 37.7623199871107 | -122.447831640838 | (37.7623199871107, -122.447831640838) | 15 | 5 | 11 | 29492 | 9 | |||
| 169541 | 10455 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1555 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5998706.29238 | 2108552.28682 | 37.7696078418555 | -122.447814653926 | (37.7696078418555, -122.447814653926) | 15 | 5 | 11 | 29492 | 9 | |||
| 172182 | 10442 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1500 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5998947.4848 | 2108705.37768 | 37.7700419732298 | -122.446991399363 | (37.7700419732298, -122.446991399363) | 15 | 5 | 11 | 29492 | 9 | |||
| 176002 | 88263 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1630 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51249 | 5998765 | 2109030 | 37.7709228760915 | -122.447645980764 | (37.7709228760915, -122.447645980764) | 15 | 5 | 11 | 29492 | 9 | ||
| 177244 | 244219 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 588 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998052 | 2108644 | 37.7698222441568 | -122.450084429151 | (37.7698222441568, -122.450084429151) | 15 | 5 | 11 | 29492 | 9 | |||
| 185001 | 240158 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 569 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1969 12:00:00 AM | 6 | Width 3ft | Permit Number 6318 | 5998608.31571 | 2105895.72511 | 37.7623079937314 | -122.447962256561 | (37.7623079937314, -122.447962256561) | 15 | 5 | 11 | 29492 | 9 | |
| 190435 | 240164 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | 15 | 5 | 11 | 29492 | 9 | |||
| 193694 | 246064 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 601 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997522.9034 | 2108415.3867 | 37.7691642400439 | -122.451898056524 | (37.7691642400439, -122.451898056524) | 15 | 5 | 11 | 29492 | 9 | |||
| 11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
| 16016 | 5120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2016 10:06:00 AM | 3 | 5X5 | 6002461.05615 | 2096042.42458 | 37.7354726294434 | -122.433932747209 | (37.7354726294434, -122.433932747209) | 2 | 7 | 5 | 63 | 7 | ||
| 16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
| 20763 | 59417 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.7409743251647 | -122.427868803942 | (37.7409743251647, -122.427868803942) | 2 | 7 | 5 | 63 | 7 | ||
| 23539 | 61014 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.433536447887 | (37.7354717570522, -122.433536447887) | 2 | 7 | 5 | 63 | 7 | ||
| 27068 | 240206 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003903.54766 | 2097252.33034 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | 2 | 7 | 5 | 63 | 7 | |||
| 35647 | 34349 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51609 | 6004013.55416632 | 2096149.85411864 | 37.7358555876111 | -122.428572831878 | (37.7358555876111, -122.428572831878) | 2 | 7 | 5 | 63 | 7 | ||
| 38398 | 26478 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | 2 | 7 | 5 | 63 | 7 | ||
| 46778 | 61001 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20814 | 6002393.98738915 | 2096184.72110879 | 37.7358595366597 | -122.434174798209 | (37.7358595366597, -122.434174798209) | 2 | 7 | 5 | 63 | 7 | ||
| 46924 | 240190 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004298.57929 | 2097992.82616 | 37.7409320961319 | -122.427718657607 | (37.7409320961319, -122.427718657607) | 2 | 7 | 5 | 63 | 7 | |||
| 48047 | 240196 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004000.46579 | 2096134.03404 | 37.7358114085533 | -122.42861695621 | (37.7358114085533, -122.42861695621) | 2 | 7 | 5 | 63 | 7 | |||
| 52352 | 240198 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 46 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002599.46299 | 2096074.44073 | 37.7355683919716 | -122.433456510332 | (37.7355683919716, -122.433456510332) | 2 | 7 | 5 | 63 | 7 | |||
| 60779 | 60128 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 415 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19656 | 6003855.48725366 | 2096277.36434342 | 37.736196755139 | -122.429128420374 | (37.736196755139, -122.429128420374) | 2 | 7 | 5 | 63 | 7 | ||
| 63118 | 240202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3006 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002850.86093 | 2096098.0434 | 37.7356474594489 | -122.432589017977 | (37.7356474594489, -122.432589017977) | 2 | 7 | 5 | 63 | 7 | |||
| 64935 | 240191 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004293.70696 | 2098089.97952 | 37.7411985814464 | -122.427742424874 | (37.7411985814464, -122.427742424874) | 2 | 7 | 5 | 63 | 7 | |||
| 65748 | 4337 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.18849 | 2095960.05903 | 37.7351918404399 | -122.437252384095 | (37.7351918404399, -122.437252384095) | 2 | 7 | 5 | 63 | 7 | ||
| 66298 | 240207 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 71 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003881.31618 | 2097271.66945 | 37.738928352668 | -122.429109992458 | (37.738928352668, -122.429109992458) | 2 | 7 | 5 | 63 | 7 | |||
| 67571 | 60613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | 2 | 7 | 5 | 63 | 7 | ||
| 68572 | 24482 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002240.5138934 | 2096668.0977393 | 37.7371780656004 | -122.434739971035 | (37.7371780656004, -122.434739971035) | 2 | 7 | 5 | 63 | 7 | |||
| 71665 | 240188 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004313.76435 | 2097764.66953 | 37.7403064890593 | -122.427649901715 | (37.7403064890593, -122.427649901715) | 2 | 7 | 5 | 63 | 7 | |||
| 71763 | 240204 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 157 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002560.27633 | 2096896.15431 | 37.7378224050816 | -122.433650701839 | (37.7378224050816, -122.433650701839) | 2 | 7 | 5 | 63 | 7 | |||
| 76064 | 4354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
| 81346 | 64332 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25160 | 6004309.77102344 | 2097969.94151847 | 37.7408698932086 | -122.427678330625 | (37.7408698932086, -122.427678330625) | 2 | 7 | 5 | 63 | 7 | ||
| 86813 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1753 Noe St | 1 | Hanging basket : Yard | Tree | Private 2 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | 2 | 7 | 5 | 63 | 7 | |||
| 90947 | 4339 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.64316 | 2095917.88066 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | 2 | 7 | 5 | 63 | 7 | ||
| 95976 | 60615 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 141 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | 3x3 | Permit Number 20239 | 6004908.29901709 | 2097432.1661827 | 37.7394271221249 | -122.425570577895 | (37.7394271221249, -122.425570577895) | 2 | 7 | 5 | 63 | 7 | |
| 96066 | 94681 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 284 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53817 | 6001324 | 2096497 | 37.7366561951725 | -122.437896519679 | (37.7366561951725, -122.437896519679) | 2 | 7 | 5 | 63 | 7 | |
| 96440 | 60618 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 205 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20242 | 6004849.79426998 | 2097209.93187189 | 37.7388136110977 | -122.425757047896 | (37.7388136110977, -122.425757047896) | 2 | 7 | 5 | 63 | 7 | ||
| 99615 | 60629 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 461 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20255 | 6003690.91133261 | 2096147.61954597 | 37.7358311876742 | -122.429688175872 | (37.7358311876742, -122.429688175872) | 2 | 7 | 5 | 63 | 7 | ||
| 99683 | 60612 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | 7 | Permit Number 20236 | 6004870.59253737 | 2097774.41480617 | 37.7403647286117 | -122.425725303892 | (37.7403647286117, -122.425725303892) | 2 | 7 | 5 | 63 | 7 | |
| 104634 | 240189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004299.90436 | 2097973.73041 | 37.7408797385189 | -122.427712715772 | (37.7408797385189, -122.427712715772) | 2 | 7 | 5 | 63 | 7 | |||
| 112621 | 60621 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 273 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20246 | 6004468.77441112 | 2096758.98359533 | 37.7375538708016 | -122.42704232686 | (37.7375538708016, -122.42704232686) | 2 | 7 | 5 | 63 | 7 | ||
| 113608 | 4364 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 16X Burnside Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2012 12:00:00 AM | 3 | 3x3 | 6001221.76422 | 2095989.43469 | 37.7352567246132 | -122.438213642387 | (37.7352567246132, -122.438213642387) | 2 | 7 | 5 | 63 | 7 | ||
| 124892 | 240197 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002619.5193 | 2096053.2786 | 37.7355114234985 | -122.433385656346 | (37.7355114234985, -122.433385656346) | 2 | 7 | 5 | 63 | 7 | |||
| 125154 | 240205 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 148 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002599.9876 | 2096899.86345 | 37.737834842704 | -122.433513665818 | (37.737834842704, -122.433513665818) | 2 | 7 | 5 | 63 | 7 | |||
| 125802 | 57690 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 149 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1982 12:00:00 AM | Permit Number 19644 | 6004901.85798659 | 2097408.79404605 | 37.7393625835838 | -122.425591185183 | (37.7393625835838, -122.425591185183) | 2 | 7 | 5 | 63 | 7 |
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) );