Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||
| 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) | |||||
| 26201 | 26201 | 212832 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1201 Funston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5992025.01275 | 2107217.63828 | 37.765559111278 | -122.47082751866999 | (37.765559111278, -122.47082751867) | |||
| 26751 | 26751 | 186196 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1701 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984756.9045 | 2103549.1285 | 37.7550634017723 | -122.495695286455 | (37.7550634017723, -122.495695286455) | |||
| 27653 | 27653 | 186191 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1701 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984752.6191 | 2103570.02 | 37.7551205130891 | -122.49571164730499 | (37.7551205130891, -122.495711647305) | |||
| 38506 | 38506 | 185519 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2201 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984858.6139 | 2100160.4269 | 37.7457649124522 | -122.495093683302 | (37.7457649124522, -122.495093683302) | |||
| 39960 | 39960 | 186401 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1801 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984842.4701 | 2102334.3496 | 37.7517329643959 | -122.495309798203 | (37.7517329643959, -122.495309798203) | |||
| 40595 | 40595 | 185530 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2201 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984911.0151 | 2100096.2189 | 37.7455916823633 | -122.49490775682699 | (37.7455916823633, -122.494907756827) | |||
| 41633 | 41633 | 185634 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2100 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985067.4201 | 2100372.3359 | 37.746358979048296 | -122.49438729000201 | (37.7463589790483, -122.494387290002) | |||
| 47763 | 47763 | 186107 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1901 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984859.3561 | 2101642.6122 | 37.7498346320289 | -122.495200398918 | (37.7498346320289, -122.495200398918) | |||
| 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) | |||
| 68940 | 68940 | 234843 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 141 Albion St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005925.31783 | 2106426.47013 | 37.764180822918796 | -122.422693171361 | (37.7641808229188, -122.422693171361) | |||
| 72838 | 72838 | 234841 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 141 Albion St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6005926.24374 | 2106419.53529 | 37.76416183372571 | -122.42268947605 | (37.7641618337257, -122.42268947605) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 20 | 20 | 251179 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 21 | 21 | 251178 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 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) | ||
| 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) | ||
| 85183 | 85183 | 122398 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 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) | ||||
| 98582 | 98582 | 122401 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 3999 | 3999 | 181035 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 170 Rolph St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:20:00 PM | 3 | Width 4ft | 6000927.8060099995 | 2088408.3131900001 | 37.7144239699579 | -122.438686909772 | (37.7144239699579, -122.438686909772) | ||
| 4083 | 4083 | 181036 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 170 Rolph St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 04:16:00 PM | 3 | Width 4ft | 6000944.46471 | 2088397.62402 | 37.7143955675655 | -122.438628565353 | (37.7143955675655, -122.438628565353) | ||
| 4284 | 4284 | 175543 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 187 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:37:00 AM | 3 | Width 6ft | 6001178.343719999 | 2087386.3168 | 37.7116320444605 | -122.43774780171302 | (37.7116320444605, -122.437747801713) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 3237 | 3237 | 139408 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 1500 GEARY BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1999 12:00:00 AM | 3 | Width 0ft | 6004238.7982 | 2114043.3981 | 37.7849997446788 | -122.429069479335 | (37.7849997446788, -122.429069479335) | ||
| 3250 | 3250 | 139411 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 1500 GEARY BLVD | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6004146.842 | 2114032.4365 | 37.784964441153 | -122.429386836551 | (37.784964441153, -122.429386836551) | |||
| 3994 | 3994 | 159208 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 210 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:54:00 AM | 3 | Width 0ft | 5998556.96811 | 2088452.2606799998 | 37.714409480083496 | -122.446884596259 | (37.7144094800835, -122.446884596259) | ||
| 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) | ||
| 4078 | 4078 | 253099 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 210 Foote Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 08:59:00 AM | 3 | Width 0ft | 5998556.96811 | 2088452.2606799998 | 37.714409480083496 | -122.446884596259 | (37.7144094800835, -122.446884596259) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||||
| 19097 | 19097 | 10252 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 124 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005490.6368 | 2109629.255 | 37.7729503696302 | -122.424424432873 | (37.7729503696302, -122.424424432873) | |||
| 19318 | 19318 | 10251 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 120 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005509.0088 | 2109632.4226 | 37.7729601045446 | -122.42436110718201 | (37.7729601045446, -122.424361107182) | |||
| 19691 | 19691 | 108972 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 10 Dearborn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772927 | 6005770.7 | 2106026.5 | 37.7630738748169 | -122.42319951773399 | (37.7630738748169, -122.423199517734) |
| 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) | |
| 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) | ||
| 24689 | 24689 | 244218 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1949 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997251.0447 | 2108771.6628 | 37.7701269078181 | -122.452864114834 | (37.7701269078181, -122.452864114834) | |||
| 27591 | 27591 | 139137 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1750 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003531.4353 | 2113968.7391 | 37.7847546833549 | -122.431511396859 | (37.7847546833549, -122.431511396859) | |||
| 28737 | 28737 | 92295 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1372 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52740 | 5989296.944 | 2106014.5102 | 37.762097501928295 | -122.480175128724 | (37.7620975019283, -122.480175128724) |
| 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) | |||
| 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) | |
| 31901 | 31901 | 200087 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2260 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014672.5559 | 2092688.6734 | 37.7269493390436 | -122.391478260518 | (37.7269493390436, -122.391478260518) | |||
| 34640 | 34640 | 139142 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1730 GEARY BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003354.1342 | 2113941.3148 | 37.784669332502105 | -122.432122840709 | (37.7846693325021, -122.432122840709) | |||
| 35328 | 35328 | 200091 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2230 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014724.5498 | 2092764.8713 | 37.7271614489349 | -122.39130384140199 | (37.7271614489349, -122.391303841402) | |||
| 36043 | 36043 | 200090 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2250 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014714.6889 | 2092749.6317 | 37.7271190567752 | -122.391336865844 | (37.7271190567752, -122.391336865844) | |||
| 36445 | 36445 | 106365 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | ||
| 37888 | 37888 | 116710 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1400 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | |||
| 39799 | 39799 | 116709 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1400 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | |||
| 39842 | 39842 | 183135 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2315 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984823.141 | 2099420.9741 | 37.7437324991665 | -122.49516182260099 | (37.7437324991665, -122.495161822601) | |||
| 40066 | 40066 | 184721 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1630 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982537.7064 | 2103994.8819 | 37.7561571061486 | -122.503402789254 | (37.7561571061486, -122.503402789254) | |||
| 40453 | 40453 | 92325 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1451 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52757 | 5987103.8402 | 2105396.114 | 37.760271879713294 | -122.487714698332 | (37.7602718797133, -122.487714698332) |
| 41813 | 41813 | 112844 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2200 KEITH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014766.0 | 2092880.0 | 37.7274798696224 | -122.391168591224 | (37.7274798696224, -122.391168591224) | ||||
| 42113 | 42113 | 200095 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2220 Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014767.5792 | 2092826.7261 | 37.727333677806 | -122.391159409685 | (37.727333677806, -122.391159409685) | |||
| 43092 | 43092 | 31665 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1813 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 3 | Permit Number 35173 | 6006528.4802 | 2117109.7376 | 37.7935484974802 | -122.42136572658 | (37.7935484974802, -122.42136572658) | ||
| 45002 | 45002 | 52035 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1451 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2005 12:00:00 AM | 1 | Permit Number 48247 | 6000914.194 | 2110330.7938 | 37.774617124205 | -122.44030518181002 | (37.774617124205, -122.44030518181) | ||
| 48688 | 48688 | 37070 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1382 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 6 | Permit Number 39673 | 5982789.8395 | 2105718.3045 | 37.760903956322295 | -122.50265840320101 | (37.7609039563223, -122.502658403201) | |
| 50529 | 50529 | 37080 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 1224 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 8 | Permit Number 39681 | 5982132.793 | 2106739.5272 | 37.763669308222795 | -122.505006479579 | (37.7636693082228, -122.505006479579) | |
| 52707 | 52707 | 200089 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2260 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014698.5528 | 2092729.0135 | 37.7270615477685 | -122.39139120786301 | (37.7270615477685, -122.391391207863) | |||
| 55490 | 55490 | 139136 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1825 POST ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003489.3422 | 2114155.6067 | 37.785265388892 | -122.431670371199 | (37.785265388892, -122.431670371199) | |||
| 59017 | 59017 | 200092 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2220 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014736.2036 | 2092780.1109 | 37.727203940586904 | -122.391264618831 | (37.7272039405869, -122.391264618831) | |||
| 59641 | 59641 | 182398 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1539 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988985.656 | 2104841.7909999997 | 37.7588594394433 | -122.481165865952 | (37.7588594394433, -122.481165865952) | |||
| 63369 | 63369 | 73417 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1501 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982464.5527 | 2104844.8944 | 37.7584866992539 | -122.503718723326 | (37.7584866992539, -122.503718723326) | ||
| 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) | |||
| 69400 | 69400 | 140757 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2303 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000331.3271 | 2112998.0313 | 37.7819074748635 | -122.442512966292 | (37.7819074748635, -122.442512966292) | |||
| 69983 | 69983 | 200088 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 2260 Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014685.1061 | 2092710.1881 | 37.72700911067479 | -122.39143637779101 | (37.7270091106748, -122.391436377791) | |||
| 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) | |
| 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) |
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");