trees
713 rows where qSpecies_id = 102 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 415 | 190934 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.7526102335912 | -122.390415424833 | (37.7526102335912, -122.390415424833) | 10 | 3 | 8 | 28856 | 1 | |||
| 646 | 223229 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3856 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6004052.87626 | 2102494.4926 | 37.7532787266382 | -122.428889066793 | (37.7532787266382, -122.428889066793) | 2 | 4 | 5 | 28862 | 22 | |||
| 1016 | 84387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012577.97369 | 2099023.613 | 37.7442272813575 | -122.399163722146 | (37.7442272813575, -122.399163722146) | 10 | 3 | 8 | 58 | 1 | |||
| 1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
| 1780 | 223125 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1105 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009223.64941 | 2102625.89478 | 37.7539308430518 | -122.411016683293 | (37.7539308430518, -122.411016683293) | 2 | 4 | 7 | 28859 | 19 | |||
| 3357 | 223122 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 148 Ellert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007428.54288 | 2096958.74229 | 37.7382692862941 | -122.416823127285 | (37.7382692862941, -122.416823127285) | 2 | 7 | 7 | 28859 | 2 | |||
| 3902 | 223217 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1191 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6003256 | 2101366 | 37.75013501563 | -122.431564267794 | (37.75013501563, -122.431564267794) | 2 | 4 | 5 | 28862 | 22 | |||
| 4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 4149 | 169685 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2585 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002269.97794 | 2096798.3861 | 37.7375374800648 | -122.43464741415 | (37.7375374800648, -122.43464741415) | 2 | 7 | 5 | 63 | 7 | |||
| 4597 | 190929 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | 10 | 3 | 8 | 28856 | 1 | |||
| 4742 | 243755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 51 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002062.89469 | 2096349.46794 | 37.7362930962328 | -122.43533129551 | (37.7362930962328, -122.43533129551) | 2 | 7 | 5 | 63 | 7 | |||
| 5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
| 5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
| 5995 | 258380 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
| 6277 | 223139 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 512 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001868.53101 | 2100910.74029 | 37.7488062416211 | -122.43632963112 | (37.7488062416211, -122.43632963112) | 2 | 4 | 5 | 28862 | 22 | |||
| 6305 | 223216 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1199 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6003236.71936 | 2101328.34532 | 37.7500305318879 | -122.431628253337 | (37.7500305318879, -122.431628253337) | 2 | 4 | 5 | 28862 | 22 | |||
| 6349 | 78274 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1715 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013961.91267 | 2093099.05364 | 37.7280366912377 | -122.393963673903 | (37.7280366912377, -122.393963673903) | 10 | 3 | 8 | 58 | 1 | |||
| 6404 | 73766 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3834 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996504.18251 | 2114976.06965 | 37.7871197485358 | -122.45589607746 | (37.7871197485358, -122.45589607746) | 11 | 6 | 1 | 54 | 31 | |||
| 6544 | 223185 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
| 7017 | 223186 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007192 | 2097251 | 37.7390584535481 | -122.417661686747 | (37.7390584535481, -122.417661686747) | 2 | 7 | 7 | 28859 | 2 | |||
| 7281 | 258376 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1030 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007799.31029 | 2093439.67558 | 37.7286275425489 | -122.415292145905 | (37.7286275425489, -122.415292145905) | 9 | 3 | 7 | 309 | 5 | |||
| 7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
| 8537 | 78846 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992056.72748 | 2086721.95578 | 37.7092849811889 | -122.469225944831 | (37.7092849811889, -122.469225944831) | 9 | 8 | 4 | 64 | 24 | |||
| 9100 | 84393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6012494.05335 | 2099085.01558 | 37.7443912025977 | -122.399458212338 | (37.7443912025977, -122.399458212338) | 10 | 3 | 8 | 58 | 1 | |||
| 9182 | 223199 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2957 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009122.48149 | 2102727.86117 | 37.7542051461569 | -122.411373750107 | (37.7542051461569, -122.411373750107) | 2 | 4 | 7 | 28859 | 19 | |||
| 11345 | 140075 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 544 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005143.7718 | 2111312.9909 | 37.7775539050019 | -122.425744146907 | (37.7775539050019, -122.425744146907) | 7 | 9 | 11 | 28852 | 10 | |||
| 11641 | 223098 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004264.58531 | 2109293.13989 | 37.7719581680779 | -122.428641529305 | (37.7719581680779, -122.428641529305) | 7 | 9 | 11 | 28852 | 10 | |||
| 11774 | 158438 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 55 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6002040.0229 | 2096307.75742 | 37.7361772698529 | -122.43540738986 | (37.7361772698529, -122.43540738986) | 2 | 7 | 5 | 63 | 7 | |||
| 11985 | 206738 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2110 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993654.98108 | 2101316.80215 | 37.7494510717083 | -122.46476131899 | (37.7494510717083, -122.46476131899) | 1 | 8 | 4 | 29491 | 40 | |||
| 12117 | 223149 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3925 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002289.78631 | 2103524.74331 | 37.7560075979872 | -122.435059863923 | (37.7560075979872, -122.435059863923) | 2 | 4 | 5 | 28862 | 22 | ||||
| 12195 | 206712 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993729.968 | 2103029.70657 | 37.7541585918487 | -122.464626378423 | (37.7541585918487, -122.464626378423) | 1 | 8 | 4 | 56 | 12 | |||
| 12296 | 206714 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993663.54553 | 2103899.42942 | 37.7565427971281 | -122.464919240823 | (37.7565427971281, -122.464919240823) | 1 | 8 | 4 | 56 | 12 | |||
| 12526 | 206776 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 339 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995718.3884 | 2098491.52687 | 37.7418123157002 | -122.457421671194 | (37.7418123157002, -122.457421671194) | 1 | 8 | 4 | 59 | 40 | |||
| 12597 | 144628 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 5988384.27006 | 2114435.54017 | 37.7851662339868 | -122.4839491984 | (37.7851662339868, -122.4839491984) | 11 | 6 | 2 | 55 | 26 | |||
| 13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
| 13495 | 223059 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 154 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6006099.59544 | 2099325.6028 | 37.7446933136478 | -122.421586033986 | (37.7446933136478, -122.421586033986) | 2 | 7 | 5 | 28859 | 2 | |||
| 13635 | 261439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 374x Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
| 13687 | 223210 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4096 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003278.99066 | 2101283.19814 | 37.749908964249 | -122.431478854381 | (37.749908964249, -122.431478854381) | 2 | 4 | 5 | 28862 | 22 | |||
| 14040 | 190944 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1701 Newhall St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6014004.94796 | 2095137.53702 | 37.7336363433234 | -122.393957536921 | (37.7336363433234, -122.393957536921) | 10 | 3 | 8 | 58 | 1 | |||
| 14459 | 223187 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105x Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007139 | 2097159 | 37.7388028593756 | -122.417838417363 | (37.7388028593756, -122.417838417363) | 2 | 7 | 7 | 28859 | 2 | |||
| 14770 | 223263 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1713 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003981.90505 | 2098315.20086 | 37.7417993447574 | -122.42883657696 | (37.7417993447574, -122.42883657696) | 2 | 7 | 5 | 63 | 7 | |||
| 15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
| 16611 | 258381 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
| 17067 | 223124 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 99x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
| 17578 | 223163 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 220 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6008988.9604 | 2097329.9937 | 37.7393763076577 | -122.411454173775 | (37.7393763076577, -122.411454173775) | 10 | 7 | 7 | 28859 | 2 | |||
| 17649 | 223213 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1229 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003245.25071 | 2101106.06647 | 37.7494206899277 | -122.431582884368 | (37.7494206899277, -122.431582884368) | 2 | 4 | 5 | 28862 | 22 | |||
| 18209 | 78205 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014348.06009 | 2094265.06475 | 37.7312597751042 | -122.392710275271 | (37.7312597751042, -122.392710275271) | 10 | 3 | 8 | 58 | 1 | |||
| 18239 | 120242 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 288 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5988397.89946 | 2114035.20565 | 37.7840678224086 | -122.483872680677 | (37.7840678224086, -122.483872680677) | 11 | 6 | 2 | 55 | 26 | |||
| 18307 | 206786 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6000024.48409 | 2094930.02996 | 37.732279679167 | -122.442277038462 | (37.732279679167, -122.442277038462) | 9 | 7 | 4 | 63 | 40 | |||
| 18332 | 223062 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 257 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007025.24447 | 2107893.6932 | 37.7682714683756 | -122.41899290632 | (37.7682714683756, -122.41899290632) | 8 | 4 | 7 | 28853 | 19 | |||
| 19006 | 259153 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 207 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007591 | 2097689 | 37.7402835491894 | -122.416313137546 | (37.7402835491894, -122.416313137546) | 2 | 7 | 7 | 28859 | 2 | ||||
| 19146 | 223231 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004263.07305 | 2103628.9074 | 37.7564054580508 | -122.428243005513 | (37.7564054580508, -122.428243005513) | 2 | 4 | 5 | 28862 | 22 | |||
| 19857 | 223198 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2901 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009412.47335 | 2102745.855 | 37.7542708137705 | -122.410372152653 | (37.7542708137705, -122.410372152653) | 2 | 4 | 7 | 28859 | 19 | |||
| 19895 | 223061 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3705 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005700.15311 | 2101372.39104 | 37.750290794794 | -122.423112686203 | (37.750290794794, -122.423112686203) | 2 | 4 | 5 | 28859 | 19 | |||
| 20547 | 190947 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6013395.86609 | 2110840.5938 | 37.7767196691005 | -122.397164055286 | (37.7767196691005, -122.397164055286) | 6 | 2 | 9 | 28856 | 34 | |||
| 20685 | 103447 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 20720 | 223188 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007765.60912 | 2096998.87207 | 37.7383984271532 | -122.415660555692 | (37.7383984271532, -122.415660555692) | 2 | 7 | 7 | 28859 | 2 | |||
| 21451 | 223252 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 223 Buena Vista Ave East | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001379.7968 | 2108143.42128 | 37.7686376435263 | -122.438537815694 | (37.7686376435263, -122.438537815694) | 15 | 5 | 5 | 29492 | 3 | |||
| 21503 | 223143 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 605 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002444.15174 | 2102068.56819 | 37.7520180525139 | -122.434421909144 | (37.7520180525139, -122.434421909144) | 2 | 4 | 5 | 28862 | 22 | |||
| 22064 | 113315 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2493x 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5984243.3692 | 2098259.1068 | 37.7405083669922 | -122.497080760951 | (37.7405083669922, -122.497080760951) | 1 | 8 | 3 | 29491 | 35 | |||
| 22791 | 126391 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Clay St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5997748.40757 | 2115473.64195 | 37.7885572815394 | -122.451627258297 | (37.7885572815394, -122.451627258297) | 11 | 6 | 1 | 54 | 31 | |||
| 23152 | 206764 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995805.65457 | 2094327.40967 | 37.7303836780568 | -122.456818834923 | (37.7303836780568, -122.456818834923) | 9 | 7 | 4 | 28861 | 40 | |||
| 23347 | 206742 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5997796.56298 | 2094976.80615 | 37.7322808851511 | -122.449982803857 | (37.7322808851511, -122.449982803857) | 9 | 7 | 4 | 59 | 40 | |||
| 23893 | 206710 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5991484.15293 | 2106105.9073 | 37.7624753009047 | -122.472617151554 | (37.7624753009047, -122.472617151554) | 1 | 8 | 11 | 56 | 12 | |||
| 24421 | 206756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991004.48671 | 2100128.5419 | 37.7460352505192 | -122.473840030798 | (37.7460352505192, -122.473840030798) | 1 | 8 | 4 | 29491 | 40 | |||
| 24718 | 190936 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012268.87212 | 2103730.35281 | 37.7571337389375 | -122.400563099634 | (37.7571337389375, -122.400563099634) | 10 | 3 | 8 | 28856 | 29 | |||
| 24775 | 223151 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1 Mizpah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001079.42041 | 2096656.30297 | 37.7370796927675 | -122.438753546857 | (37.7370796927675, -122.438753546857) | 2 | 7 | 5 | 63 | 7 | |||
| 25089 | 206711 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1366 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991481.24454 | 2106127.13421 | 37.7625334160042 | -122.472628758222 | (37.7625334160042, -122.472628758222) | 1 | 8 | 11 | 56 | 12 | |||
| 26030 | 206732 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2430 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991403.39763 | 2098862.37414 | 37.7425817765239 | -122.472368375716 | (37.7425817765239, -122.472368375716) | 1 | 8 | 4 | 29491 | 40 | |||
| 26169 | 206759 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995896.88081 | 2094136.36483 | 37.7298643528405 | -122.456489645298 | (37.7298643528405, -122.456489645298) | 9 | 7 | 4 | 28861 | 40 | |||
| 26560 | 206771 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 59 El Verano Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994676.70576 | 2094842.34455 | 37.7317326737219 | -122.46075904452 | (37.7317326737219, -122.46075904452) | 9 | 8 | 4 | 59 | 40 | |||
| 26568 | 223100 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 323 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6003606.73212 | 2099501.75827 | 37.7450361154323 | -122.43021843293 | (37.7450361154323, -122.43021843293) | 2 | 7 | 5 | 63 | 22 | |||
| 27308 | 206763 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995815.46326 | 2094322.90602 | 37.7303718753392 | -122.456784599525 | (37.7303718753392, -122.456784599525) | 9 | 7 | 4 | 28861 | 40 | |||
| 27356 | 250731 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2745 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986887.59373 | 2114422.31311 | 37.785042671624 | -122.489126191619 | (37.785042671624, -122.489126191619) | 11 | 6 | 1 | 55 | 33 | |||
| 27906 | 103441 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
| 28151 | 190948 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013368.27074 | 2110817.70841 | 37.7766552947402 | -122.397257911242 | (37.7766552947402, -122.397257911242) | 6 | 2 | 9 | 28856 | 34 | |||
| 28323 | 206708 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1926 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5991286.95111 | 2102293.22218 | 37.7519952564944 | -122.473021145018 | (37.7519952564944, -122.473021145018) | 1 | 8 | 4 | 29491 | 12 | |||
| 28412 | 223085 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1383 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010105.40683 | 2101175.29906 | 37.7499972353919 | -122.407865061343 | (37.7499972353919, -122.407865061343) | 2 | 4 | 7 | 28859 | 19 | |||
| 28427 | 126393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 405 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5998114.64668 | 2115082.3398 | 37.7875038363742 | -122.450331914389 | (37.7875038363742, -122.450331914389) | 11 | 6 | 1 | 54 | 31 | |||
| 29107 | 190945 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 40 Bluxome St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6013445.03636 | 2110888.0497 | 37.7768527094247 | -122.396997287698 | (37.7768527094247, -122.396997287698) | 6 | 2 | 9 | 28856 | 34 | |||
| 29702 | 223141 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4644 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000468.40561 | 2101124.67323 | 37.7493139961397 | -122.441186594305 | (37.7493139961397, -122.441186594305) | 2 | 4 | 5 | 28862 | 22 | |||
| 29874 | 126390 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3751 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996763.42592 | 2114965.78353 | 37.7871063810023 | -122.454998413757 | (37.7871063810023, -122.454998413757) | 11 | 6 | 1 | 54 | 31 | |||
| 30310 | 206768 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 24 Merced Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995217.94161 | 2100123.23071 | 37.7462638105263 | -122.459270173693 | (37.7462638105263, -122.459270173693) | 1 | 8 | 4 | 59 | 40 | |||
| 31389 | 223238 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3819 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004233.22031 | 2104799.55992 | 37.7596181035173 | -122.428429683205 | (37.7596181035173, -122.428429683205) | 2 | 4 | 5 | 28862 | 3 | |||
| 31442 | 126387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3751 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996876.15534 | 2114980.73672 | 37.7871539047628 | -122.454609477651 | (37.7871539047628, -122.454609477651) | 11 | 6 | 1 | 54 | 31 | |||
| 32339 | 223182 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006910.11223 | 2097068.32628 | 37.7385410056619 | -122.41862337757 | (37.7385410056619, -122.41862337757) | 2 | 7 | 7 | 28859 | 2 | |||
| 32362 | 206744 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 360 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997700.14288 | 2093824.21589 | 37.7291106283493 | -122.450233097774 | (37.7291106283493, -122.450233097774) | 9 | 7 | 4 | 28861 | 40 | |||
| 32830 | 206741 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 527 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997915.91197 | 2094377.49902 | 37.7306421584929 | -122.449527021155 | (37.7306421584929, -122.449527021155) | 9 | 7 | 4 | 28861 | 40 | |||
| 33441 | 206753 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 355 Parnassus Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 5ft | 5996046.6732 | 2106441.49184 | 37.7636597709952 | -122.456861438509 | (37.7636597709952, -122.456861438509) | 15 | 5 | 4 | 29492 | 12 | |||
| 34628 | 223262 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003313.48049 | 2109165.67905 | 37.7715543194136 | -122.431922366729 | (37.7715543194136, -122.431922366729) | 15 | 9 | 11 | 29492 | 10 | |||
| 34656 | 223146 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1543 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003344.33647 | 2099293.67104 | 37.7444498905663 | -122.431110900363 | (37.7444498905663, -122.431110900363) | 2 | 7 | 5 | 63 | 22 | |||
| 35038 | 206706 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1479 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991135.60294 | 2105348.51695 | 37.7603755269382 | -122.473767390769 | (37.7603755269382, -122.473767390769) | 1 | 8 | 4 | 56 | 12 | |||
| 35776 | 223254 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6001416.18598 | 2108119.15554 | 37.7685730857195 | -122.438410209957 | (37.7685730857195, -122.438410209957) | 15 | 5 | 5 | 29492 | 3 | |||
| 36063 | 223116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 13 Stoneman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008405.91567 | 2099418.14842 | 37.7450772000642 | -122.413617744757 | (37.7450772000642, -122.413617744757) | 2 | 7 | 7 | 28859 | 2 | |||
| 36636 | 223184 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 39 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006986.80584 | 2097054.98835 | 37.7385087002251 | -122.418357261872 | (37.7385087002251, -122.418357261872) | 2 | 7 | 7 | 28859 | 2 | |||
| 36830 | 206713 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1835 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993730.54086 | 2103003.335 | 37.7540862153215 | -122.464622482542 | (37.7540862153215, -122.464622482542) | 1 | 8 | 4 | 56 | 12 | |||
| 37017 | 223065 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 436 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005845.27485 | 2107876.32583 | 37.7681572661617 | -122.423073077374 | (37.7681572661617, -122.423073077374) | 8 | 4 | 5 | 28853 | 19 | |||
| 37595 | 206755 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991006.69103 | 2100092.27446 | 37.7459357971944 | -122.473829763244 | (37.7459357971944, -122.473829763244) | 1 | 8 | 4 | 29491 | 40 | |||
| 38105 | 223211 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 263 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003447.74658 | 2100952.52309 | 37.7490105711977 | -122.430871692397 | (37.7490105711977, -122.430871692397) | 2 | 4 | 5 | 28862 | 22 | |||
| 38263 | 206777 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 339 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995709.16123 | 2098486.51672 | 37.7417980290669 | -122.457453213121 | (37.7417980290669, -122.457453213121) | 1 | 8 | 4 | 59 | 40 |
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) );