trees
4,014 rows where qSpecies_id = 40 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4500 | 239551 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 121 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005985.55135 | 2098206.06147 | 37.7416128748431 | -122.421900865949 | (37.7416128748431, -122.421900865949) | 2 | 7 | 7 | 28859 | 2 | |||
4692 | 74315 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6000588.28843 | 2093013.22945 | 37.7270487050229 | -122.440190437741 | (37.7270487050229, -122.440190437741) | 9 | 7 | 6 | 28861 | 25 | |||
4825 | 238155 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 720 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001723.2813 | 2102070.97007 | 37.7519837019852 | -122.436914952169 | (37.7519837019852, -122.436914952169) | 2 | 4 | 5 | 28862 | 22 | |||
4831 | 238452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 74 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002631.46535 | 2108682.38304 | 37.7701886206411 | -122.434246935272 | (37.7701886206411, -122.434246935272) | 15 | 5 | 5 | 29492 | 9 | |||
4965 | 70417 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 124 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007053.10759 | 2093048.17382 | 37.7275105968359 | -122.417844078137 | (37.7275105968359, -122.417844078137) | 9 | 3 | 7 | 309 | 5 | |||
4971 | 214807 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 550 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996780.18786 | 2093638.94841 | 37.7285492382588 | -122.453400068478 | (37.7285492382588, -122.453400068478) | 9 | 7 | 4 | 28861 | 40 | |||
5031 | 124472 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2474 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995885.81707 | 2110375.20896 | 37.7744514982012 | -122.457702438809 | (37.7744514982012, -122.457702438809) | 11 | 5 | 2 | 54 | 16 | |||
5062 | 80388 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1746 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011768.66094 | 2092717.74347 | 37.7268675545821 | -122.401519069956 | (37.7268675545821, -122.401519069956) | 10 | 3 | 8 | 58 | 1 | |||
5311 | 237438 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1249 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001996.99133 | 2100364.87543 | 37.7473147241062 | -122.435846365126 | (37.7473147241062, -122.435846365126) | 2 | 4 | 5 | 63 | 22 | |||
5538 | 178975 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 60 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998617.79966 | 2087941.66603 | 37.7130109785485 | -122.44663762445 | (37.7130109785485, -122.44663762445) | 9 | 7 | 6 | 28861 | 25 | |||
5576 | 238143 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 574 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001412.71542 | 2101470.20367 | 37.7503164848156 | -122.437945904402 | (37.7503164848156, -122.437945904402) | 2 | 4 | 5 | 28862 | 22 | |||
5590 | 238162 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3886 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002578.83158 | 2102997.86594 | 37.754577326999 | -122.434022589469 | (37.754577326999, -122.434022589469) | 2 | 4 | 5 | 28862 | 22 | |||
5924 | 214716 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 163 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993482.35353 | 2094088.81019 | 37.729594862901 | -122.464833426615 | (37.729594862901, -122.464833426615) | 9 | 8 | 4 | 59 | 40 | |||
5935 | 30897 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 252 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 7 | Permit Number 34724 | 6007528.97575 | 2097493.20201 | 37.7397424432633 | -122.416513727228 | (37.7397424432633, -122.416513727228) | 2 | 7 | 7 | 28859 | 2 | |
6060 | 239556 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 222 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006749.08669 | 2098198.68674 | 37.741635656457 | -122.419260290053 | (37.741635656457, -122.419260290053) | 2 | 7 | 7 | 28859 | 2 | |||
6076 | 123107 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 526 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992541.35538 | 2111846.16706 | 37.7782976564198 | -122.469378557612 | (37.7782976564198, -122.469378557612) | 11 | 6 | 2 | 54 | 11 | |||
6082 | 237213 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 470 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002920.23053 | 2098629.95648 | 37.7426034430062 | -122.432529972083 | (37.7426034430062, -122.432529972083) | 2 | 7 | 5 | 63 | 22 | |||
6211 | 44491 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 55 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 9 | Permit Number 45395 | 6005461.21441 | 2093276.54578 | 37.728047939957 | -122.423363497235 | (37.728047939957, -122.423363497235) | 9 | 7 | 7 | 309 | 5 | |
6337 | 55153 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2009 12:00:00 AM | 3x3 | Permit Number 52132 | 6003602.67369464 | 2101839.43403285 | 37.7514545976895 | -122.430399225072 | (37.7514545976895, -122.430399225072) | 2 | 4 | 5 | 28862 | 22 | ||
6401 | 70501 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 75 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004654.40413 | 2093072.16776 | 37.7274411943513 | -122.42613812337 | (37.7274411943513, -122.42613812337) | 9 | 7 | 6 | 28861 | 5 | |||
6547 | 238340 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 227 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787829 | 6002088.29914 | 2104514.86028 | 37.7587147776761 | -122.435827511746 | (37.7587147776761, -122.435827511746) | 2 | 4 | 5 | 28862 | 3 | |
6581 | 214481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1623 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5990862.01954 | 2104342.15602 | 37.7575964779098 | -122.474640129733 | (37.7575964779098, -122.474640129733) | 1 | 8 | 4 | 56 | 12 | |||
6608 | 47030 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.7722281991235 | -122.424230399247 | (37.7722281991235, -122.424230399247) | 7 | 9 | 11 | 28852 | 10 | ||
6690 | 79764 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Wanda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000559.45557 | 2091550.49268 | 37.7230307229714 | -122.440185263946 | (37.7230307229714, -122.440185263946) | 9 | 7 | 6 | 28861 | 25 | |||
6937 | 68735 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3968 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32653 | 5995812.60766 | 2114880.06908 | 37.7868164408107 | -122.458281808143 | (37.7868164408107, -122.458281808143) | 11 | 6 | 1 | 54 | 31 | ||
6973 | 214477 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1587 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990545.71643 | 2104592.61626 | 37.758265842404 | -122.475752312336 | (37.758265842404, -122.475752312336) | 1 | 8 | 4 | 56 | 12 | |||
7312 | 254991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1508 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2020 12:00:00 PM | 3 | 4x4 | 6002019 | 2093366 | 37.7280986838153 | -122.435269719024 | (37.7280986838153, -122.435269719024) | 9 | 7 | 6 | 28861 | 25 | ||
7488 | 21658 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | 13 | 9 | 11 | 29490 | 13 | |||
7667 | 238373 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 587 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002476.35848 | 2103824.63673 | 37.7568416256553 | -122.434436077082 | (37.7568416256553, -122.434436077082) | 2 | 4 | 5 | 28862 | 3 | |||
7738 | 73633 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5983562.48746 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | 11 | 6 | 2 | 55 | 26 | |||
7761 | 238135 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 60 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006116.90537 | 2099100.80672 | 37.7440770505137 | -122.421510217522 | (37.7440770505137, -122.421510217522) | 2 | 7 | 7 | 28859 | 2 | |||
7852 | 238334 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 286 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002701.12407 | 2104251.52183 | 37.7580265058249 | -122.433689263855 | (37.7580265058249, -122.433689263855) | 2 | 4 | 5 | 28862 | 3 | |||
7882 | 68956 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.33246 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | 11 | 6 | 2 | 55 | 26 | |
7896 | 4158 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3739-3737 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 12 | 3X3 | 6005577.78119 | 2100485.82594 | 37.7478495841857 | -122.423472835916 | (37.7478495841857, -122.423472835916) | 2 | 4 | 5 | 28859 | 22 | ||
7901 | 70504 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 437 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6004727.68791 | 2092850.78229 | 37.7268374605684 | -122.425869029139 | (37.7268374605684, -122.425869029139) | 9 | 7 | 6 | 28861 | 5 | |||
7935 | 213699 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 62 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 8 | Width 3ft | Permit Number 42424 | 5999655.47058 | 2093801.73285 | 37.7291606000606 | -122.443471779698 | (37.7291606000606, -122.443471779698) | 9 | 7 | 4 | 63 | 40 | |
8095 | 67626 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.419291917399 | (37.7973213520513, -122.419291917399) | 5 | 1 | 10 | 28858 | 32 | |
8215 | 78428 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.428974079707 | (37.7176015427445, -122.428974079707) | 9 | 7 | 6 | 28861 | 5 | |||
8324 | 78480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001855.96209 | 2090141.35003 | 37.719235261989 | -122.435602746878 | (37.719235261989, -122.435602746878) | 9 | 7 | 6 | 28861 | 5 | |||
8326 | 72143 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 12 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6000249.61025 | 2091756.38076 | 37.7235783992966 | -122.441271099083 | (37.7235783992966, -122.441271099083) | 9 | 7 | 6 | 28861 | 25 | |||
8391 | 238054 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 432 Lily St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004439.8336 | 2109989.04683 | 37.7738788753301 | -122.428084933487 | (37.7738788753301, -122.428084933487) | 7 | 9 | 11 | 28852 | 10 | |||
8455 | 79359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 567 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5985009.75382 | 2112015.61326 | 37.7783247854299 | -122.495445265062 | (37.7783247854299, -122.495445265062) | 11 | 6 | 2 | 55 | 26 | |||
8641 | 41286 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 494 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | 8 | 4 | 5 | 28853 | 19 | ||
8799 | 28348 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3136 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008810.2764485 | 2100618.7635013 | 37.748396520659 | -122.412304375108 | (37.748396520659, -122.412304375108) | 2 | 4 | 7 | 28859 | 19 | ||
8800 | 53644 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4051 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52604 | 6002653.10802153 | 2105292.31520624 | 37.7608815491861 | -122.433929717717 | (37.7608815491861, -122.433929717717) | 2 | 4 | 5 | 28862 | 3 | |
9027 | 238423 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4328 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000572.71339 | 2105813.81036 | 37.7621951665895 | -122.441162282037 | (37.7621951665895, -122.441162282037) | 15 | 5 | 5 | 28862 | 3 | |||
9062 | 68953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 750 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 3 | 3x3 | Permit Number 32942 | 5988850.38114 | 2110206.21118 | 37.7735808052559 | -122.482026682299 | (37.7735808052559, -122.482026682299) | 11 | 6 | 2 | 55 | 26 |
9128 | 238117 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3017 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009237.77363 | 2104492.70808 | 37.7590574832375 | -122.411099692516 | (37.7590574832375, -122.411099692516) | 2 | 4 | 7 | 28859 | 19 | |||
9167 | 213451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993177.52134 | 2099659.66969 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | 1 | 8 | 4 | 29491 | 40 | |||
9279 | 196461 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 615 Mississippi St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542099 | (37.7587393543665, -122.39411542099) | 10 | 3 | 8 | 28856 | 29 | |||
9300 | 34481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 839 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 9 | Permit Number 38208 | 6008950.87239 | 2119364.89119 | 37.7998768700862 | -122.413143564642 | (37.7998768700862, -122.413143564642) | 3 | 1 | 10 | 308 | 32 | |
9518 | 65278 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 415 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1989 12:00:00 AM | 1 | Permit Number 28081 | 6011215.3927 | 2112332.46737 | 37.7806943784819 | -122.40481205634 | (37.7806943784819, -122.40481205634) | 14 | 2 | 9 | 28853 | 34 | |
9801 | 72374 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 766 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990089.45799 | 2110137.86742 | 37.7734651388758 | -122.477735579303 | (37.7734651388758, -122.477735579303) | 11 | 6 | 2 | 55 | 26 | |||
9950 | 78381 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 631 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6003379.38532 | 2089522.9059 | 37.7176235608499 | -122.430292752023 | (37.7176235608499, -122.430292752023) | 9 | 7 | 6 | 28861 | 5 | |||
9953 | 73879 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6004728.86924 | 2093550.80398 | 37.7287596319363 | -122.425914753389 | (37.7287596319363, -122.425914753389) | 9 | 7 | 6 | 28861 | 5 | |||
10066 | 91129 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2100X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52620 | 5989031.08283 | 2111274.17492 | 37.776523645314 | -122.481479844539 | (37.776523645314, -122.481479844539) | 11 | 6 | 2 | 55 | 26 | |
10161 | 214669 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2222 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991758.11686 | 2100299.12618 | 37.7465472525561 | -122.471246528119 | (37.7465472525561, -122.471246528119) | 1 | 8 | 4 | 29491 | 40 | |||
10193 | 124493 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3148 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995905.24735 | 2111438.77615 | 37.7773728899422 | -122.45771219988 | (37.7773728899422, -122.45771219988) | 11 | 6 | 2 | 54 | 16 | |||
10261 | 89402 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1914 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992725.99788 | 2112086.29643 | 37.7789676550624 | -122.468757294436 | (37.7789676550624, -122.468757294436) | 11 | 6 | 2 | 54 | 11 | ||
10377 | 91396 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2009 12:00:00 AM | 3x3 | Permit Number 52091 | 5996731.3 | 2091236.4 | 37.7219496073249 | -122.453395686079 | (37.7219496073249, -122.453395686079) | 9 | 8 | 4 | 28861 | 24 | ||
10496 | 68949 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.482056500957 | (37.7739652106004, -122.482056500957) | 11 | 6 | 2 | 55 | 26 | |
10577 | 76677 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010109 | 2093148 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | 10 | 3 | 7 | 309 | 28 | |||
10579 | 237349 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1103X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008183.53987 | 2097707.79876 | 37.7403684685413 | -122.414265694627 | (37.7403684685413, -122.414265694627) | 2 | 7 | 7 | 28859 | 2 | |||
10728 | 237359 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1398 Treat Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008689.76614 | 2100834.9062 | 37.7489832371873 | -122.412736376802 | (37.7489832371873, -122.412736376802) | 2 | 4 | 7 | 28859 | 19 | |||
10833 | 135992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.412150906452 | (37.7943794313202, -122.412150906452) | 3 | 1 | 10 | 28857 | 21 | |||
10901 | 4185 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3836 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004920.4543 | 2100493.66271 | 37.7478339791697 | -122.425746400299 | (37.7478339791697, -122.425746400299) | 2 | 4 | 5 | 63 | 22 | |||
11026 | 53052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.25817 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | 13 | 9 | 1 | 29490 | 27 | |
11117 | 12763 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 5989830.30372 | 2114748.73304 | 37.7861102501687 | -122.478969342589 | (37.7861102501687, -122.478969342589) | 11 | 6 | 1 | 55 | 33 | |||
11139 | 57395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.416431412305 | (37.7941539658926, -122.416431412305) | 5 | 1 | 10 | 28858 | 32 | ||
11336 | 213698 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 54 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 9 | Width 2ft | Permit Number 42422 | 5999705.61228 | 2093800.4183 | 37.7291598500291 | -122.443298341854 | (37.7291598500291, -122.443298341854) | 9 | 7 | 4 | 63 | 40 | |
11361 | 78243 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 30 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000646.02726 | 2093117.37413 | 37.7273379494759 | -122.439998300301 | (37.7273379494759, -122.439998300301) | 9 | 7 | 6 | 28861 | 25 | |||
11603 | 238318 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 23 Clover Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6000458.56738 | 2105088.99316 | 37.7601984944918 | -122.441505054123 | (37.7601984944918, -122.441505054123) | 2 | 4 | 5 | 28862 | 3 | |||
11648 | 238436 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 404 Loma Vista Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999965.40666 | 2106753.04147 | 37.7647394502792 | -122.443330183252 | (37.7647394502792, -122.443330183252) | 15 | 5 | 5 | 29492 | 3 | |||
11717 | 78354 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000366.91048 | 2090562.17909 | 37.7203060748337 | -122.440779991907 | (37.7203060748337, -122.440779991907) | 9 | 7 | 6 | 28861 | 25 | |||
11785 | 72266 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325117 | (37.7230023412585, -122.43384325117) | 9 | 7 | 6 | 28861 | 5 | |||
11792 | 135925 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2725 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999832.27617 | 2118786.40209 | 37.7977723656638 | -122.444655616678 | (37.7977723656638, -122.444655616678) | 13 | 9 | 1 | 57 | 17 | |||
11848 | 238215 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 164 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004052.17675 | 2101028.41452 | 37.7492531795117 | -122.428786978444 | (37.7492531795117, -122.428786978444) | 2 | 4 | 5 | 28862 | 22 | |||
11855 | 237398 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1345 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005860.83532 | 2101136.51471 | 37.7496521987857 | -122.422540276735 | (37.7496521987857, -122.422540276735) | 2 | 4 | 5 | 28859 | 19 | |||
11905 | 237259 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006662.65242 | 2096074.47296 | 37.7357981696519 | -122.419408489336 | (37.7357981696519, -122.419408489336) | 2 | 7 | 7 | 28859 | 2 | |||
11922 | 78132 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 738 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009313.83221 | 2090783.01669 | 37.7214179201914 | -122.409868876754 | (37.7214179201914, -122.409868876754) | 9 | 3 | 7 | 309 | 28 | |||
11936 | 213433 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2326 Cecilia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991473.33081 | 2099563.75033 | 37.7445116227142 | -122.472177683457 | (37.7445116227142, -122.472177683457) | 1 | 8 | 4 | 29491 | 40 | |||
12067 | 78234 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5999806.62934 | 2090324.19629 | 37.7196207041996 | -122.44269961461 | (37.7196207041996, -122.44269961461) | 9 | 7 | 6 | 28861 | 25 | |||
12076 | 110751 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | Permit Number 775489 | 5981042.2 | 2112214 | 37.778636382962 | -122.509184994454 | (37.778636382962, -122.509184994454) | 11 | 6 | 2 | 55 | 26 | ||
12174 | 237303 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6008815.17724 | 2097064.11104 | 37.7386365028681 | -122.412036256383 | (37.7386365028681, -122.412036256383) | 10 | 7 | 7 | 28859 | 2 | |||
12254 | 213339 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992194.58269 | 2090348.43318 | 37.7192503768696 | -122.469013242585 | (37.7192503768696, -122.469013242585) | 9 | 8 | 6 | 64 | 24 | |||
12351 | 238094 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1106 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009181.56819 | 2102633.1404 | 37.7539483780274 | -122.411162722403 | (37.7539483780274, -122.411162722403) | 2 | 4 | 7 | 28859 | 19 | |||
12803 | 64859 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 45 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | 10 | Permit Number 25875 | 5995863.10867 | 2112429.78445 | 37.7800915155758 | -122.457929703566 | (37.7800915155758, -122.457929703566) | 11 | 6 | 2 | 54 | 16 | |
13306 | 84576 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3966 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769743 | 6003390.40048346 | 2101879.79659646 | 37.7515533971776 | -122.431136171604 | (37.7515533971776, -122.431136171604) | 2 | 4 | 5 | 28862 | 22 |
13363 | 238529 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6003245.12676 | 2097701.12571 | 37.7400715069955 | -122.431340287739 | (37.7400715069955, -122.431340287739) | 2 | 7 | 5 | 63 | 7 | ||||
13408 | 28246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | 10 | 7 | 8 | 309 | 28 | ||
13432 | 48426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3130 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 9 | Permit Number 45804 | 6001942.58238 | 2118964.92546 | 37.7983827391207 | -122.437366176208 | (37.7983827391207, -122.437366176208) | 13 | 9 | 1 | 57 | 17 | |
13439 | 238206 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 427 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6003541.49659 | 2103297.00416 | 37.7554532756756 | -122.430714784966 | (37.7554532756756, -122.430714784966) | 2 | 4 | 5 | 28862 | 22 | |||
13452 | 214499 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1314 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992102.94479 | 2106463.61182 | 37.7634932615306 | -122.470503050471 | (37.7634932615306, -122.470503050471) | 1 | 8 | 11 | 56 | 12 | |||
13508 | 237345 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 899 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009109.05137 | 2096909.74742 | 37.7382291378753 | -122.411009275572 | (37.7382291378753, -122.411009275572) | 10 | 7 | 7 | 28859 | 2 | |||
13720 | 91923 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1427 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991353.957672 | 2106548.744029 | 37.76368367545 | -122.473099740894 | (37.76368367545, -122.473099740894) | 1 | 8 | 11 | 56 | 12 | ||
14093 | 238081 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 690X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008596.10001 | 2098083.7185 | 37.741423827457 | -122.412865791044 | (37.741423827457, -122.412865791044) | 10 | 7 | 7 | 28859 | 2 | |||
14192 | 28301 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3336 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2003 12:00:00 AM | 8 | 3X3 | 6011974.10308 | 2090046.14983 | 37.719543365213 | -122.400621263274 | (37.719543365213, -122.400621263274) | 10 | 7 | 8 | 309 | 28 | ||
14257 | 238498 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 105 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003477.34326 | 2097803.5179 | 37.7403658101453 | -122.430544682709 | (37.7403658101453, -122.430544682709) | 2 | 7 | 5 | 63 | 7 | |||
14275 | 72259 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 231 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6002836.88949 | 2092205.70744 | 37.7249591941085 | -122.432359414777 | (37.7249591941085, -122.432359414777) | 9 | 7 | 6 | 28861 | 5 | |||
14334 | 70497 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 182 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6003784.02088 | 2092788.04528 | 37.7266118242601 | -122.429126790893 | (37.7266118242601, -122.429126790893) | 9 | 7 | 6 | 28861 | 5 |
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) );