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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
98270 | 98270 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | ||||
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) | ||||
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) | ||||
13290 | 13290 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006264.0 | 2119500.0 | 37.8000966404513 | -122.42245076966002 | (37.8000966404513, -122.42245076966) | ||||
71923 | 71923 | 183061 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2595 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983026.5279 | 2097492.8315 | 37.7383329997375 | -122.50123139183 | (37.7383329997375, -122.50123139183) | |||
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) | |||
49901 | 49901 | 187069 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2600 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985177.211 | 2096899.8078 | 37.7368307770453 | -122.49375180463001 | (37.7368307770453, -122.49375180463) | |||
54294 | 54294 | 187072 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2600 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985184.617000001 | 2096917.4415 | 37.7368796277559 | -122.493727498225 | (37.7368796277559, -122.493727498225) | |||
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) | |||
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) | |||
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) | |||
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) | |||
77026 | 77026 | 200233 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2897 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014759.7839 | 2089478.3596 | 37.718139294663 | -122.390952437444 | (37.718139294663, -122.390952437444) | |||
4157 | 4157 | 216804 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 297 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:14:00 PM | 3 | Width 2ft | 5994075.3134 | 2088701.73413 | 37.7148374215779 | -122.462392942697 | (37.7148374215779, -122.462392942697) | ||
84422 | 84422 | 107419 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 5 | 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) | ||
85088 | 85088 | 107418 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 4 | 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) | ||
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) | ||
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) | ||
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) | ||
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) | ||||
4229 | 4229 | 252890 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 301x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:50:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
4261 | 4261 | 252888 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 301x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:03:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
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) | ||
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) | |||
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) | |
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) | ||
93096 | 93096 | 114666 | Private 5 | Podocarpus gracilor :: Fern Pine 13 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.41742663990699 | (37.7355258779344, -122.417426639907) | |||
4513 | 4513 | 69411 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 400 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2017 12:00:00 PM | 3 | Permit Number 33516 | 6002017.91695 | 2087759.8378400002 | 37.712705354746106 | -122.43487271052601 | (37.7127053547461, -122.434872710526) | |
80684 | 80684 | 120653 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 4000x 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003791.0 | 2101344.0 | 37.750104917900295 | -122.42971263777001 | (37.7501049179003, -122.42971263777) | |||
92645 | 92645 | 120652 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 4000x 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003791.0 | 2101344.0 | 37.750104917900295 | -122.42971263777001 | (37.7501049179003, -122.42971263777) | |||
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) | ||||
93720 | 93720 | 106927 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 13 | 4150 24th St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1.5X1.5 | Permit Number 772519 | 6002207.56819 | 2101805.30097 | 37.7512817512061 | -122.435221219626 | (37.7512817512061, -122.435221219626) | ||||
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) | ||
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) | ||
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) | ||||
85566 | 85566 | 63398 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/2015 12:00:00 AM | 24 | 3x3 | Permit Number 770790 | 6001413.63019954 | 2104052.61523798 | 37.757407217509495 | -122.43812770874399 | (37.7574072175095, -122.438127708744) |
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) | |
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) | |||
30906 | 30906 | 212833 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 468 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996396.78511 | 2096388.5906 | 37.7360771087699 | -122.454924099162 | (37.7360771087699, -122.454924099162) | |||
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) | |||
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) | |||
24939 | 24939 | 143093 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 487 Greenwich St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 6010518.569 | 2120277.0289 | 37.8024692600192 | -122.407783074103 | (37.8024692600192, -122.407783074103) | |||
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) | |||
9792 | 9792 | 159358 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 49 Naglee Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998584.62871 | 2087583.8857099998 | 37.712026700246 | -122.446726546692 | (37.712026700246, -122.446726546692) | |
66718 | 66718 | 143220 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 55 BELLAIR PL | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010031.3343 | 2121212.8177 | 37.8050114159252 | -122.409535239424 | (37.8050114159252, -122.409535239424) | |||
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) | |||
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) | |||
5242 | 5242 | 243740 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 550 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 776473 | 6003047.0557699995 | 2096015.8076799999 | 37.7354327831918 | -122.431904827248 | (37.7354327831918, -122.431904827248) | |
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) | ||
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) |
31436 | 31436 | 91401 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 567 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52097 | 6010823.9616 | 2118928.6951 | 37.7987841568388 | -122.406631185904 | (37.7987841568388, -122.406631185904) | |
71416 | 71416 | 91402 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 567 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52097 | 6010859.945 | 2118931.7794 | 37.7987946386979 | -122.40650688851801 | (37.7987946386979, -122.406506888518) | |
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) | |
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) | |||
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) | |||||
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) | |||
21131 | 21131 | 16956 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 673 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/1992 12:00:00 AM | 6 | 3X3 | 6003823.5744 | 2110036.1086 | 37.773973209785 | -122.43022003270201 | (37.773973209785, -122.430220032702) | ||
2232 | 2232 | 122753 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 693 Vermont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 6011277.810190001 | 2105311.62173 | 37.7614202297665 | -122.404101873421 | (37.7614202297665, -122.404101873421) | |||
4055 | 4055 | 251746 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 700 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:33:00 AM | 3 | 3x3 | 6002943.0 | 2087289.0 | 37.711465016812205 | -122.431641737098 | (37.7114650168122, -122.431641737098) | ||
87384 | 87384 | 86799 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 71 Miguel St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 49752 | 6003860.0 | 2097292.0 | 37.738982969029706 | -122.429185143196 | (37.7389829690297, -122.429185143196) | ||
20659 | 20659 | 53568 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | 6x7 | Permit Number 774472 | 6002289.86675011 | 2108835.21130526 | 37.7705888548661 | -122.43543945468201 | (37.7705888548661, -122.435439454682) | |
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) | ||
101375 | 101375 | 115332 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777441 | 5995305.9 | 2110591.8 | 37.7750128688555 | -122.459724160308 | (37.7750128688555, -122.459724160308) | ||
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) |
98608 | 98608 | 115230 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775535 | 5987210.9 | 2110869.6 | 37.775306795851 | -122.487746566566 | (37.775306795851, -122.487746566566) | |||
4627 | 4627 | 160610 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2017 04:01:00 PM | 3 | Width 0ft | 6002805.02204 | 2089330.87742 | 37.717063742780496 | -122.432264357312 | (37.7170637427805, -122.432264357312) | ||
4644 | 4644 | 160608 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 03:37:00 PM | 3 | Width 0ft | 6002772.883169999 | 2089351.94517 | 37.717119767831505 | -122.43237694973499 | (37.7171197678315, -122.432376949735) | |
4671 | 4671 | 160609 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2017 03:56:00 PM | 3 | Width 0ft | 6002789.45595 | 2089340.3546099998 | 37.71708888243629 | -122.432318838255 | (37.7170888824363, -122.432318838255) | ||
4686 | 4686 | 160611 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 750X France Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2017 04:11:00 PM | 3 | Width 0ft | 6002821.1864599995 | 2089320.8920099998 | 37.717037241564 | -122.432207771993 | (37.717037241564, -122.432207771993) | |
79733 | 79733 | 46187 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | 3x3 | Permit Number 770441 | 5997143.11969578 | 2107935.34407244 | 37.767824406441704 | -122.453177040971 | (37.7678244064417, -122.453177040971) | |
79358 | 79358 | 108613 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 859 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774597 | 6007577.26936 | 2095354.40031 | 37.7338724793659 | -122.416195309142 | (37.7338724793659, -122.416195309142) | |
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) | ||
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) | |||
84341 | 84341 | 107502 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 998 CHESTNUT ST | 3 | 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) | ||
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) |
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");