trees
406 rows where qSpecies_id = 110 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 472 | 221573 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 40 Elgin Park | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6005806.54195 | 2108839.22973 | 37.7707989842145 | -122.423275507581 | (37.7707989842145, -122.423275507581) | 8 | 2 | 5 | 28853 | 19 | |||
| 688 | 221623 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 200X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007846.60865 | 2096102.95015 | 37.735942974893 | -122.415317092012 | (37.735942974893, -122.415317092012) | 2 | 7 | 7 | 28859 | 2 | |||
| 858 | 136518 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 153 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6013525.33028 | 2117958.01087 | 37.7962696533665 | -122.397215406586 | (37.7962696533665, -122.397215406586) | 3 | 1 | 10 | 28860 | 6 | |||
| 999 | 149181 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 525 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010691.32524 | 2105791.75109 | 37.7627057701797 | -122.40616411869 | (37.7627057701797, -122.40616411869) | 8 | 4 | 8 | 28859 | 19 | |||
| 1565 | 221609 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2795 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008187.06848 | 2106771.35973 | 37.7652551566233 | -122.414894813551 | (37.7652551566233, -122.414894813551) | 8 | 4 | 7 | 28859 | 19 | |||
| 2013 | 221634 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3647 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003905.15604 | 2103026.4808 | 37.7547310787034 | -122.4294378484 | (37.7547310787034, -122.4294378484) | 2 | 4 | 5 | 28862 | 22 | |||
| 2244 | 144822 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 768 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 3ft | 5989780.16319 | 2110130.24673 | 37.7734262600497 | -122.47880490542 | (37.7734262600497, -122.47880490542) | 11 | 6 | 2 | 55 | 26 | ||
| 2500 | 258153 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 546 Sanchez St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6003620.18216 | 2105099.99944 | 37.760408329171 | -122.430571313 | (37.760408329171, -122.430571313) | 2 | 4 | 5 | 28862 | 3 | ||||
| 2699 | 260850 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 590 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985681.12582 | 2111876.19139 | 37.7779812613037 | -122.493112500198 | (37.7779812613037, -122.493112500198) | 11 | 6 | 2 | 55 | 26 | |||
| 3263 | 172242 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 206 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002643.33375 | 2092492.59433 | 37.725735943934 | -122.433049002312 | (37.725735943934, -122.433049002312) | 9 | 7 | 6 | 28861 | 5 | ||
| 3637 | 264837 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 809 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | 6010905 | 2090935 | 37.7219242812159 | -122.404379313404 | (37.7219242812159, -122.404379313404) | 10 | 3 | 7 | 309 | 28 | |||
| 3662 | 154048 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1655 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6014874.64448 | 2096968.67917 | 37.7387125819245 | -122.391078663176 | (37.7387125819245, -122.391078663176) | 10 | 3 | 8 | 58 | 1 | |||
| 4565 | 187804 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1022 Minna St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6007516.81394 | 2109678.2468 | 37.7731990993886 | -122.417419096312 | (37.7731990993886, -122.417419096312) | 8 | 2 | 9 | 28853 | 19 | |||
| 6407 | 1152 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2685 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5998075.46173 | 2088293.5285 | 37.7139461178871 | -122.448537441353 | (37.7139461178871, -122.448537441353) | 9 | 7 | 6 | 28861 | 25 | ||
| 6499 | 135530 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 232 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6013662.32848 | 2117872.96664 | 37.7960437679564 | -122.396735396131 | (37.7960437679564, -122.396735396131) | 3 | 1 | 10 | 28860 | 6 | |||
| 6641 | 118726 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 764 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982315.38657 | 2110576.11516 | 37.7742142113187 | -122.5046592382 | (37.7742142113187, -122.5046592382) | 11 | 6 | 2 | 55 | 26 | ||
| 6863 | 203308 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 254 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5999724.87507 | 2095247.89 | 37.7331353678889 | -122.443335674514 | (37.7331353678889, -122.443335674514) | 9 | 7 | 4 | 63 | 40 | |||
| 7124 | 240695 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 156 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/31/2018 12:00:00 AM | 3 | Width 3ft | 6004515.89032 | 2108795.08829 | 37.7706048583673 | -122.42773675377 | (37.7706048583673, -122.42773675377) | 7 | 9 | 11 | 28852 | 10 | |
| 7168 | 143976 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 700 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/18/2019 12:00:00 AM | 3 | Width 4ft | 5985406.3834 | 2111006.00619 | 37.7755759095482 | -122.493998769723 | (37.7755759095482, -122.493998769723) | 11 | 6 | 2 | 55 | 26 | |
| 7412 | 171245 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 130 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 4ft | 6003958.26769 | 2093062.28889 | 37.7273746984644 | -122.428543965437 | (37.7273746984644, -122.428543965437) | 9 | 7 | 6 | 28861 | 5 | ||
| 7687 | 221607 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 851 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009134.02591 | 2104222.54134 | 37.7583098480322 | -122.411439415915 | (37.7583098480322, -122.411439415915) | 2 | 4 | 7 | 28859 | 19 | |||
| 8043 | 23950 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003173.29907 | 2115903.30394 | 37.7900462027047 | -122.432888683778 | (37.7900462027047, -122.432888683778) | 13 | 9 | 1 | 29490 | 27 | |
| 8312 | 187793 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 570 Bryant St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013291.53911 | 2112061.35383 | 37.7800657892442 | -122.397610596567 | (37.7800657892442, -122.397610596567) | 6 | 2 | 9 | 28856 | 34 | |||
| 8328 | 141427 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 306 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6005914.5406 | 2110724.5553 | 37.7759817285641 | -122.423035961371 | (37.7759817285641, -122.423035961371) | 7 | 9 | 11 | 28852 | 10 | |||
| 8366 | 144821 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 778 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 6ft | 5989783.33827 | 2110070.51607 | 37.7732624404449 | -122.478789553117 | (37.7732624404449, -122.478789553117) | 11 | 6 | 2 | 55 | 26 | ||
| 8476 | 86613 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1060 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010229.12599 | 2109123.99636 | 37.7718294894697 | -122.407997713136 | (37.7718294894697, -122.407997713136) | 14 | 2 | 9 | 28853 | 34 | ||
| 9861 | 259369 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1415 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015886.92436 | 2093428.61021 | 37.729048386007 | -122.387331768509 | (37.729048386007, -122.387331768509) | 10 | 3 | 8 | 58 | 1 | ||
| 10013 | 221612 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 443 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6002290.76795 | 2100888.56087 | 37.7487693244402 | -122.434867953089 | (37.7487693244402, -122.434867953089) | 2 | 4 | 5 | 28862 | 22 | |||
| 10198 | 170329 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 199 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6001253.65206 | 2093315.32365 | 37.727916045377 | -122.437911919018 | (37.727916045377, -122.437911919018) | 9 | 7 | 6 | 28861 | 25 | ||
| 11318 | 169853 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 194 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001785.5532 | 2095118.40057 | 37.7328971149955 | -122.436202106347 | (37.7328971149955, -122.436202106347) | 9 | 7 | 5 | 63 | 40 | |||
| 11518 | 170330 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 199 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6001268.50413 | 2093328.38419 | 37.7279527512023 | -122.437861510205 | (37.7279527512023, -122.437861510205) | 9 | 7 | 6 | 28861 | 25 | ||
| 12048 | 28317 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 605 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007774.74538 | 2097230.6167 | 37.7390352604705 | -122.415645370645 | (37.7390352604705, -122.415645370645) | 2 | 7 | 7 | 28859 | 2 | ||
| 12341 | 120004 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 530 29th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/18/2019 12:00:00 AM | 3 | Width 4ft | 5986920.19544 | 2112296.72927 | 37.7792083283188 | -122.488857097106 | (37.7792083283188, -122.488857097106) | 11 | 6 | 2 | 55 | 26 | ||
| 12384 | 149800 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1155 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6015047.89525 | 2103254.40668 | 37.7559814870696 | -122.390918826658 | (37.7559814870696, -122.390918826658) | 10 | 3 | 8 | 28856 | 29 | |||
| 12668 | 243389 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 190 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004420.71335 | 2108783.01453 | 37.7705663223957 | -122.428065111534 | (37.7705663223957, -122.428065111534) | 7 | 9 | 11 | 28852 | 10 | |||
| 13281 | 61790 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1249 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 5 | Permit Number 21813 | 6011995.77759 | 2102561.7862 | 37.7539098771551 | -122.401425448751 | (37.7539098771551, -122.401425448751) | 10 | 3 | 8 | 28856 | 29 | |
| 14341 | 165739 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 129 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007603.82454 | 2098022.48872 | 37.7411999565157 | -122.416292409479 | (37.7411999565157, -122.416292409479) | 2 | 7 | 7 | 28859 | 2 | |||
| 14429 | 261134 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 51 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6004165 | 2093360 | 37.7282038440072 | -122.42785049594 | (37.7282038440072, -122.42785049594) | 9 | 7 | 6 | 28861 | 5 | ||
| 14769 | 221585 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1801 Bryant St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009531.49923 | 2106200.86646 | 37.7637641652204 | -122.410204446196 | (37.7637641652204, -122.410204446196) | 8 | 4 | 8 | 28859 | 19 | |||
| 15286 | 30757 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.7298378772398 | -122.390455236274 | (37.7298378772398, -122.390455236274) | 10 | 3 | 8 | 58 | 1 | |
| 15624 | 187814 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1020 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 6013124.66356 | 2089609.91274 | 37.718409647453 | -122.396613602732 | (37.718409647453, -122.396613602732) | 10 | 3 | 8 | 58 | 1 | |||
| 15885 | 175092 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 318 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998127.55186 | 2088899.90602 | 37.7156140698133 | -122.448401040281 | (37.7156140698133, -122.448401040281) | 9 | 7 | 6 | 28861 | 25 | |||
| 15994 | 143975 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 700 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 05/18/2019 12:00:00 AM | 3 | Width 4ft | 5985406.40584 | 2111033.42347 | 37.7756511908825 | -122.494000713179 | (37.7756511908825, -122.494000713179) | 11 | 6 | 2 | 55 | 26 | |
| 16637 | 221639 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 262 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004605.60731 | 2103984.07134 | 37.7574000299964 | -122.427083697576 | (37.7574000299964, -122.427083697576) | 2 | 4 | 5 | 28862 | 3 | |||
| 16729 | 203303 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1256 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994883.99772 | 2106952.30042 | 37.7649954872656 | -122.460919765941 | (37.7649954872656, -122.460919765941) | 15 | 5 | 11 | 56 | 12 | |||
| 16982 | 19368 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 352-360 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 54655 | 6011200.48284 | 2111246.22274 | 37.7777109702346 | -122.404787140633 | (37.7777109702346, -122.404787140633) | 14 | 2 | 9 | 28853 | 34 | |
| 17092 | 221622 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 200X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007865.83541 | 2096101.44464 | 37.7359399216775 | -122.415250510703 | (37.7359399216775, -122.415250510703) | 2 | 7 | 7 | 28859 | 2 | |||
| 17135 | 65196 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 326 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/2019 12:00:00 AM | 3 | Permit Number 27181 | 6003265.18452 | 2091962.93655 | 37.7243168758021 | -122.430861530055 | (37.7243168758021, -122.430861530055) | 9 | 7 | 6 | 28861 | 5 | |
| 17622 | 261005 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 778 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 4x4 | 5990736 | 2110099 | 37.7733959198391 | -122.475496281638 | (37.7733959198391, -122.475496281638) | 11 | 6 | 2 | 54 | 26 | |
| 18069 | 172241 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 204 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002657.85067 | 2092515.29847 | 37.7257991078395 | -122.433000439841 | (37.7257991078395, -122.433000439841) | 9 | 7 | 6 | 28861 | 5 | ||
| 18232 | 187807 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1501 25th St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014157.8907 | 2101958.46235 | 37.7523736777015 | -122.393906067809 | (37.7523736777015, -122.393906067809) | 10 | 3 | 8 | 28856 | 1 | ||||
| 18646 | 147612 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 227 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5990530.91214 | 2113870.34702 | 37.7837391070186 | -122.47648125872 | (37.7837391070186, -122.47648125872) | 11 | 6 | 2 | 55 | 26 | |||
| 18837 | 260887 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 811 41st Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5983217.77071 | 2110265.58898 | 37.7734146368587 | -122.501514803752 | (37.7734146368587, -122.501514803752) | 11 | 6 | 2 | 55 | 26 | |||
| 18892 | 143977 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 700 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 08/13/2020 12:00:00 AM | 3 | Width 4ft | 5985407.60497 | 2110981.83448 | 37.7755096124098 | -122.493992762253 | (37.7755096124098, -122.493992762253) | 11 | 6 | 2 | 55 | 26 | |
| 19253 | 154044 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1671 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x4 | 6014806.60938 | 2097019.04115 | 37.738847089929 | -122.391317417882 | (37.738847089929, -122.391317417882) | 10 | 3 | 8 | 58 | 1 | |||
| 19754 | 56179 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 771 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 2 | Permit Number 12287 | 5990973.49009 | 2110147.22925 | 37.7735421082814 | -122.474678298875 | (37.7735421082814, -122.474678298875) | 11 | 6 | 2 | 54 | 26 | ||
| 20348 | 86615 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1090 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/03/2011 12:00:00 AM | 3 | 3x3 | 6010138.02723 | 2109041.45906 | 37.7715977602665 | -122.40830700887 | (37.7715977602665, -122.40830700887) | 14 | 2 | 9 | 28853 | 34 | ||
| 20413 | 175085 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2555 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998719.50831 | 2088640.59786 | 37.7149358955534 | -122.44633633538 | (37.7149358955534, -122.44633633538) | 9 | 7 | 6 | 28861 | 25 | |||
| 20415 | 221596 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 284 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004141.2523 | 2098697.9231 | 37.7428592299584 | -122.428312877464 | (37.7428592299584, -122.428312877464) | 2 | 7 | 5 | 63 | 22 | |||
| 21233 | 221603 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 431 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008783.89037 | 2096761.2657 | 37.7378032000621 | -122.412123034656 | (37.7378032000621, -122.412123034656) | 10 | 7 | 7 | 28859 | 2 | |||
| 22551 | 203299 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 301 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992897.60323 | 2094839.00247 | 37.7316209734226 | -122.4669094675 | (37.7316209734226, -122.4669094675) | 9 | 8 | 4 | 59 | 40 | |||
| 23076 | 58364 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1978 12:00:00 AM | 1 | Permit Number 17393 | 6000499.2722 | 2111849.5321 | 37.7787635613104 | -122.441849500148 | (37.7787635613104, -122.441849500148) | 15 | 5 | 11 | 29490 | 41 | ||
| 25746 | 220337 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1606 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002558.37947 | 2100838.96388 | 37.7486483332527 | -122.433939010086 | (37.7486483332527, -122.433939010086) | 2 | 4 | 5 | 28862 | 22 | |||
| 26845 | 31791 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 186 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2017 12:00:00 AM | 3 | Permit Number 779904 | 6001704.83909 | 2107714.56044 | 37.7674785819872 | -122.437382809181 | (37.7674785819872, -122.437382809181) | 15 | 5 | 5 | 29492 | 3 | |
| 26898 | 221640 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 264 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004586.45702 | 2103983.55816 | 37.7573975379924 | -122.427149890352 | (37.7573975379924, -122.427149890352) | 2 | 4 | 5 | 28862 | 3 | |||
| 27140 | 28318 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 605 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 3 | 3X3 | 6007759.23813 | 2097233.88848 | 37.7390433723402 | -122.41569921937 | (37.7390433723402, -122.41569921937) | 2 | 7 | 7 | 28859 | 2 | ||
| 29022 | 106100 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 420 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002342.776 | 2090999.30829 | 37.7216186623558 | -122.433981312389 | (37.7216186623558, -122.433981312389) | 9 | 7 | 6 | 28861 | 5 | |||
| 29426 | 23953 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2400X Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2001 12:00:00 AM | 3 | 4x4 | 6003112.92633 | 2115895.63108 | 37.7900217105728 | -122.433097019816 | (37.7900217105728, -122.433097019816) | 13 | 9 | 1 | 29490 | 27 | ||
| 30186 | 221610 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2795 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008166.3608 | 2106770.27621 | 37.7652510179325 | -122.414966360021 | (37.7652510179325, -122.414966360021) | 8 | 4 | 7 | 28859 | 19 | |||
| 30637 | 84636 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 989 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50127 | 6011103.6738 | 2111624.3911 | 37.7787439211168 | -122.405148673653 | (37.7787439211168, -122.405148673653) | 14 | 2 | 9 | 28856 | 34 | |
| 31096 | 175087 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 339 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004286.79403 | 2090457.00677 | 37.7202397543384 | -122.427222750735 | (37.7202397543384, -122.427222750735) | 9 | 7 | 6 | 28861 | 5 | |||
| 31636 | 221576 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 98 Elgin Park | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6005820.21347 | 2108567.35172 | 37.7700532438971 | -122.423208888478 | (37.7700532438971, -122.423208888478) | 8 | 2 | 5 | 28853 | 19 | |||
| 31745 | 187813 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 773 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009053.1077 | 2110262.78133 | 37.7748904130077 | -122.412146152643 | (37.7748904130077, -122.412146152643) | 8 | 2 | 9 | 28853 | 34 | |||
| 32966 | 85692 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 598 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6013183.76112 | 2111957.2599 | 37.7797739691436 | -122.397976147576 | (37.7797739691436, -122.397976147576) | 6 | 2 | 9 | 28856 | 34 | ||
| 34222 | 85678 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 750 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012220.56503 | 2111028.15837 | 37.7771691790611 | -122.401242978085 | (37.7771691790611, -122.401242978085) | 14 | 2 | 9 | 28856 | 34 | ||
| 34793 | 158381 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 366 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781963 | 6001041.11239 | 2096698.57943 | 37.7371935946103 | -122.43888902342 | (37.7371935946103, -122.43888902342) | 2 | 7 | 5 | 63 | 7 | |
| 34957 | 221631 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 345 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004168.1585 | 2101707.52304 | 37.7511244168801 | -122.42843430932 | (37.7511244168801, -122.42843430932) | 2 | 4 | 5 | 28862 | 22 | |||
| 36009 | 72129 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1183 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 6012255.77606 | 2102909.56429 | 37.7548793031435 | -122.400550735745 | (37.7548793031435, -122.400550735745) | 10 | 3 | 8 | 28856 | 29 | ||
| 36037 | 221598 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3835 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004922.63411 | 2100744.76364 | 37.7485235676072 | -122.42575673258 | (37.7485235676072, -122.42575673258) | 2 | 4 | 5 | 63 | 22 | |||
| 36079 | 32938 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1530 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 6 | Permit Number 37258 | 6013021.62102 | 2105688.27422 | 37.7625517136065 | -122.398097141493 | (37.7625517136065, -122.398097141493) | 14 | 3 | 8 | 28856 | 29 | |
| 36452 | 221606 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 879 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009142.75703 | 2104069.9032 | 37.757891228003 | -122.411398436495 | (37.757891228003, -122.411398436495) | 2 | 4 | 7 | 28859 | 19 | |||
| 37548 | 221581 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1801 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009543.08005 | 2105995.80404 | 37.7632017597825 | -122.410149913112 | (37.7632017597825, -122.410149913112) | 8 | 4 | 8 | 28859 | 19 | |||
| 38109 | 221637 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 4055 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002643.00734 | 2104710.17858 | 37.759282569163 | -122.433923039915 | (37.759282569163, -122.433923039915) | 2 | 4 | 5 | 28862 | 3 | |||
| 38384 | 221588 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1298 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010295.88664 | 2101729.17377 | 37.751528715192 | -122.407245408661 | (37.751528715192, -122.407245408661) | 2 | 4 | 7 | 28859 | 19 | |||
| 38932 | 57960 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 340 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 1 | Permit Number 772773 | 5999451.90276 | 2086477.9387 | 37.7090395229363 | -122.443649609852 | (37.7090395229363, -122.443649609852) | 9 | 7 | 6 | 28861 | 5 | ||
| 39799 | 221617 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 800 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008123.88983 | 2097149.51218 | 37.7388321854502 | -122.414432447809 | (37.7388321854502, -122.414432447809) | 2 | 7 | 7 | 28859 | 2 | |||
| 40130 | 1162 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2849X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5997216.55451 | 2087707.32344 | 37.7122873858304 | -122.451463876663 | (37.7122873858304, -122.451463876663) | 9 | 7 | 6 | 28861 | 25 | ||
| 40423 | 221641 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 296 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004397.62951 | 2103975.64883 | 37.7573651408118 | -122.427802367408 | (37.7573651408118, -122.427802367408) | 2 | 4 | 5 | 28862 | 3 | |||
| 40913 | 95819 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 266 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767557 | 6009737.75412 | 2108910.90925 | 37.7712168784866 | -122.409682366366 | (37.7712168784866, -122.409682366366) | 8 | 2 | 9 | 28853 | 34 |
| 41612 | 150666 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 555 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781212 | 6011817.65557 | 2105788.11066 | 37.7627587105623 | -122.402268264562 | (37.7627587105623, -122.402268264562) | 8 | 3 | 8 | 28856 | 29 |
| 43027 | 221627 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 3348 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006051.64751 | 2103193.30025 | 37.7553104210429 | -122.422026534497 | (37.7553104210429, -122.422026534497) | 2 | 4 | 5 | 28859 | 19 | |||
| 43101 | 200960 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1527 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008413.1986 | 2109048.8424 | 37.7715212967515 | -122.414273832498 | (37.7715212967515, -122.414273832498) | 8 | 2 | 9 | 28853 | 19 | |||
| 43458 | 140825 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 500 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5996795.1609 | 2113868.6412 | 37.784095740758 | -122.454809318923 | (37.784095740758, -122.454809318923) | 11 | 6 | 1 | 54 | 31 | |||
| 44443 | 85683 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 660 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3 | 3x3 | 6012787.21783 | 2111572.91246 | 37.7786965462587 | -122.399320984791 | (37.7786965462587, -122.399320984791) | 6 | 2 | 9 | 28856 | 34 | ||
| 44546 | 221589 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1298 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010298.25709 | 2101707.85409 | 37.7514703087269 | -122.407235708582 | (37.7514703087269, -122.407235708582) | 2 | 4 | 7 | 28859 | 19 | |||
| 45621 | 221605 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 126 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007327.7514 | 2096972.1243 | 37.7383003605723 | -122.417172563378 | (37.7383003605723, -122.417172563378) | 2 | 7 | 7 | 28859 | 2 | |||
| 46059 | 187800 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2 Heron St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.408893164515 | (37.7742615809293, -122.408893164515) | 8 | 2 | 9 | 28853 | 34 | |||
| 46372 | 24550 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 322 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2003 12:00:00 AM | 12 | 3X3 | 6007090.05329 | 2097287.38684 | 37.739152626479 | -122.418016751571 | (37.739152626479, -122.418016751571) | 2 | 7 | 7 | 28859 | 2 | ||
| 46381 | 221649 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 2012 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004056.31613 | 2107188.28381 | 37.7661669549612 | -122.429211835283 | (37.7661669549612, -122.429211835283) | 8 | 4 | 5 | 28862 | 3 | |||
| 46794 | 125330 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 1335 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007763.34926 | 2117482.29154 | 37.7946409829411 | -122.417119380172 | (37.7946409829411, -122.417119380172) | 5 | 1 | 10 | 28858 | 32 |
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) );