trees
3,247 rows where qSpecies_id = 22 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194438 | 225616 | Prune Opt Out 3 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 787984 | 6001852.25626 | 2097023.92467 | 37.7381330336073 | -122.436107807923 | (37.7381330336073, -122.436107807923) | 2 | 7 | 5 | 63 | 7 | ||
| 194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194274 | 176549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Permit Number 785586 | 6001075.93443 | 2091730.69509 | 37.7235549090091 | -122.438412809004 | (37.7235549090091, -122.438412809004) | 9 | 7 | 6 | 28861 | 25 | |||
| 194148 | 228331 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006613.24139 | 2110474.94524 | 37.7753357617652 | -122.420601244852 | (37.7753357617652, -122.420601244852) | 7 | 9 | 11 | 28852 | 10 | |||
| 194143 | 118792 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 746 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5982002.3368 | 2110652.98782 | 37.7744068613492 | -122.505747814892 | (37.7744068613492, -122.505747814892) | 11 | 6 | 2 | 55 | 26 | ||||
| 194092 | 38822 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 267 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 3 | Permit Number 40658 | 5994596.29964 | 2113755.34556 | 37.783658286436 | -122.462408310129 | (37.783658286436, -122.462408310129) | 11 | 6 | 2 | 54 | 11 | |
| 194070 | 226096 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009344.43572 | 2100479.81263 | 37.7480449520127 | -122.410447446595 | (37.7480449520127, -122.410447446595) | 2 | 7 | 7 | 28859 | 2 | |||
| 194039 | 219094 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 219 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5996551.13166 | 2105757.89233 | 37.7618117352438 | -122.455067283854 | (37.7618117352438, -122.455067283854) | 15 | 5 | 11 | 29492 | 12 | |||
| 193982 | 51339 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2345 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2004 12:00:00 AM | Permit Number 47687 | 5998288.77869718 | 2111348.12240087 | 37.7772606157071 | -122.449460290108 | (37.7772606157071, -122.449460290108) | 15 | 6 | 2 | 29492 | 16 | |||
| 193923 | 226174 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1342 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997819.92475 | 2105958.57143 | 37.7624354573459 | -122.45069352368 | (37.7624354573459, -122.45069352368) | 15 | 5 | 11 | 29492 | 9 | |||
| 193692 | 62619 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2620 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 25602 | 6003607.45896 | 2117531.28887 | 37.7945408488382 | -122.431502797041 | (37.7945408488382, -122.431502797041) | 13 | 9 | 1 | 29490 | 27 | ||
| 193680 | 225728 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 782 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001363.80146 | 2102050.7975 | 37.7519078747495 | -122.438156638027 | (37.7519078747495, -122.438156638027) | 2 | 4 | 5 | 28862 | 22 | |||
| 193648 | 147591 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990250.17652 | 2113053.797 | 37.7814808023322 | -122.477392789959 | (37.7814808023322, -122.477392789959) | 11 | 6 | 2 | 55 | 26 | |
| 193646 | 128970 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 380 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005984.29851 | 2111779.35952 | 37.7788819010298 | -122.422869632726 | (37.7788819010298, -122.422869632726) | 7 | 9 | 11 | 28852 | 10 | |||
| 193160 | 245043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 327 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001734.263 | 2109552.9566 | 37.7725280347604 | -122.437412694733 | (37.7725280347604, -122.437412694733) | 15 | 5 | 11 | 29492 | 9 | |||
| 193083 | 43674 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 591 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 2 | Permit Number 43317 | 5995297.36949 | 2111550.66222 | 37.7776451601325 | -122.459823140191 | (37.7776451601325, -122.459823140191) | 11 | 6 | 2 | 54 | 11 | |
| 192985 | 190482 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015263.83745 | 2116154.04357 | 37.7914130094428 | -122.39107360987 | (37.7914130094428, -122.39107360987) | 6 | 2 | 9 | 28855 | 6 | |||
| 192972 | 110481 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | 15 | 5 | 11 | 29492 | 10 | |
| 192929 | 28722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1881 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2003 12:00:00 AM | 3 | 3X3 | 6004480.9191 | 2114982.507 | 37.7875920051185 | -122.428298772657 | (37.7875920051185, -122.428298772657) | 13 | 9 | 11 | 28858 | 27 | ||
| 192889 | 226238 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 33 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006031.01005 | 2102851.93497 | 37.7543719470289 | -122.422073655382 | (37.7543719470289, -122.422073655382) | 2 | 4 | 5 | 28859 | 19 | |||
| 192776 | 107779 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3155 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770908 | 6000890.66944 | 2119210.84486 | 37.7989981119436 | -122.441023758536 | (37.7989981119436, -122.441023758536) | 13 | 9 | 1 | 57 | 17 | |
| 192726 | 51630 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3100ON LYON ST Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2010 12:00:00 AM | 3 | Permit Number 53623 | 5999247.45332 | 2116665.23813 | 37.7919148239635 | -122.446526571667 | (37.7919148239635, -122.446526571667) | 11 | 6 | 1 | 29490 | 30 | ||
| 192669 | 5735 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1731 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/28/2008 12:00:00 AM | 50 | 3x3 | 6005365.9005 | 2098299.94514 | 37.7418356926592 | -122.424050086446 | (37.7418356926592, -122.424050086446) | 2 | 7 | 5 | 28859 | 7 | ||
| 192668 | 46083 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | 3 | 1 | 10 | 308 | 23 | ||
| 192488 | 1403 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 62 Ardath Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017428.9119183 | 2095344.9938609 | 37.7343956759938 | -122.382134203041 | (37.7343956759938, -122.382134203041) | 10 | 3 | 8 | 58 | 1 | ||
| 192477 | 128963 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 280 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007777.87724 | 2112376.8602 | 37.7806235325864 | -122.416707255053 | (37.7806235325864, -122.416707255053) | 7 | 10 | 9 | 28852 | 36 | |||
| 192440 | 129052 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012440.41364 | 2117843.22562 | 37.7958940218454 | -122.40096139676 | (37.7958940218454, -122.40096139676) | 3 | 1 | 10 | 28860 | 4 | |||
| 192392 | 128900 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997110.00941 | 2115314.34087 | 37.7880833028514 | -122.453824498098 | (37.7880833028514, -122.453824498098) | 11 | 6 | 1 | 54 | 31 | |||
| 192339 | 225691 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 248 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006144.37813 | 2101701.09592 | 37.7512184014159 | -122.421599867348 | (37.7512184014159, -122.421599867348) | 2 | 4 | 5 | 28859 | 19 | |||
| 192328 | 128959 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 190 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008244.86904 | 2112441.68801 | 37.7808277884019 | -122.415096292278 | (37.7808277884019, -122.415096292278) | 7 | 10 | 9 | 28852 | 36 | |||
| 192233 | 113841 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1709 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6014543.41524 | 2094775.25043 | 37.7326714894988 | -122.392070556938 | (37.7326714894988, -122.392070556938) | 10 | 3 | 8 | 58 | 1 | |||
| 192106 | 108516 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 695-699X 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773792 | 5993787.87218 | 2111075.28381 | 37.7762529739024 | -122.465010427519 | (37.7762529739024, -122.465010427519) | 11 | 6 | 2 | 54 | 11 |
| 192098 | 200872 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1699 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6011497.9236 | 2106954.0737 | 37.7659423303468 | -122.403456143696 | (37.7659423303468, -122.403456143696) | 8 | 3 | 8 | 28853 | 20 | |||
| 192039 | 226010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3625 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005609.3579 | 2101952.87447 | 37.7518795443244 | -122.42346792563 | (37.7518795443244, -122.42346792563) | 2 | 4 | 5 | 28859 | 19 | |||
| 191973 | 6447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1199 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/20/2015 07:28:00 AM | 3 | 3X3 | 6017815.25315 | 2096866.67001 | 37.7385952266854 | -122.380904232644 | (37.7385952266854, -122.380904232644) | 10 | 3 | 8 | 58 | 1 | ||
| 191948 | 183347 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1219 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983021.011 | 2106794.309 | 37.7638719411282 | -122.501938514072 | (37.7638719411282, -122.501938514072) | 1 | 8 | 3 | 56 | 35 | |||
| 191858 | 226025 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006384.82585 | 2107467.885 | 37.7670662167577 | -122.421177816405 | (37.7670662167577, -122.421177816405) | 8 | 4 | 7 | 28853 | 19 | |||
| 191854 | 190476 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 30 Tehama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013857.7791 | 2114889.51987 | 37.7878627971683 | -122.395849933526 | (37.7878627971683, -122.395849933526) | 6 | 2 | 9 | 28855 | 6 | |||
| 191827 | 219050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2226 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991760.48852 | 2100259.76764 | 37.746439321329 | -122.471235460155 | (37.746439321329, -122.471235460155) | 1 | 8 | 4 | 29491 | 40 | |||
| 191750 | 31082 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 214 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34819 | 6005337.47577154 | 2108480.96748505 | 37.7697887987254 | -122.424872526186 | (37.7697887987254, -122.424872526186) | 8 | 4 | 5 | 28853 | 19 | ||
| 191661 | 190548 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 888 07th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6012403.14406 | 2108680.79722 | 37.7707340441832 | -122.400446452154 | (37.7707340441832, -122.400446452154) | 14 | 2 | 8 | 28856 | 20 | |||
| 191635 | 225986 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 68 McCoppin St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6006193.46964 | 2109164.47862 | 37.7717138690364 | -122.421960222999 | (37.7717138690364, -122.421960222999) | 8 | 2 | 9 | 28853 | 19 | |||
| 191479 | 190584 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 South St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015754.04725 | 2107952.30918 | 37.7689200738306 | -122.388804652706 | (37.7689200738306, -122.388804652706) | 14 | 3 | 9 | 310 | 20 | |||
| 191435 | 71800 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2169 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2008 12:00:00 AM | 3x3 | Permit Number 51966 | 5997498.69727055 | 2109850.09270913 | 37.7731021869441 | -122.45208531215 | (37.7731021869441, -122.45208531215) | 15 | 5 | 11 | 29492 | 16 | ||
| 191379 | 66555 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 105 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 33488 | 6005613.52576911 | 2103994.07862433 | 37.7574844520759 | -122.423598622944 | (37.7574844520759, -122.423598622944) | 2 | 4 | 5 | 28859 | 19 | ||
| 191354 | 219102 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 524 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993068.50132 | 2099447.34757 | 37.744284195874 | -122.466653494359 | (37.744284195874, -122.466653494359) | 1 | 8 | 4 | 29491 | 40 | |||
| 191344 | 5220 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998X Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1995 12:00:00 AM | 3 | 3X4 | 6001495.4192 | 2111745.9646 | 37.7785359024219 | -122.438396022881 | (37.7785359024219, -122.438396022881) | 15 | 5 | 11 | 29490 | 41 | ||
| 191301 | 254390 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009354.25568 | 2118062.93204 | 37.7963246481861 | -122.41165565994 | (37.7963246481861, -122.41165565994) | 3 | 1 | 10 | 308 | 4 | ||
| 191260 | 66309 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 132 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29424 | 6001336.27411679 | 2095419.91678069 | 37.7336994724005 | -122.437776963861 | (37.7336994724005, -122.437776963861) | 9 | 7 | 5 | 63 | 40 | ||
| 191225 | 37312 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 474 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39828 | 6003261.90096676 | 2103330.18063688 | 37.7555285260173 | -122.431684080228 | (37.7555285260173, -122.431684080228) | 2 | 4 | 5 | 28862 | 22 | ||
| 191185 | 256586 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 191164 | 228199 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 195 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001449.27887 | 2104726.99627 | 37.7592609314608 | -122.43805272766 | (37.7592609314608, -122.43805272766) | 2 | 4 | 5 | 28862 | 3 | |||
| 191093 | 39074 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2280X Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
| 191072 | 219071 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 778 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994285.94244 | 2089946.42348 | 37.7182671687656 | -122.461755121921 | (37.7182671687656, -122.461755121921) | 9 | 8 | 6 | 28861 | 24 | |||
| 191028 | 51313 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1255 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2004 12:00:00 AM | Permit Number 47679 | 6009865.2769481 | 2109575.56803781 | 37.773049022534 | -122.409288169615 | (37.773049022534, -122.409288169615) | 14 | 2 | 9 | 28853 | 34 | |||
| 191006 | 52307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 125 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/02/2005 12:00:00 AM | Permit Number 48466 | 6004248.12570039 | 2092925.52836922 | 37.7270155836301 | -122.427532186974 | (37.7270155836301, -122.427532186974) | 9 | 7 | 6 | 28861 | 5 | ||
| 190998 | 61749 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3849 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1984 12:00:00 AM | 12 | 3x3 | Permit Number 21755 | 6004830.1 | 2100717.5 | 37.7484434784717 | -122.426074773634 | (37.7484434784717, -122.426074773634) | 2 | 4 | 5 | 63 | 22 | |
| 190931 | 65419 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 790 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1989 12:00:00 AM | 7 | Permit Number 28277 | 6010596.9458 | 2116598.4716 | 37.7923732244726 | -122.407252384703 | (37.7923732244726, -122.407252384703) | 3 | 1 | 10 | 28857 | 4 | |
| 190783 | 67107 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1328 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30522 | 5994590.06004034 | 2106476.74067381 | 37.7636728061479 | -122.461901928562 | (37.7636728061479, -122.461901928562) | 15 | 5 | 11 | 56 | 12 | ||
| 190757 | 226030 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1371 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006992.44974 | 2107518.2934 | 37.7672388622991 | -122.419079709771 | (37.7672388622991, -122.419079709771) | 8 | 4 | 7 | 28853 | 19 | |||
| 190641 | 246294 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | Permit Number 50790 | 6002905.9647 | 2106288.4454 | 37.7636310281204 | -122.43312637362 | (37.7636310281204, -122.43312637362) | 15 | 4 | 5 | 28862 | 3 | ||
| 190638 | 106655 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 899X BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6000958 | 2111726 | 37.7784505017056 | -122.440253723857 | (37.7784505017056, -122.440253723857) | 15 | 5 | 11 | 29490 | 41 | |||
| 190572 | 17819 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1907 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1992 12:00:00 AM | 3 | 3X3 | 6004809.4741267 | 2115379.5459892 | 37.7887007599806 | -122.427190328672 | (37.7887007599806, -122.427190328672) | 13 | 9 | 11 | 28858 | 27 | ||
| 190503 | 96003 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1440 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767657 | 6015764.7456 | 2093584.4946 | 37.7294696462115 | -122.387765025927 | (37.7294696462115, -122.387765025927) | 10 | 3 | 8 | 58 | 1 |
| 190396 | 190377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 438 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011443.90944 | 2106356.04128 | 37.7642972509397 | -122.40360088809 | (37.7642972509397, -122.40360088809) | 8 | 3 | 8 | 28856 | 29 | |||
| 190362 | 84252 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 525 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51823 | 5988096.43672 | 2112373.30059 | 37.7794871472518 | -122.484793663147 | (37.7794871472518, -122.484793663147) | 11 | 6 | 2 | 55 | 26 | |
| 190331 | 219018 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1371 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991112.59614 | 2106090.92873 | 37.7624126595246 | -122.473901124453 | (37.7624126595246, -122.473901124453) | 1 | 8 | 11 | 56 | 12 | |||
| 190310 | 47269 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1463 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45210 | 5988654.8409 | 2105376.6422 | 37.7603087586576 | -122.482349152365 | (37.7603087586576, -122.482349152365) | 1 | 8 | 3 | 56 | 35 | |
| 190290 | 225729 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 764 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001462.47796 | 2102058.20143 | 37.7519338157129 | -122.437815931663 | (37.7519338157129, -122.437815931663) | 2 | 4 | 5 | 28862 | 22 | |||
| 190234 | 159340 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 38 Whipple Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 12:16:00 PM | 3 | Width 0ft | 5998227.58529 | 2087220.48645 | 37.7110084860347 | -122.447934438717 | (37.7110084860347, -122.447934438717) | 9 | 7 | 6 | 28861 | 25 | ||
| 190043 | 122047 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 193 18th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990208.67805 | 2114141.58816 | 37.7844651654196 | -122.477615887766 | (37.7844651654196, -122.477615887766) | 11 | 6 | 2 | 55 | 26 | |||
| 189815 | 112130 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 189680 | 190400 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | 10 | 3 | 8 | 58 | 1 | |||
| 189665 | 225772 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 445 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002360.0462 | 2105600.00836 | 37.7617097647072 | -122.43496529393 | (37.7617097647072, -122.43496529393) | 15 | 4 | 5 | 28862 | 3 | |||
| 189644 | 226158 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 491 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003348.07172 | 2100070.58853 | 37.746583336959 | -122.431153427509 | (37.746583336959, -122.431153427509) | 2 | 7 | 5 | 63 | 22 | |||
| 189631 | 34609 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3222 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38294 | 5999276.61013 | 2116016.00352 | 37.7901338623233 | -122.446378963219 | (37.7901338623233, -122.446378963219) | 13 | 6 | 1 | 29490 | 31 | |
| 189610 | 108712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011359.92903 | 2106527.96496 | 37.7647646232249 | -122.403903453285 | (37.7647646232249, -122.403903453285) | 8 | 3 | 8 | 28853 | 20 |
| 189583 | 190447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1201 Evans Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6017726.41303 | 2096927.8119 | 37.7387582063175 | -122.381215652579 | (37.7387582063175, -122.381215652579) | 10 | 3 | 8 | 58 | 1 | |||
| 189556 | 24635 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1990 12:00:00 AM | 6 | 3X3 | 6001671.03792 | 2110007.38594 | 37.7737721896694 | -122.437663947137 | (37.7737721896694, -122.437663947137) | 15 | 5 | 11 | 29492 | 10 | ||
| 189523 | 176524 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 852 Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000736.05759 | 2088940.42663 | 37.7158741240663 | -122.439387786529 | (37.7158741240663, -122.439387786529) | 9 | 7 | 6 | 28861 | 5 | |||
| 189451 | 67448 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1125 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2013 12:00:00 AM | 1 | Permit Number 770463 | 5992116.86908 | 2110647.4153 | 37.7749816699887 | -122.470759658967 | (37.7749816699887, -122.470759658967) | 11 | 6 | 2 | 54 | 11 | |
| 189397 | 120714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 124 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989311.18086 | 2114513.57102 | 37.7854344024084 | -122.480748126321 | (37.7854344024084, -122.480748126321) | 11 | 6 | 2 | 55 | 26 | |||
| 189336 | 116725 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180X PERALTA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009777 | 2100122 | 37.7470867174475 | -122.408926407614 | (37.7470867174475, -122.408926407614) | 2 | 7 | 7 | 28859 | 2 | ||||
| 189221 | 225981 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006323.97491 | 2107964.63491 | 37.7684267435348 | -122.421423572363 | (37.7684267435348, -122.421423572363) | 8 | 4 | 7 | 28853 | 19 | |||
| 189175 | 6662 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1992 12:00:00 AM | 6 | 3X3 | 6016012.05161 | 2098330.17252 | 37.7425140162093 | -122.387240954701 | (37.7425140162093, -122.387240954701) | 10 | 3 | 8 | 58 | 1 | ||
| 189120 | 225625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1521 Piedmont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999695.53551 | 2107195.86271 | 37.7659399337052 | -122.44429541841 | (37.7659399337052, -122.44429541841) | 15 | 5 | 5 | 29492 | 9 | |||
| 189070 | 59618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1004 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 2 | Permit Number 31152 | 6015486.09515 | 2104460.82151 | 37.7593183495794 | -122.389487622149 | (37.7593183495794, -122.389487622149) | 10 | 3 | 8 | 28856 | 29 | |
| 189023 | 226272 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 447 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000682.00347 | 2101402.67732 | 37.7500894932508 | -122.440467906486 | (37.7500894932508, -122.440467906486) | 2 | 4 | 5 | 28862 | 22 | |||
| 188988 | 98791 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | 3 | 1 | 10 | 28857 | 4 | |
| 188920 | 94287 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 188877 | 91456 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 188792 | 14574 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999367.196 | 2108956.8623 | 37.7707564564018 | -122.445557716473 | (37.7707564564018, -122.445557716473) | 15 | 5 | 11 | 29492 | 9 | |||
| 188719 | 226045 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2435 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009736.10688 | 2103170.9846 | 37.755456261416 | -122.40928294058 | (37.755456261416, -122.40928294058) | 2 | 4 | 7 | 28859 | 19 | |||
| 188667 | 219029 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 737 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993424.71307 | 2106611.74304 | 37.7639763296664 | -122.46594227814 | (37.7639763296664, -122.46594227814) | 1 | 8 | 11 | 56 | 12 | |||
| 188638 | 93952 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53397 | 6012964.97703 | 2114077.52304 | 37.7855835346973 | -122.398881872795 | (37.7855835346973, -122.398881872795) | 6 | 2 | 9 | 28855 | 6 | |
| 188564 | 123449 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 753 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995335.29014 | 2110506.62589 | 37.7747806932834 | -122.459616323775 | (37.7747806932834, -122.459616323775) | 11 | 6 | 2 | 54 | 11 | |||
| 188520 | 110936 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
| 188389 | 48375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 6 | Permit Number 45774 | 6011700.23604 | 2106847.17635 | 37.7656601123427 | -122.402748864073 | (37.7656601123427, -122.402748864073) | 8 | 3 | 8 | 28853 | 20 | ||
| 188386 | 225688 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 401 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008962.83235 | 2106307.08576 | 37.7640239271819 | -122.412178805204 | (37.7640239271819, -122.412178805204) | 8 | 4 | 7 | 28859 | 19 |
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) );