Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106963 | 106963 | 27248 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100X CORTLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2000 12:00:00 AM | 4 | 3X3 | 6006272.0 | 2097672.0 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | ||
| 20141 | 20141 | 27518 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 4 | 3x3 | 6005759.73558 | 2101716.47325 | 37.751238927544605 | -122.422931097816 | (37.7512389275446, -122.422931097816) | ||
| 37962 | 37962 | 31466 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 512 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35032 | 6002998.75397 | 2102141.19875 | 37.7522489444334 | -122.432509202251 | (37.7522489444334, -122.432509202251) | ||
| 164850 | 164850 | 31788 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35258 | 6001692.80487 | 2107894.1622099997 | 37.7679710399513 | -122.437437296395 | (37.7679710399513, -122.437437296395) | |
| 105993 | 105993 | 32849 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 716 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50467 | 6001761.70945494 | 2102078.76287853 | 37.7520072832286 | -122.43678262007 | (37.7520072832286, -122.43678262007) | |
| 75422 | 75422 | 44344 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 231 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | 4 | Permit Number 43727 | 5991166.721059999 | 2113847.95037 | 37.78371446666 | -122.474279986791 | (37.78371446666, -122.474279986791) | ||
| 156197 | 156197 | 45478 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3008 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44261 | 5990292.274259999 | 2095193.2885900002 | 37.732443037405 | -122.475942374151 | (37.732443037405, -122.475942374151) | |
| 165469 | 165469 | 45480 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3014 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 4 | Permit Number 44262 | 5990294.42195 | 2095159.6612900002 | 37.732350829908704 | -122.47593249418699 | (37.7323508299087, -122.475932494187) | |
| 73876 | 73876 | 45510 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2929 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 4 | Permit Number 44276 | 5988794.07528 | 2095754.20535 | 37.7338961880477 | -122.481162998885 | (37.7338961880477, -122.481162998885) | |
| 162176 | 162176 | 45547 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990293.1703699995 | 2095939.4617299999 | 37.734491890875795 | -122.47599375241501 | (37.7344918908758, -122.475993752415) | ||
| 167820 | 167820 | 45548 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990306.88184 | 2095939.17218 | 37.734491890873606 | -122.475946326684 | (37.7344918908736, -122.475946326684) | ||
| 186414 | 186414 | 45549 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990323.96119 | 2095935.96592 | 37.7344840775814 | -122.47588704426201 | (37.7344840775814, -122.475887044262) | ||
| 186409 | 186409 | 45569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44312 | 5997642.12042 | 2115315.11009 | 37.7881159077753 | -122.451983551718 | (37.7881159077753, -122.451983551718) | |
| 34126 | 34126 | 45776 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | 4 | Permit Number 44418 | 5991347.84343 | 2110102.5113 | 37.7734410095192 | -122.47338010572399 | (37.7734410095192, -122.473380105724) | ||
| 59082 | 59082 | 46513 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2563 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 4 | Permit Number 44679 | 6002506.83642 | 2116089.37205 | 37.790519274906 | -122.435207900427 | (37.790519274906, -122.435207900427) | ||
| 33711 | 33711 | 49142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 4 | Permit Number 46265 | 5985047.031690001 | 2112314.4789400003 | 37.7791475672211 | -122.495338355641 | (37.7791475672211, -122.495338355641) | ||
| 57869 | 57869 | 49452 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1483 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | Permit Number 46386 | 6011771.85534 | 2101466.1696900004 | 37.7508890570981 | -122.402122808245 | (37.7508890570981, -122.402122808245) | |
| 73334 | 73334 | 49515 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2360@ FILLMORE Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46421 | 6002343.25635 | 2117445.35992 | 37.794233177280205 | -122.435870940009 | (37.7942331772802, -122.435870940009) | ||
| 56762 | 56762 | 49698 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50825 | 6011117.29096 | 2088288.9421 | 37.7146706063491 | -122.403459407649 | (37.7146706063491, -122.403459407649) | |
| 174698 | 174698 | 49745 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34@ LELAND Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46544 | 6008556.3350599995 | 2087877.23988 | 37.7133967814171 | -122.41228206988899 | (37.7133967814171, -122.412282069889) | |
| 43236 | 43236 | 50295 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3052 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 4 | Permit Number 47008 | 5990301.1325 | 2094963.1495599998 | 37.7318116476733 | -122.47589494839501 | (37.7318116476733, -122.475894948395) | |
| 172983 | 172983 | 50299 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 4 | Permit Number 47010 | 5989048.57412 | 2095810.2761099997 | 37.7340649359436 | -122.480287231884 | (37.7340649359436, -122.480287231884) | |
| 30826 | 30826 | 51284 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2205 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2004 12:00:00 AM | 4 | Permit Number 47656 | 6000322.72568 | 2116238.1776 | 37.7908035865572 | -122.442775457127 | (37.7908035865572, -122.442775457127) | ||
| 47842 | 47842 | 52649 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46@ LAKE 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2006 12:00:00 AM | 4 | Permit Number 48733 | 5993970.1832 | 2115226.91418 | 37.787662738807605 | -122.46468131190001 | (37.7876627388076, -122.4646813119) | ||
| 41715 | 41715 | 52943 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 428 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 4 | Permit Number 48930 | 6000112.39427 | 2091327.92801 | 37.722394148651 | -122.44171469507299 | (37.722394148651, -122.441714695073) | |
| 69423 | 69423 | 57395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.41643141230499 | (37.7941539658926, -122.416431412305) | ||
| 33377 | 33377 | 59100 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 574 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 4 | Permit Number 53750 | 5993480.53201 | 2111592.2596 | 37.777654724152896 | -122.46611116933201 | (37.7776547241529, -122.466111169332) | ||
| 74037 | 74037 | 62580 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50012 | 6011310.429380001 | 2104760.0499299997 | 37.759907559306505 | -122.403950240515 | (37.7599075593065, -122.403950240515) | |
| 188053 | 188053 | 66364 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1991 12:00:00 AM | 4 | Permit Number 29965 | 5991908.34552 | 2112195.95462 | 37.7792214762424 | -122.471593848027 | (37.7792214762424, -122.471593848027) | ||
| 55825 | 55825 | 67395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 4 | Permit Number 30892 | 5990662.93226 | 2110247.15301 | 37.7737984716316 | -122.47575985163 | (37.7737984716316, -122.47575985163) | |
| 175301 | 175301 | 67942 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 4 | Permit Number 31656 | 5989115.53927 | 2111342.9098799997 | 37.776717282669296 | -122.48119272322701 | (37.7767172826693, -122.481192723227) | |
| 32051 | 32051 | 68219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 263 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 4 | Permit Number 32006 | 5990848.54158 | 2113649.76494 | 37.7831518664143 | -122.475366281729 | (37.7831518664143, -122.475366281729) | |
| 166176 | 166176 | 68393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 248 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 4 | Permit Number 32221 | 6001588.48331 | 2093972.4225299999 | 37.729739323692705 | -122.436801419974 | (37.7297393236927, -122.436801419974) | |
| 148211 | 148211 | 68564 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 4 | Permit Number 32454 | 5981914.34705 | 2111854.14558 | 37.7776997090602 | -122.506141264398 | (37.7776997090602, -122.506141264398) | |
| 39453 | 39453 | 68949 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.48205650095699 | (37.7739652106004, -122.482056500957) | |
| 72980 | 72980 | 69395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.711058190666705 | -122.43466196070801 | (37.7110581906667, -122.434661960708) | |
| 60368 | 60368 | 69413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33518 | 6001961.1999 | 2087395.4649599998 | 37.711701646594 | -122.43504269857 | (37.711701646594, -122.43504269857) | |
| 72057 | 72057 | 70279 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Arago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1994 12:00:00 AM | 4 | 5999591.10411 | 2092976.06015 | 37.726889823596295 | -122.443635008456 | (37.7268898235963, -122.443635008456) | ||
| 154108 | 154108 | 70417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6007053.10759 | 2093048.1738200001 | 37.7275105968359 | -122.417844078137 | (37.7275105968359, -122.417844078137) | ||
| 155814 | 155814 | 78132 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 Dartmouth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 4 | 6009313.83221 | 2090783.0166900002 | 37.7214179201914 | -122.409868876754 | (37.7214179201914, -122.409868876754) | ||
| 158154 | 158154 | 79061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6012156.574130001 | 2103666.55961 | 37.756952313327396 | -122.40094698961599 | (37.7569523133274, -122.400946989616) | ||
| 165384 | 165384 | 79359 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 567 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2004 12:00:00 AM | 4 | 5985009.753819999 | 2112015.61326 | 37.778324785429895 | -122.495445265062 | (37.7783247854299, -122.495445265062) | ||
| 43768 | 43768 | 81737 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49969 | 5983468.0529 | 2111801.95258 | 37.7776477425111 | -122.500762690576 | (37.7776477425111, -122.500762690576) | |
| 162648 | 162648 | 82704 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | 6012930.127090001 | 2089200.7150299998 | 37.7172752435332 | -122.39725735994301 | (37.7172752435332, -122.397257359943) | ||
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 67099 | 67099 | 83292 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1722 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52353 | 6014576.18583 | 2096214.42431 | 37.7366249865567 | -122.39205786839199 | (37.7366249865567, -122.392057868392) | |
| 94236 | 94236 | 83699 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769773 | 6002629.0 | 2105596.0 | 37.76171402608121 | -122.434034805509 | (37.7617140260812, -122.434034805509) |
| 173911 | 173911 | 84352 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51575 | 5994138.19056 | 2110541.38294 | 37.7748072179408 | -122.463759829065 | (37.7748072179408, -122.463759829065) | |
| 20662 | 20662 | 84576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.43113617160401 | (37.7515533971776, -122.431136171604) |
| 100725 | 100725 | 84674 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6002887.32453677 | 2101799.94982156 | 37.7513056360956 | -122.432870165781 | (37.7513056360956, -122.432870165781) |
| 12196 | 12196 | 86961 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49929 | 5993495.99209 | 2087406.2303400002 | 37.7112468999028 | -122.464301303157 | (37.7112468999028, -122.464301303157) | |
| 72144 | 72144 | 87155 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50137 | 5992081.9043 | 2114697.2023099996 | 37.7860992546106 | -122.471175721775 | (37.7860992546106, -122.471175721775) | |
| 50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 29713 | 29713 | 88413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.792774588415796 | -122.411270553799 | (37.7927745884158, -122.411270553799) | |
| 187959 | 187959 | 88452 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | ||
| 57130 | 57130 | 92234 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 530 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52677 | 5982879.44866 | 2112163.93194 | 37.778607057674996 | -122.50282564106199 | (37.778607057675, -122.502825641062) |
| 130339 | 130339 | 92531 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298X Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6011695.143180001 | 2102366.06354 | 37.75335568701529 | -122.40245135756201 | (37.7533556870153, -122.402451357562) | ||||
| 65194 | 65194 | 94744 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53879 | 6004279.92071 | 2118358.49437 | 37.7968502341069 | -122.42923500719401 | (37.7968502341069, -122.429235007194) | |
| 185419 | 185419 | 96033 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767672 | 6008167.44383 | 2115805.7111 | 37.790060229456294 | -122.41560239383301 | (37.7900602294563, -122.415602393833) |
| 66520 | 66520 | 100031 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | |
| 96865 | 96865 | 101319 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2-4 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x5 | 6003417.0 | 2108348.0 | 37.7693150407363 | -122.43150590351101 | (37.7693150407363, -122.431505903511) | |||
| 143029 | 143029 | 102171 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 97285 | 97285 | 102172 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621.0 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) |
| 52069 | 52069 | 104072 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3020 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770362 | 6003851.5174 | 2119222.18029 | 37.7991974313859 | -122.430779048741 | (37.7991974313859, -122.430779048741) | |
| 82021 | 82021 | 104249 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 97257 | 97257 | 104250 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 123262 | 123262 | 104251 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 108756 | 108756 | 104252 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 143027 | 143027 | 104253 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 140726 | 140726 | 104254 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 73055 | 73055 | 106983 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1737-1795 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2012 12:00:00 AM | 4 | 6003734.5 | 2114103.2 | 37.785135386369795 | -122.43081845921101 | (37.7851353863698, -122.430818459211) | |||
| 136184 | 136184 | 114855 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1416x Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006703.84741 | 2115349.3843 | 37.7887248899861 | -122.42063391904499 | (37.7887248899861, -122.420633919045) | |||
| 97076 | 97076 | 116721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1766 25TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5988485.0 | 2103297.0 | 37.7545887414361 | -122.48278413706899 | (37.7545887414361, -122.482784137069) | |||
| 130514 | 130514 | 117789 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3921 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5983401.92135 | 2111008.87073 | 37.7754662872697 | -122.500932791041 | (37.7754662872697, -122.500932791041) | |||
| 59474 | 59474 | 119000 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 623 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982547.10807 | 2111503.78055 | 37.776774937935 | -122.503926407866 | (37.776774937935, -122.503926407866) | |||
| 57185 | 57185 | 119537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 871 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5986635.90405 | 2110003.72423 | 37.772895790248 | -122.489671893334 | (37.772895790248, -122.489671893334) | |||
| 153617 | 153617 | 119948 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5986856.974330001 | 2113783.1375700003 | 37.7832858916453 | -122.489185114233 | (37.7832858916453, -122.489185114233) | |||
| 133965 | 133965 | 120705 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 21st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989295.69695 | 2115021.44108 | 37.78682797013 | -122.480838891203 | (37.78682797013, -122.480838891203) | |||
| 187197 | 187197 | 120727 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989397.82148 | 2112121.21454 | 37.7788706974235 | -122.48027321576001 | (37.7788706974235, -122.48027321576) | |||
| 170485 | 170485 | 120737 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 734 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989462.460519999 | 2110322.27124 | 37.773935053699 | -122.4799179267 | (37.773935053699, -122.4799179267) | |||
| 77124 | 77124 | 123052 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 544 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5991924.81576 | 2111692.51922 | 37.7778401329349 | -122.471500177083 | (37.7778401329349, -122.471500177083) | |||
| 77264 | 77264 | 123069 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 682 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992267.096480001 | 2110837.88272 | 37.7755133283989 | -122.470253867932 | (37.7755133283989, -122.470253867932) | |||
| 23875 | 23875 | 123972 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993617.67519 | 2115041.45387 | 37.78713318686079 | -122.46588743043002 | (37.7871331868608, -122.46588743043) | |||
| 130256 | 130256 | 124471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2436 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996060.098569999 | 2110399.87831 | 37.774529244064205 | -122.45710135447399 | (37.7745292440642, -122.457101354474) | |||
| 159006 | 159006 | 124472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2474 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995885.81707 | 2110375.20896 | 37.7744514982012 | -122.457702438809 | (37.7744514982012, -122.457702438809) | |||
| 163902 | 163902 | 135915 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2909 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004293.78648 | 2119207.639 | 37.7991825520948 | -122.429247608494 | (37.7991825520948, -122.429247608494) | |||
| 65782 | 65782 | 135925 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2725 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999832.2761699995 | 2118786.40209 | 37.797772365663796 | -122.444655616678 | (37.7977723656638, -122.444655616678) | |||
| 149637 | 149637 | 135931 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1361 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004797.09073 | 2120517.98623 | 37.8028089081649 | -122.42759940931002 | (37.8028089081649, -122.42759940931) | |||
| 59687 | 59687 | 135938 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998466.03707 | 2116398.7314400002 | 37.791138403269294 | -122.44921105427 | (37.7911384032693, -122.44921105427) | |||
| 33059 | 33059 | 135939 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998471.02227 | 2116380.3328400003 | 37.7910881707365 | -122.44919247964701 | (37.7910881707365, -122.449192479647) | |||
| 41729 | 41729 | 135951 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3566 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997226.42135 | 2116056.02078 | 37.790126431251394 | -122.453475306653 | (37.7901264312514, -122.453475306653) | |||
| 57180 | 57180 | 135952 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2870 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001073.9556 | 2115610.46068 | 37.7891228364056 | -122.44013121200399 | (37.7891228364056, -122.440131212004) | |||
| 31409 | 31409 | 135955 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3035 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6000215.874919999 | 2115769.86788 | 37.789511638505104 | -122.443111506798 | (37.7895116385051, -122.443111506798) | |||
| 29566 | 29566 | 135956 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3168 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999589.9929599995 | 2115734.38967 | 37.789378518158 | -122.44527443117599 | (37.789378518158, -122.445274431176) | |||
| 63062 | 63062 | 135957 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2961 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5999402.43366 | 2117332.15593 | 37.7937548548653 | -122.44603833151899 | (37.7937548548653, -122.446038331519) | |||
| 149151 | 149151 | 135962 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600 Divisadero St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000720.81325 | 2117333.0898599997 | 37.7938326156312 | -122.441476699387 | (37.7938326156312, -122.441476699387) | |||
| 183269 | 183269 | 135964 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001301.4834199995 | 2117308.30173 | 37.7937976176176 | -122.439465753262 | (37.7937976176176, -122.439465753262) | |||
| 42134 | 42134 | 135965 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) |
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");