Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2436 | 2436 | 110026 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2585 Pacific Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 779691 | 6001774.18039 | 2116969.68651 | 37.7928947585324 | -122.437805917729 | (37.7928947585324, -122.437805917729) | ||
| 3274 | 3274 | 253391 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2529x Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 5718 | 5718 | 62586 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2757 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2016 12:00:00 AM | 3 | Permit Number 22892 | 6000581.95195 | 2117804.95213 | 37.7951203134931 | -122.441991055868 | (37.7951203134931, -122.441991055868) | ||
| 12683 | 12683 | 96638 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 586 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767750 | 6001774.80022 | 2090099.6098 | 37.7191160424439 | -122.435880307331 | (37.7191160424439, -122.435880307331) | |
| 12893 | 12893 | 115758 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 1718 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998112.52061 | 2088720.1646599998 | 37.7151196818909 | -122.448440058269 | (37.7151196818909, -122.448440058269) | ||
| 14229 | 14229 | 120498 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50X Ecker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013051.9085099995 | 2115477.96446 | 37.789433663691604 | -122.398679426422 | (37.7894336636916, -122.398679426422) | |
| 14589 | 14589 | 120502 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50X Ecker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013100.31596 | 2115425.9297599997 | 37.7892934854631 | -122.39850828814801 | (37.7892934854631, -122.398508288148) | |
| 15476 | 15476 | 110656 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 500 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012024.49835 | 2106000.36066 | 37.7633530455212 | -122.40156778264 | (37.7633530455212, -122.40156778264) | |
| 15980 | 15980 | 120500 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50X Ecker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013077.52006 | 2115450.9456 | 37.7893609031295 | -122.39858891595101 | (37.7893609031295, -122.398588915951) | |
| 16683 | 16683 | 120499 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50X Ecker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013067.81097 | 2115461.47291 | 37.789389267741704 | -122.39862324755899 | (37.7893892677417, -122.398623247559) | |
| 16822 | 16822 | 120501 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50X Ecker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778820 | 6013088.10367 | 2115439.05309 | 37.7893288387076 | -122.398551462773 | (37.7893288387076, -122.398551462773) | |
| 16921 | 16921 | 9377 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 316 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6001083.963690001 | 2097786.509 | 37.7401832324575 | -122.438818805251 | (37.7401832324575, -122.438818805251) | |||
| 19350 | 19350 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 2721 Pacific Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | |||||
| 19781 | 19781 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 175 | 185 Chilton Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251004 | -122.436889661497 | (37.732941575251, -122.436889661497) | ||||
| 19797 | 19797 | 97906 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 401 Upper Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 60 | Permit Number 768366 | 5999222.6 | 2106240.8 | 37.7632905770055 | -122.44586250428002 | (37.7632905770055, -122.44586250428) | ||
| 22819 | 22819 | 220400 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 30 Harry St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6003253.97405 | 2097694.59557 | 37.7400540781348 | -122.431309231431 | (37.7400540781348, -122.431309231431) | |||
| 22849 | 22849 | 220359 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1020 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009158.25384 | 2103078.96288 | 37.7551711988011 | -122.411274840882 | (37.7551711988011, -122.411274840882) | |||
| 23020 | 23020 | 25164 | DPW Maintained 3 | Acer palmatum :: Japanese Maple 175 | 2710 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6001235.48665 | 2105625.73968 | 37.7617165006498 | -122.438856528211 | (37.7617165006498, -122.438856528211) | |||
| 23248 | 23248 | 23683 | DPW Maintained 3 | Acer palmatum :: Japanese Maple 175 | 326 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6006861.8180599995 | 2098078.15995 | 37.741311065058106 | -122.41886195603 | (37.7413110650581, -122.41886195603) | |||
| 23571 | 23571 | 221683 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 494 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002795.69919 | 2098622.36478 | 37.7425755352375 | -122.432960022487 | (37.7425755352375, -122.432960022487) | |||
| 24400 | 24400 | 220351 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3921 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6002309.75741 | 2103525.9195 | 37.7560119615059 | -122.434990881437 | (37.7560119615059, -122.434990881437) | ||||
| 24551 | 24551 | 203377 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 419 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999282.97385 | 2094938.01087 | 37.7322593032094 | -122.44484117288401 | (37.7322593032094, -122.444841172884) | |||
| 24571 | 24571 | 220396 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 18 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003652.84121 | 2098131.69729 | 37.7412768557411 | -122.42996128440399 | (37.7412768557411, -122.429961284404) | |||
| 25523 | 25523 | 140930 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 118 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5996567.4031 | 2113640.2065 | 37.7834554526548 | -122.455580757548 | (37.7834554526548, -122.455580757548) | |||
| 26277 | 26277 | 69804 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 510 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | 3 | 6010631.84232 | 2105884.1713400004 | 37.7629562079975 | -122.406376362283 | (37.7629562079975, -122.406376362283) | ||
| 26320 | 26320 | 203345 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 151 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5993722.25572 | 2088208.62859 | 37.7134631342904 | -122.463577482032 | (37.7134631342904, -122.463577482032) | |||
| 27280 | 27280 | 221685 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 191 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004729.5735599995 | 2098686.96035 | 37.742862400990894 | -122.42627784565201 | (37.7428624009909, -122.426277845652) | |||
| 27409 | 27409 | 125370 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 15 Marion Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008341.36598 | 2119390.6131 | 37.799913260246896 | -122.41525451361 | (37.7999132602469, -122.41525451361) | ||||
| 27528 | 27528 | 187839 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2 Anthony St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6012618.54939 | 2115295.68448 | 37.7889090117828 | -122.400166003066 | (37.7889090117828, -122.400166003066) | |||
| 28074 | 28074 | 203347 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1403 Willard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5996798.38669 | 2106558.1050299997 | 37.7640230971055 | -122.454269934113 | (37.7640230971055, -122.454269934113) | |||
| 28501 | 28501 | 203342 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 489 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992457.25612 | 2091158.94036 | 37.7214910053888 | -122.46816421601801 | (37.7214910053888, -122.468164216018) | |||
| 29004 | 29004 | 220326 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 708 27th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6001877.33275 | 2100040.15325 | 37.7464163157589 | -122.436236900239 | (37.7464163157589, -122.436236900239) | |||
| 29055 | 29055 | 175104 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 654 Brotherhood Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5990430.75916 | 2088484.92855 | 37.71403158315321 | -122.47497409569799 | (37.7140315831532, -122.474974095698) | |||
| 29559 | 29559 | 203348 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1774 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993141.66536 | 2103395.17123 | 37.7551281302828 | -122.466687420382 | (37.7551281302828, -122.466687420382) | |||
| 29592 | 29592 | 249968 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 213 Filbert St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011722.66122 | 2120088.35569 | 37.8020185425825 | -122.403603012281 | (37.8020185425825, -122.403603012281) | |||
| 29639 | 29639 | 220335 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 523 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6002527.73455 | 2098555.81183 | 37.7423775935402 | -122.433881808696 | (37.7423775935402, -122.433881808696) | |||
| 29772 | 29772 | 94042 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 641 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53452 | 6001625.67321 | 2089781.77052 | 37.7182348543375 | -122.43637304587601 | (37.7182348543375, -122.436373045876) | |
| 29828 | 29828 | 203328 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1908 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5993483.36488 | 2102452.02098 | 37.7525581961203 | -122.465437223346 | (37.7525581961203, -122.465437223346) | |||
| 29881 | 29881 | 125351 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 290 Maple St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996665.39445 | 2115417.5354299997 | 37.788341146579704 | -122.455370240255 | (37.7883411465797, -122.455370240255) | |||
| 30209 | 30209 | 246433 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 498 Duncan St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 6ft | 6003355.2698800005 | 2099829.27053 | 37.745921141839105 | -122.43111131584801 | (37.7459211418391, -122.431111315848) | |||
| 30282 | 30282 | 187829 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 500 De Haro St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6012022.35521 | 2105982.64886 | 37.7633042932852 | -122.401573950187 | (37.7633042932852, -122.401573950187) | ||||
| 30350 | 30350 | 221668 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 112 27th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 8ft | 6005711.74645 | 2100245.8851900003 | 37.747198322139 | -122.422992538592 | (37.747198322139, -122.422992538592) | |||
| 30432 | 30432 | 125354 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3733 Broderick St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5999600.77298 | 2121346.59164 | 37.804788745862005 | -122.445640883317 | (37.804788745862, -122.445640883317) | |||
| 30657 | 30657 | 220393 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 20 Deming St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 5999466.4358 | 2105239.81948 | 37.7605560532329 | -122.44494719845801 | (37.7605560532329, -122.444947198458) | |||
| 30764 | 30764 | 221687 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1409 Sanchez St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6003959.02865 | 2100024.6104 | 37.7464916942553 | -122.42903752597401 | (37.7464916942553, -122.429037525974) | |||
| 31103 | 31103 | 187837 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2 Apparel Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6011250.95199 | 2097877.3774099997 | 37.7410059214738 | -122.40367166743299 | (37.7410059214738, -122.403671667433) | |||
| 31443 | 31443 | 94570 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 376 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53748 | 5986249.73354 | 2113372.20578 | 37.7821221276999 | -122.491255642952 | (37.7821221276999, -122.491255642952) | |
| 31644 | 31644 | 175100 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 499 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012716.4697199995 | 2086677.83624 | 37.710336021550205 | -122.397819010859 | (37.7103360215502, -122.397819010859) | |||
| 31699 | 31699 | 203375 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 35 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999856.56094 | 2095472.8788599998 | 37.7337606431433 | -122.442896553556 | (37.7337606431433, -122.442896553556) | |||
| 31981 | 31981 | 220347 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3931 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002257.17808 | 2103516.9428 | 37.755984328036796 | -122.43517207594499 | (37.7559843280368, -122.435172075945) | ||||
| 32080 | 32080 | 220391 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 40 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000824.36541 | 2106111.55145 | 37.763027021510794 | -122.44031326895201 | (37.7630270215108, -122.440313268952) | |||
| 32126 | 32126 | 175101 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 499 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012687.11436 | 2086687.8411400001 | 37.71036185819221 | -122.39792117113501 | (37.7103618581922, -122.397921171135) | |||
| 32157 | 32157 | 220385 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4749 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5999705.07561 | 2104966.76379 | 37.7598199266724 | -122.444102234143 | (37.7598199266724, -122.444102234143) | |||
| 32159 | 32159 | 175108 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 654 Brotherhood Way | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5990046.17827 | 2088685.5531 | 37.7145601533898 | -122.476317985012 | (37.7145601533898, -122.476317985012) | |||
| 32308 | 32308 | 203354 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 20 Mendosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993465.8714 | 2101175.72597 | 37.74905280784029 | -122.46540501325501 | (37.7490528078403, -122.465405013255) | |||
| 32401 | 32401 | 220372 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 310 Liberty St | 59 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003720.16644 | 2103926.0681 | 37.7571906570269 | -122.43014176485501 | (37.7571906570269, -122.430141764855) | |||
| 32538 | 32538 | 221670 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 985 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6011091.323 | 2103767.31713 | 37.7571694924002 | -122.40463814095699 | (37.7571694924002, -122.404638140957) | |||
| 33352 | 33352 | 203352 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 50 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5991879.77556 | 2095665.97475 | 37.733832833509396 | -122.470488472467 | (37.7338328335094, -122.470488472467) | |||
| 33577 | 33577 | 220370 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 354 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001120.64337 | 2104298.9926400003 | 37.7580670427826 | -122.439158629368 | (37.7580670427826, -122.439158629368) | |||
| 33586 | 33586 | 187855 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1670 Owen St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013880.1945 | 2107455.37205 | 37.7674515582618 | -122.395251416746 | (37.7674515582618, -122.395251416746) | |||
| 34039 | 34039 | 117695 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4049 Clement St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5982932.793930001 | 2113075.09741 | 37.7811119859752 | -122.50270856543999 | (37.7811119859752, -122.50270856544) | |||
| 34062 | 34062 | 125360 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1665 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002803.7386 | 2120926.10172 | 37.8038165346806 | -122.434526617225 | (37.8038165346806, -122.434526617225) | |||
| 34157 | 34157 | 220325 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 737 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6001752.60876 | 2099682.61141 | 37.745427503077394 | -122.43664259248999 | (37.7454275030774, -122.43664259249) | |||
| 34282 | 34282 | 220366 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4639 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000471.63845 | 2104630.9985 | 37.758941698227 | -122.44142698308599 | (37.758941698227, -122.441426983086) | |||
| 34297 | 34297 | 220329 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4489 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 8ft | 6000090.03644 | 2101642.36493 | 37.7507138925428 | -122.44253216264099 | (37.7507138925428, -122.442532162641) | |||
| 34869 | 34869 | 220361 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3378 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007031.22663 | 2105582.9717 | 37.7619271056612 | -122.418808316877 | (37.7619271056612, -122.418808316877) | |||
| 34891 | 34891 | 203349 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1774 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993139.91773 | 2103410.94201 | 37.7551713319069 | -122.46669461046301 | (37.7551713319069, -122.466694610463) | |||
| 34979 | 34979 | 125394 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 601 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007295.97012 | 2121904.70723 | 37.806757518306206 | -122.419050406278 | (37.8067575183062, -122.419050406278) | |||
| 34997 | 34997 | 220395 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 334 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003664.8638 | 2108679.3999400004 | 37.7702390294466 | -122.430672206559 | (37.7702390294466, -122.430672206559) | |||
| 35403 | 35403 | 125386 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 943 Vallejo St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6008816.3361599995 | 2118653.07682 | 37.797914850658 | -122.413558740271 | (37.797914850658, -122.413558740271) | ||||
| 35527 | 35527 | 125364 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2683 Green St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000248.1233 | 2117795.83922 | 37.7950762629051 | -122.443145495791 | (37.7950762629051, -122.443145495791) | |||
| 35625 | 35625 | 175115 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 239 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002524.33543 | 2094177.44963 | 37.7303554249536 | -122.433580726478 | (37.7303554249536, -122.433580726478) | |||
| 35766 | 35766 | 220345 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 480 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001157.56269 | 2103469.0671200003 | 37.7557903694526 | -122.438971470555 | (37.7557903694526, -122.438971470555) | |||
| 35854 | 35854 | 125374 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1051 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6006272.5886 | 2120715.97126 | 37.8034358723358 | -122.422507500937 | (37.8034358723358, -122.422507500937) | |||
| 36068 | 36068 | 220394 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 381 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003854.16452 | 2109001.0038900003 | 37.771132798178 | -122.43004036179701 | (37.771132798178, -122.430040361797) | |||
| 36307 | 36307 | 203365 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 154 Miraloma Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994560.19343 | 2096691.9953599998 | 37.7368046558011 | -122.461295881299 | (37.7368046558011, -122.461295881299) | |||
| 36824 | 36824 | 125350 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 245 Alhambra St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6001134.84353 | 2120029.52135 | 37.801259885300205 | -122.440237577501 | (37.8012598853002, -122.440237577501) | |||
| 37236 | 37236 | 125366 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2675 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000289.81548 | 2117800.51566 | 37.795091480336204 | -122.443001570984 | (37.7950914803362, -122.443001570984) | |||
| 37706 | 37706 | 220382 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 540 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002775.85956 | 2103885.79628 | 37.7570265514437 | -122.43340466261999 | (37.7570265514437, -122.43340466262) | |||
| 38012 | 38012 | 221681 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1495 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004584.243319999 | 2100224.42026 | 37.7470756968823 | -122.426889829827 | (37.7470756968823, -122.426889829827) | |||
| 38152 | 38152 | 220381 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 530 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002863.960419999 | 2103890.4674 | 37.757044375110794 | -122.433100310431 | (37.7570443751108, -122.433100310431) | |||
| 38722 | 38722 | 203364 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 300 Cresta Vista Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5996883.0198800005 | 2096183.0000599998 | 37.7355404877898 | -122.453228160376 | (37.7355404877898, -122.453228160376) | |||
| 38796 | 38796 | 220348 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3931 21st St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002260.23374 | 2103523.23567 | 37.756001780264796 | -122.43516195855301 | (37.7560017802648, -122.435161958553) | ||||
| 38866 | 38866 | 203315 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1335 14th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5991744.93275 | 2106323.82139 | 37.7630887266775 | -122.471731099918 | (37.7630887266775, -122.471731099918) | |||
| 39088 | 39088 | 187824 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 654 Minnesota St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 6015152.23772 | 2105353.21099 | 37.7617501424761 | -122.390704635107 | (37.7617501424761, -122.390704635107) | |||
| 39660 | 39660 | 250216 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 308 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011344.36464 | 2120071.55622 | 37.8019512768773 | -122.40491092150299 | (37.8019512768773, -122.404910921503) | |||
| 40663 | 40663 | 187823 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 654 Minnesota St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6015142.96332 | 2105500.9712 | 37.7621553455266 | -122.390747038169 | (37.7621553455266, -122.390747038169) | |||
| 40686 | 40686 | 203321 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 145 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992706.31414 | 2098229.45962 | 37.7409192763152 | -122.46781728816002 | (37.7409192763152, -122.46781728816) | |||
| 41277 | 41277 | 220344 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 12 Worth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6000853.3695 | 2103209.2326 | 37.7550596145267 | -122.44000483566799 | (37.7550596145267, -122.440004835668) | |||
| 41365 | 41365 | 34886 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 1539 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1997 12:00:00 AM | 8 | Permit Number 38493 | 6002861.6845 | 2121291.37793 | 37.8048227762149 | -122.43435222339 | (37.8048227762149, -122.43435222339) | ||
| 41555 | 41555 | 187821 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1100 26th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 7ft | 6015077.55547 | 2101606.9889599998 | 37.751459673338 | -122.39070113134599 | (37.751459673338, -122.390701131346) | |||
| 41650 | 41650 | 203314 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1443 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5991130.13429 | 2105570.21415 | 37.760983931785795 | -122.47380247780701 | (37.7609839317858, -122.473802477807) | |||
| 41766 | 41766 | 249842 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1470 Montgomery St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 6011409.7751 | 2120350.84076 | 37.8027217800346 | -122.40470424202 | (37.8027217800346, -122.40470424202) | |||
| 42154 | 42154 | 125359 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 799 Marina Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 5999223.07428 | 2121455.46284 | 37.805066105780604 | -122.446955783002 | (37.8050661057806, -122.446955783002) | |||
| 42764 | 42764 | 125355 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2298 Beach St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5999283.7410699995 | 2120846.75644 | 37.803398228510495 | -122.446702014982 | (37.8033982285105, -122.446702014982) | |||
| 43326 | 43326 | 96163 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 195 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767795 | 6009794.5 | 2099949.7 | 37.7466145997749 | -122.40885373955601 | (37.7466145997749, -122.408853739556) | |
| 43967 | 43967 | 221664 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 65 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6006280.59621 | 2109108.9089099998 | 37.771566201261294 | -122.421654898657 | (37.7715662012613, -122.421654898657) | |||
| 44008 | 44008 | 203323 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 145 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992709.91789 | 2098242.86933 | 37.7409563040799 | -122.467805802899 | (37.7409563040799, -122.467805802899) | |||
| 44464 | 44464 | 125390 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1048 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6007884.3838 | 2119276.0110299997 | 37.7995728983285 | -122.41682772463699 | (37.7995728983285, -122.416827724637) | |||
| 44549 | 44549 | 31014 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 1200 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 1 | Permit Number 43760 | 6001111.961519999 | 2087453.8563599999 | 37.7118137183117 | -122.437982070624 | (37.7118137183117, -122.437982070624) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");