Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101472 | 101472 | 106058 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 301 FILBERT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6011273.0 | 2120044.0 | 37.8018716248897 | -122.40515593659401 | (37.8018716248897, -122.405155936594) | ||||
| 101634 | 101634 | 115378 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 42 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.42362125502599 | (37.7364412712621, -122.423621255026) | ||
| 102270 | 102270 | 112846 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2200 KEITH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014766.0 | 2092880.0 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | ||||
| 102623 | 102623 | 107896 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 230X 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) | |
| 103330 | 103330 | 112848 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2200 KEITH ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014766.0 | 2092880.0 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | ||||
| 103509 | 103509 | 112850 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2200 KEITH ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014766.0 | 2092880.0 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | ||||
| 103849 | 103849 | 107895 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 230X 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) | |
| 104278 | 104278 | 117387 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 104727 | 104727 | 121218 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 441 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005284.0 | 2110767.0 | 37.776062670273205 | -122.425220189207 | (37.7760626702732, -122.425220189207) | ||||
| 104808 | 104808 | 107501 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 773456 | 6007102.0 | 2120561.3 | 37.8030579393401 | -122.419626302363 | (37.8030579393401, -122.419626302363) | ||
| 108358 | 108358 | 108818 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 583 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774655 | 6002868.5584 | 2090237.17355 | 37.7195558341056 | -122.43210942658199 | (37.7195558341056, -122.432109426582) | |
| 108949 | 108949 | 117383 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 109171 | 109171 | 115383 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777467 | 6006881.6 | 2096254.2 | 37.7363039898307 | -122.418664241464 | (37.7363039898307, -122.418664241464) | ||
| 109602 | 109602 | 116421 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 621 STOCKTON ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010507.0 | 2116333.0 | 37.7916392690679 | -122.407544875665 | (37.7916392690679, -122.407544875665) | |||||
| 110461 | 110461 | 109413 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 114 Porter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773149 | 6006968.5 | 2095329.1 | 37.7337687610147 | -122.41829822041201 | (37.7337687610147, -122.418298220412) |
| 110689 | 110689 | 36551 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 774597 | 6007583.24246776 | 2095353.82916435 | 37.73387124698429 | -122.41617461780899 | (37.7338712469843, -122.416174617809) | ||
| 113235 | 113235 | 122400 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 113644 | 113644 | 117385 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 116056 | 116056 | 98012 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 8 | 3x3 | Permit Number 770790 | 6001417.0 | 2104061.0 | 37.7574304316811 | -122.43811665528 | (37.7574304316811, -122.43811665528) | |
| 116203 | 116203 | 119609 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 228 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990599.0 | 2113870.0 | 37.7837421028695 | -122.47624567750601 | (37.7837421028695, -122.476245677506) | ||||
| 117100 | 117100 | 117384 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 117298 | 117298 | 108904 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Fire Dept 12 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772986 | 6008567.7 | 2096169.9 | 37.7361673058735 | -122.41282871497101 | (37.7361673058735, -122.412828714971) |
| 118227 | 118227 | 106902 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 370 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2014 12:00:00 AM | 15 | 3x3 | Permit Number 772995 | 6009514.3 | 2121304.0 | 37.8052327952843 | -122.411330948142 | (37.8052327952843, -122.411330948142) | |
| 118970 | 118970 | 122399 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 119725 | 119725 | 117382 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 119907 | 119907 | 109410 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 401 MOLIMO DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997363.9 | 2097040.1 | 37.737921427785395 | -122.451627389441 | (37.7379214277854, -122.451627389441) | ||||
| 120453 | 120453 | 117448 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776857 | 6007658.8 | 2115857.7 | 37.7901743736919 | -122.417365949941 | (37.7901743736919, -122.417365949941) | ||
| 120946 | 120946 | 122898 | Private 5 | Podocarpus gracilor :: Fern Pine 13 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6006160.0 | 2102149.0 | 37.752449123979794 | -122.421577653162 | (37.7524491239798, -122.421577653162) | |||
| 121081 | 121081 | 116711 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1400 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | |||
| 121620 | 121620 | 106908 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 250 EUCLID AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5998068.9 | 2114004.4 | 37.7845414798133 | -122.45041245124901 | (37.7845414798133, -122.450412451249) | ||||
| 121982 | 121982 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
| 126600 | 126600 | 117039 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2220x SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 126763 | 126763 | 87773 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 91 Mizpah St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 774823 | 6001042.0 | 2096186.0 | 37.7357862214985 | -122.43884923338001 | (37.7357862214985, -122.43884923338) | |||
| 126808 | 126808 | 115377 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 42 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777462 | 6005449.5 | 2096333.6 | 37.7364412712621 | -122.42362125502599 | (37.7364412712621, -122.423621255026) | ||
| 128439 | 128439 | 112851 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2200 KEITH ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014766.0 | 2092880.0 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | ||||
| 128550 | 128550 | 65034 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 370 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2014 12:00:00 AM | 3x3 | Permit Number 772995 | 6009516.88940382 | 2121227.93939846 | 37.8050240970929 | -122.411316610619 | (37.8050240970929, -122.411316610619) | ||
| 129337 | 129337 | 114539 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | Permit Number 770790 | 6001361.1 | 2104034.2 | 37.7573536660829 | -122.438308059404 | (37.7573536660829, -122.438308059404) | |||
| 131517 | 131517 | 37210 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1927 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39776 | 5986283.4263 | 2102108.4415 | 37.751196944743 | -122.49031023153799 | (37.751196944743, -122.490310231538) | |
| 135050 | 135050 | 244933 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 276 Page St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6005244.6732 | 2109942.1819 | 37.773795698453604 | -122.425297523476 | (37.7737956984536, -122.425297523476) | |||
| 135827 | 135827 | 37227 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1823 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 6 | Permit Number 39791 | 5985639.2314 | 2102798.4516 | 37.75305387965229 | -122.49258870721 | (37.7530538796523, -122.49258870721) | |
| 136316 | 136316 | 244934 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 269 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005246.8004 | 2110075.5866 | 37.774162115578704 | -122.42529966014901 | (37.7741621155787, -122.425299660149) | |||
| 137026 | 137026 | 200094 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2220 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014757.7183 | 2092808.7972 | 37.727283901408896 | -122.391192246384 | (37.7272839014089, -122.391192246384) | |||
| 137863 | 137863 | 138343 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2250 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001783.0488 | 2114314.9363 | 37.7856060025516 | -122.437585027866 | (37.7856060025516, -122.437585027866) | |||
| 137997 | 137997 | 139141 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1730 GEARY BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003375.8185 | 2113943.8659 | 37.7846775665641 | -122.432048002548 | (37.7846775665641, -122.432048002548) | |||
| 138319 | 138319 | 107893 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 73X Kissling St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/2014 12:00:00 AM | 3 | 3X3 | Permit Number 770997 | 6008153.6101 | 2109447.48188 | 37.7726012817916 | -122.41519998916999 | (37.7726012817916, -122.41519998917) |
| 139331 | 139331 | 117386 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
| 140378 | 140378 | 107415 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 140998 | 140998 | 115320 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 562 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 775637 | 5992882.5 | 2111642.9 | 37.7777592485634 | -122.468183632004 | (37.7777592485634, -122.468183632004) | ||
| 141863 | 141863 | 84165 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 714-716 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 52661 | 6010104.93425212 | 2104957.66520048 | 37.760382742210204 | -122.408133417925 | (37.7603827422102, -122.408133417925) | ||
| 142368 | 142368 | 112849 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2200 KEITH ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014766.0 | 2092880.0 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | ||||
| 142964 | 142964 | 107417 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 143476 | 143476 | 122686 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 3474 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6005720.0 | 2106109.0 | 37.7632975389877 | -122.423380737252 | (37.7632975389877, -122.423380737252) | |||
| 145801 | 145801 | 107416 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 150237 | 150237 | 183060 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2595 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983027.0823 | 2097502.8119 | 37.738360435752604 | -122.501230213026 | (37.7383604357526, -122.501230213026) | |||
| 150400 | 150400 | 143092 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 487 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010505.1787 | 2120274.7202 | 37.80246217128 | -122.40782924850299 | (37.80246217128, -122.407829248503) | |||
| 150525 | 150525 | 143095 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 483 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6010551.3522 | 2120281.1845 | 37.8024825054705 | -122.407669920622 | (37.8024825054705, -122.407669920622) | |||
| 151493 | 151493 | 143221 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 55 BELLAIR PL | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010035.1575 | 2121183.5062 | 37.804931148055395 | -122.409519938744 | (37.8049311480554, -122.409519938744) | |||
| 154788 | 154788 | 234842 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 141 Albion St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005925.78637 | 2106423.26838 | 37.7641720581045 | -122.422691323269 | (37.7641720581045, -122.422691323269) | |||
| 158999 | 158999 | 186404 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1801 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984797.7578 | 2102308.2226 | 37.7516586088355 | -122.495462490222 | (37.7516586088355, -122.495462490222) | |||
| 163057 | 163057 | 244931 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005260.1713 | 2110078.6254 | 37.7741712147751 | -122.42525362408001 | (37.7741712147751, -122.42525362408) | |||
| 164654 | 164654 | 186192 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1701 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984807.2585 | 2103565.1989 | 37.7551104753081 | -122.49552233563 | (37.7551104753081, -122.49552233563) | |||
| 165086 | 165086 | 139138 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1750 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003504.6488 | 2113964.2747 | 37.784740906999204 | -122.43160375043199 | (37.7847409069992, -122.431603750432) | |||
| 165116 | 165116 | 183136 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2315 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984823.4792 | 2099404.7372 | 37.7436879368421 | -122.49515945610901 | (37.7436879368421, -122.495159456109) | |||
| 176170 | 176170 | 139140 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1730 GEARY BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003394.9517 | 2113947.0548 | 37.784687407191 | -122.431982035882 | (37.784687407191, -122.431982035882) | |||
| 176407 | 176407 | 116714 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1400 BAKER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | |||
| 178190 | 178190 | 138934 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 640 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004774.0843 | 2110917.8533 | 37.7764480564968 | -122.426994870545 | (37.7764480564968, -122.426994870545) | |||
| 179337 | 179337 | 32788 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1668 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 11 | Permit Number 37154 | 5999777.7569 | 2110913.119 | 37.7761512712335 | -122.444278185514 | (37.7761512712335, -122.444278185514) | |
| 180945 | 180945 | 143094 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 483 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6010536.1149 | 2120279.3375 | 37.802476581095796 | -122.407722519182 | (37.8024765810958, -122.407722519182) | |||
| 182851 | 182851 | 142457 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 609 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999648.193 | 2110601.5269 | 37.7752883260479 | -122.444703978856 | (37.7752883260479, -122.444703978856) | |||
| 183905 | 183905 | 187068 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2600 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985184.8913 | 2096895.1448 | 37.736818423021205 | -122.493724907332 | (37.7368184230212, -122.493724907332) | |||
| 184454 | 184454 | 186104 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1901 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984870.6903 | 2101670.318 | 37.749911368138 | -122.49516324816003 | (37.749911368138, -122.49516324816) | |||
| 185383 | 185383 | 143219 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 55 BELLAIR PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010028.7855 | 2121230.0223 | 37.805058512663 | -122.409545274895 | (37.805058512663, -122.409545274895) | |||
| 185391 | 185391 | 69306 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1518 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | 1 | Permit Number 33385 | 5986858.656 | 2104895.6313 | 37.7588833876571 | -122.48852587956199 | (37.7588833876571, -122.488525879562) | |
| 185717 | 185717 | 200093 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2220 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014746.9609 | 2092794.4540000001 | 37.7272439208635 | -122.39122843279699 | (37.7272439208635, -122.391228432797) | |||
| 187690 | 187690 | 141703 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 116 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5996565.9306 | 2112209.0509 | 37.7795257936095 | -122.45548237999901 | (37.7795257936095, -122.455482379999) |
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");