trees
1,914 rows where qSpecies_id = 45 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194244 | 228432 | DPW Maintained 1 | :: 45 | 300 Church St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6004140.61494 | 2107068.90552 | 37.7658439427747 | -122.428911750393 | (37.7658439427747, -122.428911750393) | 8 | 4 | 5 | 28862 | 3 | |||
| 194239 | 33509 | Permitted Site 7 | :: 45 | 24 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37605 | 6006962.93911675 | 2099621.40648906 | 37.745554167617 | -122.418621725138 | (37.745554167617, -122.418621725138) | 2 | 7 | 7 | 28859 | 2 | |||
| 194129 | 182018 | DPW Maintained 1 | :: 45 | 1467 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988965.6747 | 2105331.3888 | 37.7602025812324 | -122.481270822304 | (37.7602025812324, -122.481270822304) | 1 | 8 | 3 | 56 | 35 | |||
| 193926 | 129085 | DPW Maintained 1 | :: 45 | 1201 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008098.74192 | 2115839.1342 | 37.790148139064 | -122.415842465177 | (37.790148139064, -122.415842465177) | 13 | 1 | 10 | 28858 | 21 | |||
| 193887 | 190665 | DPW Maintained 1 | :: 45 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | 6 | 2 | 9 | 28856 | 34 | |||
| 193842 | 184230 | DPW Maintained 1 | :: 45 | 1523 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5983710.501 | 2104758.2068 | 37.7583218582097 | -122.499403338684 | (37.7583218582097, -122.499403338684) | 1 | 8 | 3 | 56 | 35 | |||
| 193821 | 139028 | DPW Maintained 1 | :: 45 | 2501 SUTTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000547.3036 | 2114093.8303 | 37.7849285655089 | -122.441844461123 | (37.7849285655089, -122.441844461123) | 15 | 6 | 11 | 29490 | 13 | |||
| 193705 | 31190 | Permitted Site 7 | :: 45 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 193607 | 181875 | DPW Maintained 1 | :: 45 | 2340 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987665.5559 | 2099356.4374 | 37.7437212998466 | -122.485328821012 | (37.7437212998466, -122.485328821012) | 1 | 8 | 3 | 29491 | 35 | |||
| 193480 | 184127 | DPW Maintained 1 | :: 45 | 1638 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985330.3253 | 2104050.8162 | 37.7564744613327 | -122.493749228243 | (37.7564744613327, -122.493749228243) | 1 | 8 | 3 | 56 | 35 | |||
| 193425 | 34738 | Permitted Site 7 | :: 45 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38388 | 6007301.38154642 | 2103961.93369164 | 37.7574913175401 | -122.417759048452 | (37.7574913175401, -122.417759048452) | 2 | 4 | 7 | 28859 | 19 | ||
| 193377 | 121126 | Undocumented 4 | :: 45 | 201 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216 | 2096386 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | 2 | 7 | 5 | 63 | 7 | ||
| 193376 | 142118 | DPW Maintained 1 | :: 45 | 29 HEMWAY TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998613.9988 | 2110907.9465 | 37.776070604872 | -122.448303549007 | (37.776070604872, -122.448303549007) | 15 | 6 | 2 | 29492 | 16 | |||
| 193330 | 244343 | DPW Maintained 1 | :: 45 | 462 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003204.9743 | 2109911.1218 | 37.7735949699184 | -122.432350944562 | (37.7735949699184, -122.432350944562) | 15 | 9 | 11 | 29492 | 10 | |||
| 193089 | 182686 | DPW Maintained 1 | :: 45 | 1711 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985923.1814 | 2103562.5821 | 37.7551685712811 | -122.491663011886 | (37.7551685712811, -122.491663011886) | 1 | 8 | 3 | 56 | 35 | |||
| 193077 | 253676 | DPW Maintained 1 | :: 45 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | 13 | 9 | 1 | 28858 | 17 | ||
| 193016 | 184620 | DPW Maintained 1 | :: 45 | 3000x Noriega St | 2 | Median : Cutout | Tree | DPW 1 | 0 | Width 0ft | 5984460.1938 | 2102931.6946 | 37.7533507191048 | -122.496675818993 | (37.7533507191048, -122.496675818993) | 1 | 8 | 3 | 56 | 35 | |||
| 192835 | 115870 | Undocumented 4 | :: 45 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 192814 | 141523 | DPW Maintained 1 | :: 45 | 200 STANYAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5996684.3575 | 2111222.9913 | 37.7768251277487 | -122.455001422863 | (37.7768251277487, -122.455001422863) | 15 | 6 | 2 | 54 | 16 | |||
| 192741 | 182399 | DPW Maintained 1 | :: 45 | 1534 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988097.2897 | 2104845.6767 | 37.7588184233818 | -122.484238496512 | (37.7588184233818, -122.484238496512) | 1 | 8 | 3 | 56 | 35 | |||
| 192712 | 139054 | DPW Maintained 1 | :: 45 | 1480 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999713.5777 | 2113947.3354 | 37.7844787867448 | -122.444718341335 | (37.7844787867448, -122.444718341335) | 15 | 6 | 11 | 29490 | 31 | |||
| 192677 | 184154 | DPW Maintained 1 | :: 45 | 4036 Lawton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981710.2029 | 2104227.1296 | 37.7567461108743 | -122.506281748334 | (37.7567461108743, -122.506281748334) | 1 | 8 | 3 | 56 | 35 | |||
| 192608 | 182445 | DPW Maintained 1 | :: 45 | 1530 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985616.5233 | 2104773.8077 | 37.7584763359765 | -122.492812718757 | (37.7584763359765, -122.492812718757) | 1 | 8 | 3 | 56 | 35 | |||
| 192580 | 200170 | DPW Maintained 1 | :: 45 | 1001 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014099.661 | 2089867.5171 | 37.7191711929066 | -122.393261433304 | (37.7191711929066, -122.393261433304) | 10 | 3 | 8 | 58 | 1 | |||
| 192276 | 182606 | DPW Maintained 1 | :: 45 | 1875 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987820.7742 | 2102536.1149 | 37.7524608872854 | -122.485025356896 | (37.7524608872854, -122.485025356896) | 1 | 8 | 3 | 56 | 35 | |||
| 192231 | 244369 | DPW Maintained 1 | :: 45 | 301 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005524.5535 | 2110345.3319 | 37.7749184587564 | -122.424358051661 | (37.7749184587564, -122.424358051661) | 7 | 9 | 11 | 28852 | 10 | |||
| 192216 | 184719 | DPW Maintained 1 | :: 45 | 1639 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984665.0043 | 2104026.0966 | 37.7563676416928 | -122.496048285397 | (37.7563676416928, -122.496048285397) | 1 | 8 | 3 | 56 | 35 | |||
| 192172 | 187451 | DPW Maintained 1 | :: 45 | 5098 Mission St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6000310.9137 | 2089292.2181 | 37.7168158602419 | -122.440882499178 | (37.7168158602419, -122.440882499178) | 9 | 7 | 6 | 28861 | 25 | |||
| 191889 | 143026 | DPW Maintained 1 | :: 45 | 2027 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009443.5652 | 2120635.2508 | 37.8033926093321 | -122.411528458224 | (37.8033926093321, -122.411528458224) | 3 | 1 | 10 | 308 | 23 | |||
| 191838 | 200182 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013359.1884 | 2090422.8715 | 37.7206549194654 | -122.395859877099 | (37.7206549194654, -122.395859877099) | 10 | 3 | 8 | 58 | 1 | |||
| 191797 | 200172 | DPW Maintained 1 | :: 45 | 1053 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014576.5414 | 2089866.8464 | 37.7191958334242 | -122.391612979464 | (37.7191958334242, -122.391612979464) | 10 | 3 | 8 | 58 | 1 | |||
| 191663 | 200246 | DPW Maintained 1 | :: 45 | 1071 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013781.7407 | 2090110.9877 | 37.719822047209 | -122.394377408818 | (37.719822047209, -122.394377408818) | 10 | 3 | 8 | 58 | 1 | |||
| 191423 | 6842 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 07:14:00 AM | 3 | 3X3 | 6016194.23735 | 2097718.16262 | 37.7408436496142 | -122.386568339179 | (37.7408436496142, -122.386568339179) | 10 | 3 | 8 | 58 | 1 | ||
| 191297 | 67430 | DPW Maintained 1 | :: 45 | 1803 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 7 | Permit Number 30932 | 5989942.29027 | 2110566.40136 | 37.7746332333777 | -122.4782759878 | (37.7746332333777, -122.4782759878) | 11 | 6 | 2 | 55 | 26 | |
| 191207 | 183502 | DPW Maintained 1 | :: 45 | 2535 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987043.8814 | 2097999.1529 | 37.7399583203045 | -122.48737871628 | (37.7399583203045, -122.48737871628) | 1 | 8 | 3 | 29491 | 35 | |||
| 191035 | 105040 | DPW Maintained 1 | :: 45 | 2660 Harrison St | 2 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | 2 | 4 | 7 | 28859 | 19 | ||||
| 190836 | 182721 | DPW Maintained 1 | :: 45 | 1734 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988145.0008 | 2103480.5876 | 37.7550730356888 | -122.483973391697 | (37.7550730356888, -122.483973391697) | 1 | 8 | 3 | 56 | 35 | |||
| 190746 | 142767 | DPW Maintained 1 | :: 45 | 724 LARKIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6007520.0381 | 2113832.9802 | 37.7846071803113 | -122.417702485236 | (37.7846071803113, -122.417702485236) | 7 | 9 | 9 | 28858 | 36 | |||
| 190716 | 184974 | DPW Maintained 1 | :: 45 | 2700 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984964.6462 | 2096531.6242 | 37.735807405046 | -122.494459590864 | (37.735807405046, -122.494459590864) | 1 | 8 | 3 | 29491 | 35 | |||
| 190693 | 247418 | DPW Maintained 1 | :: 45 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.434436924996 | (37.7743916070028, -122.434436924996) | 15 | 5 | 11 | 29492 | 10 | |||
| 190627 | 108795 | Undocumented 4 | :: 45 | 501-599 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008503.45306 | 2091469.83252 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | 9 | 3 | 7 | 309 | 18 | |||||
| 190604 | 200729 | DPW Maintained 1 | :: 45 | 1481 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6015678.7414 | 2094969.3688 | 37.7332674687178 | -122.388158962258 | (37.7332674687178, -122.388158962258) | 10 | 3 | 8 | 58 | 1 | |||
| 190418 | 181569 | DPW Maintained 1 | :: 45 | 1349 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984599.7352 | 2105972.9827 | 37.7617094244752 | -122.496417657892 | (37.7617094244752, -122.496417657892) | 1 | 8 | 3 | 56 | 35 | |||
| 190375 | 181874 | DPW Maintained 1 | :: 45 | 2341 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987928.3405 | 2099366.4209 | 37.7437640174905 | -122.484420918217 | (37.7437640174905, -122.484420918217) | 1 | 8 | 3 | 29491 | 35 | |||
| 190318 | 183840 | DPW Maintained 1 | :: 45 | 2215 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986663.0466 | 2100148.329 | 37.7458371678329 | -122.488853410496 | (37.7458371678329, -122.488853410496) | 1 | 8 | 3 | 29491 | 35 | |||
| 190099 | 142224 | DPW Maintained 1 | :: 45 | 633 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004805.4597 | 2110871.2494 | 37.7763218676751 | -122.426883014235 | (37.7763218676751, -122.426883014235) | 7 | 9 | 11 | 28852 | 10 | |||
| 190040 | 182208 | DPW Maintained 1 | :: 45 | 1666 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989675.9216 | 2104008.911 | 37.7566126781149 | -122.478717721193 | (37.7566126781149, -122.478717721193) | 1 | 8 | 3 | 56 | 35 | |||
| 189965 | 183824 | DPW Maintained 1 | :: 45 | 2233 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987596.1103 | 2100080.691 | 37.7457058618775 | -122.48562208588 | (37.7457058618775, -122.48562208588) | 1 | 8 | 3 | 29491 | 35 | |||
| 189900 | 185223 | DPW Maintained 1 | :: 45 | 2515 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985800.5083 | 2098093.5658 | 37.7401449642117 | -122.491684672602 | (37.7401449642117, -122.491684672602) | 1 | 8 | 3 | 29491 | 35 | |||
| 189685 | 183053 | DPW Maintained 1 | :: 45 | 2601 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5990456.6898 | 2097547.4037 | 37.7389163684121 | -122.47554578609 | (37.7389163684121, -122.47554578609) | 1 | 8 | 3 | 29491 | 35 | |||
| 189643 | 182249 | DPW Maintained 1 | :: 45 | 1439 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985551.6486 | 2105407.6907 | 37.7602130091404 | -122.493083776053 | (37.7602130091404, -122.493083776053) | 1 | 8 | 3 | 56 | 35 | |||
| 189505 | 184725 | DPW Maintained 1 | :: 45 | 1647 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984666.3522 | 2103976.5631 | 37.7562317154001 | -122.49603996978 | (37.7562317154001, -122.49603996978) | 1 | 8 | 3 | 56 | 35 | |||
| 189442 | 182505 | DPW Maintained 1 | :: 45 | 1569 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985579.8974 | 2104539.4923 | 37.7578308288525 | -122.492922126296 | (37.7578308288525, -122.492922126296) | 1 | 8 | 3 | 56 | 35 | |||
| 189138 | 182247 | DPW Maintained 1 | :: 45 | 1454 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985597.5878 | 2105309.9322 | 37.759947278047 | -122.49291769541 | (37.759947278047, -122.49291769541) | 1 | 8 | 3 | 56 | 35 | |||
| 189115 | 182125 | DPW Maintained 1 | :: 45 | 2550 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988051.6952 | 2098318.4978 | 37.7408938790713 | -122.483917567452 | (37.7408938790713, -122.483917567452) | 1 | 8 | 3 | 29491 | 35 | |||
| 189112 | 115869 | Undocumented 4 | :: 45 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.7123636875758 | -122.436033295685 | (37.7123636875758, -122.436033295685) | 9 | 7 | 6 | 28861 | 5 | ||||
| 188912 | 184421 | DPW Maintained 1 | :: 45 | 3741 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981751.4657 | 2100769.1792 | 37.7472539827413 | -122.505882690421 | (37.7472539827413, -122.505882690421) | 1 | 8 | 3 | 29491 | 35 | |||
| 188865 | 182283 | DPW Maintained 1 | :: 45 | 1480 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984982.9221 | 2105136.6498 | 37.7594355282133 | -122.495030717205 | (37.7594355282133, -122.495030717205) | 1 | 8 | 3 | 56 | 35 | |||
| 188780 | 228483 | DPW Maintained 1 | :: 45 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.443631159362 | (37.751787354827, -122.443631159362) | 2 | 5 | 5 | 63 | 38 | |||
| 188778 | 183799 | DPW Maintained 1 | :: 45 | 2207 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989759.906 | 2100314.3647 | 37.7464733064726 | -122.478157163088 | (37.7464733064726, -122.478157163088) | 1 | 8 | 3 | 29491 | 35 | |||
| 188269 | 244494 | DPW Maintained 1 | :: 45 | 400 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/08/2009 12:00:00 AM | 5 | Width 0ft | 6004177.5073 | 2109444.407 | 37.7723685822151 | -122.428953525151 | (37.7723685822151, -122.428953525151) | 7 | 9 | 11 | 29492 | 10 | ||
| 188194 | 183859 | Undocumented 4 | :: 45 | 2247 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987908.9096 | 2099989.7957 | 37.745474508043 | -122.484533819529 | (37.745474508043, -122.484533819529) | 1 | 8 | 3 | 29491 | 35 | |||
| 188071 | 182227 | DPW Maintained 1 | :: 45 | 1674 21st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5989678.7682 | 2103960.5181 | 37.7564799694095 | -122.478704337689 | (37.7564799694095, -122.478704337689) | 1 | 8 | 3 | 56 | 35 | |||
| 188054 | 35462 | DPW Maintained 1 | :: 45 | 1016 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | 6 | Permit Number 38885 | 6014468.80099 | 2102427.52316 | 37.7536788925865 | -122.392863694223 | (37.7536788925865, -122.392863694223) | 10 | 3 | 8 | 28856 | 29 | |
| 188000 | 141642 | DPW Maintained 1 | :: 45 | 38 ATALAYA TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998855.464 | 2110898.4587 | 37.7760583555584 | -122.447467576969 | (37.7760583555584, -122.447467576969) | 15 | 6 | 2 | 29492 | 16 | |||
| 187990 | 246199 | DPW Maintained 1 | :: 45 | 737 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5999875.5825 | 2108001.7222 | 37.7681628926873 | -122.443730574399 | (37.7681628926873, -122.443730574399) | 15 | 5 | 11 | 29492 | 9 | |||
| 187984 | 105065 | Permitted Site 7 | :: 45 | 3177 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006744 | 2099801.7 | 37.7460368842113 | -122.419391572433 | (37.7460368842113, -122.419391572433) | 2 | 7 | 7 | 28859 | 2 | ||||
| 187961 | 186047 | DPW Maintained 1 | :: 45 | 1900 37th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984778.2299 | 2102058.2647 | 37.7509711496958 | -122.495511585412 | (37.7509711496958, -122.495511585412) | 1 | 8 | 3 | 29491 | 35 | |||
| 187766 | 182270 | DPW Maintained 1 | :: 45 | 1468 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984979.6145 | 2105227.4255 | 37.759684579371 | -122.495048849987 | (37.759684579371, -122.495048849987) | 1 | 8 | 3 | 56 | 35 | |||
| 187762 | 181965 | DPW Maintained 1 | :: 45 | 2423 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987019.5087 | 2098756.0771 | 37.7420352120933 | -122.487518574945 | (37.7420352120933, -122.487518574945) | 1 | 8 | 3 | 29491 | 35 | |||
| 187644 | 183620 | DPW Maintained 1 | :: 45 | 1435 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982754.5672 | 2105435.1976 | 37.7601245522633 | -122.502759435641 | (37.7601245522633, -122.502759435641) | 1 | 8 | 3 | 56 | 35 | |||
| 187473 | 183948 | DPW Maintained 1 | :: 45 | 2142 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989477.2684 | 2100748.2781 | 37.7476483084144 | -122.479166217201 | (37.7476483084144, -122.479166217201) | 1 | 8 | 3 | 29491 | 35 | |||
| 187362 | 182321 | DPW Maintained 1 | :: 45 | 2945 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985646.7454 | 2104986.0725 | 37.7590609236297 | -122.492723832324 | (37.7590609236297, -122.492723832324) | 1 | 8 | 3 | 56 | 35 | |||
| 187348 | 183723 | DPW Maintained 1 | :: 45 | 2251 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985430.1991 | 2099886.7383 | 37.7450468837647 | -122.493097094872 | (37.7450468837647, -122.493097094872) | 1 | 8 | 3 | 29491 | 35 | |||
| 186980 | 182385 | DPW Maintained 1 | :: 45 | 1539 33rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985884.186 | 2104731.9425 | 37.75837703407 | -122.491883952425 | (37.75837703407, -122.491883952425) | 1 | 8 | 3 | 56 | 35 | |||
| 186908 | 33406 | Permitted Site 7 | :: 45 | 100 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | 1 | 5 | 4 | 59 | 40 | ||
| 186789 | 105088 | Significant Tree 6 | :: 45 | 344 Fulton St | 8 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 186465 | 181971 | DPW Maintained 1 | :: 45 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.491755959468 | (37.7410800425161, -122.491755959468) | 1 | 8 | 3 | 29491 | 35 | |||
| 186416 | 182348 | DPW Maintained 1 | :: 45 | 3129 Kirkham St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985159.2817 | 2104971.8988 | 37.7589934905714 | -122.494408643399 | (37.7589934905714, -122.494408643399) | 1 | 8 | 3 | 56 | 35 | |||
| 186195 | 182874 | DPW Maintained 1 | :: 45 | 1691 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5988087.7378 | 2103811.4271 | 37.7559780978236 | -122.484195682649 | (37.7559780978236, -122.484195682649) | 1 | 8 | 3 | 56 | 35 | |||
| 185913 | 138464 | DPW Maintained 1 | :: 45 | 1860 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001535.6052 | 2114878.1517 | 37.7871383757455 | -122.438481476588 | (37.7871383757455, -122.438481476588) | 13 | 6 | 11 | 29490 | 27 | |||
| 185827 | 10354 | DPW Maintained 1 | :: 45 | 1016 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/2000 12:00:00 AM | 20 | 3X3 | 6001244.7283 | 2109040.2146 | 37.7710923306016 | -122.439069286514 | (37.7710923306016, -122.439069286514) | 15 | 5 | 11 | 29492 | 9 | ||
| 185767 | 141123 | DPW Maintained 1 | :: 45 | 144 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998637.0216 | 2112710.0541 | 37.7810200422428 | -122.448353710975 | (37.7810200422428, -122.448353710975) | 15 | 6 | 2 | 54 | 16 | |||
| 185065 | 183277 | DPW Maintained 1 | :: 45 | 1255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981785.9112 | 2106543.1909 | 37.7631098104891 | -122.506191655726 | (37.7631098104891, -122.506191655726) | 1 | 8 | 3 | 56 | 35 | |||
| 184827 | 184392 | DPW Maintained 1 | :: 45 | 2040 Lower Great Hwy | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 0 | Width 0ft | 5981213.3751 | 2101162.7638 | 37.7483029686657 | -122.50777253673 | (37.7483029686657, -122.50777253673) | 1 | 8 | 3 | 29491 | 35 | |||
| 184754 | 35137 | Permitted Site 7 | :: 45 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | 9 | 7 | 6 | 28861 | 5 | ||
| 184750 | 120651 | Undocumented 4 | :: 45 | 114 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005371 | 2102934 | 37.7545600310384 | -122.424361977892 | (37.7545600310384, -122.424361977892) | 2 | 4 | 5 | 28859 | 19 | ||||
| 184400 | 181857 | DPW Maintained 1 | :: 45 | 2329 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987926.9868 | 2099431.0594 | 37.7439414188855 | -122.4844303389 | (37.7439414188855, -122.4844303389) | 1 | 8 | 3 | 29491 | 35 | |||
| 184341 | 181902 | DPW Maintained 1 | :: 45 | 2370 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986740.6492 | 2099140.1859 | 37.7430736050662 | -122.488510993633 | (37.7430736050662, -122.488510993633) | 1 | 8 | 3 | 29491 | 35 | |||
| 184263 | 183785 | DPW Maintained 1 | :: 45 | 2146 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986125.7828 | 2099614.0525 | 37.744338818609 | -122.490671864125 | (37.744338818609, -122.490671864125) | 1 | 8 | 3 | 29491 | 35 | |||
| 184197 | 183631 | DPW Maintained 1 | :: 45 | 1451 45th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982139.8696 | 2105211.8354 | 37.7594751192783 | -122.50486879402 | (37.7594751192783, -122.50486879402) | 1 | 8 | 3 | 56 | 35 | |||
| 183660 | 141522 | DPW Maintained 1 | :: 45 | 200 STANYAN ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5996688.4722 | 2111189.7999 | 37.7767342289075 | -122.454984790063 | (37.7767342289075, -122.454984790063) | 15 | 6 | 2 | 54 | 16 | |||
| 183645 | 109178 | Permitted Site 7 | :: 45 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.7961845444049 | -122.438522078694 | (37.7961845444049, -122.438522078694) | 13 | 9 | 1 | 57 | 17 | |||
| 183445 | 183826 | DPW Maintained 1 | :: 45 | 2206 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986393.3478 | 2100193.5633 | 37.7459456255897 | -122.489789304245 | (37.7459456255897, -122.489789304245) | 1 | 8 | 3 | 29491 | 35 | |||
| 183430 | 182036 | DPW Maintained 1 | :: 45 | 1314 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987424.9672 | 2106327.6806 | 37.7628484313073 | -122.486672489667 | (37.7628484313073, -122.486672489667) | 1 | 8 | 3 | 56 | 35 | |||
| 183309 | 182843 | DPW Maintained 1 | :: 45 | 1812 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985372.9296 | 2102846.9583 | 37.7531714914415 | -122.493513191068 | (37.7531714914415, -122.493513191068) | 1 | 8 | 3 | 56 | 35 | |||
| 183044 | 116274 | Undocumented 4 | :: 45 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
| 183030 | 31188 | Permitted Site 7 | :: 45 | 744 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | 9 | 8 | 6 | 64 | 24 | ||
| 183022 | 182038 | DPW Maintained 1 | :: 45 | 1319 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987384.8091 | 2106266.2339 | 37.7626773744039 | -122.486806868235 | (37.7626773744039, -122.486806868235) | 1 | 8 | 3 | 56 | 35 | |||
| 182707 | 183266 | DPW Maintained 1 | :: 45 | 1235 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982090.5566 | 2106669.6909 | 37.7634750727275 | -122.50514738367 | (37.7634750727275, -122.50514738367) | 1 | 8 | 3 | 56 | 35 |
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) );