Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3466 | 3466 | 241174 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 315 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 778328 | 6003586.53553 | 2106468.03188 | 37.764162711469105 | -122.430785309798 | (37.7641627114691, -122.430785309798) | ||
| 13705 | 13705 | 59528 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 286 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/1981 12:00:00 AM | 6 | 3x3 | Permit Number 18910 | 6010887.1653 | 2111573.2609900003 | 37.7785914236007 | -122.40589406217899 | (37.7785914236007, -122.405894062179) | |
| 14936 | 14936 | 49458 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 548 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013268.6937 | 2111162.24572 | 37.7775957715643 | -122.39762655054899 | (37.7775957715643, -122.397626550549) | |
| 15122 | 15122 | 28499 | DPW Maintained 3 | Tilia cordata :: Littleleaf Linden 208 | 270 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6010842.7805 | 2111615.69591 | 37.7787054576155 | -122.40605059727501 | (37.7787054576155, -122.406050597275) | |||
| 16113 | 16113 | 49455 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 548 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013246.336490001 | 2111139.83952 | 37.7775330042846 | -122.39770232023001 | (37.7775330042846, -122.39770232023) | |
| 27781 | 27781 | 197930 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 276 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014937.43234 | 2115453.8839 | 37.7894724145659 | -122.39215398704201 | (37.7894724145659, -122.392153987042) | |||
| 31318 | 31318 | 197934 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 218 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6014577.154569999 | 2115321.46001 | 37.7890887988504 | -122.393391247314 | (37.7890887988504, -122.393391247314) | |||
| 31568 | 31568 | 197932 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 218 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6014511.51685 | 2115383.38885 | 37.7892551941278 | -122.39362268333599 | (37.7892551941278, -122.393622683336) | |||
| 33093 | 33093 | 197950 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 375 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015122.069130001 | 2114845.42683 | 37.78781198099001 | -122.39147260398998 | (37.78781198099, -122.39147260399) | |||
| 33149 | 33149 | 250930 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 263 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987104.7797300005 | 2114208.46331 | 37.7844681757127 | -122.488359085215 | (37.7844681757127, -122.488359085215) | |||
| 34187 | 34187 | 123142 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 588 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5992875.985230001 | 2111469.09089 | 37.7772816395031 | -122.468193521633 | (37.7772816395031, -122.468193521633) | |||
| 34545 | 34545 | 197968 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 153 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010849.47884 | 2113039.65001 | 37.7826156766079 | -122.406127771681 | (37.7826156766079, -122.406127771681) | |||
| 34608 | 34608 | 197940 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 351 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6015409.43942 | 2115059.04086 | 37.788414462002294 | -122.39049328005 | (37.7884144620023, -122.39049328005) | |||
| 34863 | 34863 | 124050 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 663 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5992519.13358 | 2110941.9567 | 37.7758136556158 | -122.46938959611799 | (37.7758136556158, -122.469389596118) | |||
| 36110 | 36110 | 197961 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014857.78399 | 2115129.52624 | 37.7885773804879 | -122.392406867389 | (37.7885773804879, -122.392406867389) | |||
| 38157 | 38157 | 197958 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014908.62801 | 2115077.8461599997 | 37.7884383021313 | -122.392227337523 | (37.7884383021313, -122.392227337523) | |||
| 39054 | 39054 | 241166 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 2501 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010275.23752 | 2105021.26338 | 37.760566902651206 | -122.40754889926501 | (37.7605669026512, -122.407548899265) | |||
| 39284 | 39284 | 197956 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014936.721390001 | 2115049.06267 | 37.7883608291328 | -122.392128124328 | (37.7883608291328, -122.392128124328) | |||
| 41599 | 41599 | 197948 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 375 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015157.51241 | 2114808.67556 | 37.78771303756629 | -122.391347405751 | (37.7877130375663, -122.391347405751) | |||
| 42512 | 42512 | 241168 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 3387 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007165.54985 | 2101454.26646 | 37.75059819206479 | -122.418051039151 | (37.7505981920648, -122.418051039151) | |||
| 43007 | 43007 | 197935 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 220 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6014614.74747 | 2115277.87841 | 37.7889712224 | -122.393258128754 | (37.7889712224, -122.393258128754) | |||
| 43428 | 43428 | 197966 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 153 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010894.68049 | 2112991.13579 | 37.782484996132105 | -122.405967973868 | (37.7824849961321, -122.405967973868) | |||
| 44051 | 44051 | 112148 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 101X 05TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6010794.0 | 2113100.0 | 37.782778280213 | -122.40632395916501 | (37.782778280213, -122.406323959165) | |||
| 44851 | 44851 | 197973 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 90 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011498.91524 | 2113552.62708 | 37.7840604950255 | -122.403917097798 | (37.7840604950255, -122.403917097798) | |||
| 45326 | 45326 | 197957 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014920.6101 | 2115062.64622 | 37.7883972318904 | -122.39218481759899 | (37.7883972318904, -122.392184817599) | |||
| 48601 | 48601 | 69332 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 160 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 11 | Permit Number 33415 | 6013130.581119999 | 2106316.68773 | 37.7642832664742 | -122.397764366249 | (37.7642832664742, -122.397764366249) | ||
| 49045 | 49045 | 197974 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 248 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010760.66114 | 2111705.859 | 37.7789484310553 | -122.406341036019 | (37.7789484310553, -122.406341036019) | |||
| 49798 | 49798 | 241173 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 344 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003615.63748 | 2108670.2854400002 | 37.7702112142959 | -122.430841829505 | (37.7702112142959, -122.430841829505) | |||
| 50457 | 50457 | 197942 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 351 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6015382.55256 | 2115087.30392 | 37.7884905743282 | -122.390588280823 | (37.7884905743282, -122.390588280823) | |||
| 52469 | 52469 | 197947 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 375 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015181.90784 | 2114782.68657 | 37.7876430316507 | -122.39126118415001 | (37.7876430316507, -122.39126118415) | |||
| 53906 | 53906 | 197954 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014967.3458 | 2115010.36938 | 37.7882562865359 | -122.39201946105499 | (37.7882562865359, -122.392019461055) | |||
| 54488 | 54488 | 246997 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 37 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004899.11495 | 2101036.5235 | 37.7493233437145 | -122.42585882631799 | (37.7493233437145, -122.425858826318) | |||
| 55320 | 55320 | 197927 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 274 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014884.10651 | 2115509.17799 | 37.7896212784354 | -122.39234235902201 | (37.7896212784354, -122.392342359022) | |||
| 55348 | 55348 | 197960 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014878.1389999995 | 2115106.33815 | 37.788514841628206 | -122.392334819105 | (37.7885148416282, -122.392334819105) | |||
| 55823 | 55823 | 197928 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 274 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014902.20963 | 2115489.69757 | 37.7895687949157 | -122.392278360564 | (37.7895687949157, -122.392278360564) | |||
| 58645 | 58645 | 51401 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 423 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774507 | 6011161.375580001 | 2112281.69407 | 37.7805519474533 | -122.404995352556 | (37.7805519474533, -122.404995352556) | |
| 59166 | 59166 | 215409 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993712.25346 | 2104885.1954900003 | 37.7592522638043 | -122.464822377549 | (37.7592522638043, -122.464822377549) | |||
| 59365 | 59365 | 197959 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 355 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014895.935880001 | 2115091.70056 | 37.788475638387105 | -122.39227221999701 | (37.7884756383871, -122.392272219997) | |||
| 60254 | 60254 | 197926 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 274 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014867.69164 | 2115525.84421 | 37.7896661285247 | -122.392400319429 | (37.7896661285247, -122.392400319429) | |||
| 63777 | 63777 | 197965 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 542 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013312.52382 | 2111204.9789400003 | 37.7777155477834 | -122.39747792406601 | (37.7777155477834, -122.397477924066) | |||
| 64808 | 64808 | 197951 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 375 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015100.083 | 2114872.3871 | 37.7878847873904 | -122.39155055811399 | (37.7878847873904, -122.391550558114) | |||
| 65087 | 65087 | 241171 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 29 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000270.28212 | 2106683.67196 | 37.764566359572 | -122.44227072162701 | (37.764566359572, -122.442270721627) | |||
| 70167 | 70167 | 241169 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 148 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6001996.12146 | 2096541.9347599999 | 37.7368177733266 | -122.435575922793 | (37.7368177733266, -122.435575922793) | |||
| 70421 | 70421 | 241175 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 3387 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007208.84788 | 2101457.6836900003 | 37.75061001186071 | -122.417901552934 | (37.7506100118607, -122.417901552934) | |||
| 70447 | 70447 | 197931 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 218 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6014498.282459999 | 2115400.4344099998 | 37.7893012619026 | -122.393669666621 | (37.7893012619026, -122.393669666621) | |||
| 70471 | 70471 | 197949 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 375 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015139.49005 | 2114827.68285 | 37.7877642269846 | -122.391411089446 | (37.7877642269846, -122.391411089446) | |||
| 70735 | 70735 | 241164 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 2720 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009338.64709 | 2106411.92088 | 37.7643328604997 | -122.41088637242599 | (37.7643328604997, -122.410886372426) | |||
| 75942 | 75942 | 241177 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 22 Temple St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999945.77757 | 2105873.29085 | 37.7623227543165 | -122.443334880405 | (37.7623227543165, -122.443334880405) | |||
| 77247 | 77247 | 197925 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 274 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6014850.28645 | 2115545.31088 | 37.7897186129805 | -122.39246190230601 | (37.7897186129805, -122.392461902306) | |||
| 79177 | 79177 | 102940 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 115 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769103 | 6000989.0 | 2105709.0 | 37.7619310864697 | -122.43971499375799 | (37.7619310864697, -122.439714993758) | |||
| 81075 | 81075 | 121531 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 81206 | 81206 | 112149 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 101X 05TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6010794.0 | 2113100.0 | 37.782778280213 | -122.40632395916501 | (37.782778280213, -122.406323959165) | |||
| 81493 | 81493 | 92266 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 29 Allston Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52717 | 5994298.9 | 2098344.0 | 37.741325608362395 | -122.46231906190701 | (37.7413256083624, -122.462319061907) | ||
| 81583 | 81583 | 83269 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 2501 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52646 | 6010408.33356272 | 2105026.32367828 | 37.7605882462434 | -122.40708893520299 | (37.7605882462434, -122.407088935203) | ||
| 82469 | 82469 | 112150 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 101X 05TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6010794.0 | 2113100.0 | 37.782778280213 | -122.40632395916501 | (37.782778280213, -122.406323959165) | |||
| 83676 | 83676 | 121526 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 83921 | 83921 | 50054 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 646 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51273 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341001 | (37.7605408596837, -122.42837316341) | ||
| 91335 | 91335 | 91212 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 2901 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52044 | 6007111.0 | 2101465.0 | 37.750624593534496 | -122.41824043826999 | (37.7506245935345, -122.41824043827) | ||
| 91514 | 91514 | 67922 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 17 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776405 | 6003746.91064441 | 2095538.27676938 | 37.7341612413777 | -122.429451123322 | (37.7341612413777, -122.429451123322) | |
| 91964 | 91964 | 121522 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 93026 | 93026 | 104163 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 2127 12TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 76 | 4x3 | Permit Number 770670 | 5992542.0 | 2100965.0 | 37.748420883115294 | -122.468584409749 | (37.7484208831153, -122.468584409749) | ||
| 94327 | 94327 | 104739 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 200X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | On the 23rd St Side of property | 6005413.0 | 2102541.0 | 37.753483315938 | -122.42418878244499 | (37.753483315938, -122.424188782445) | ||||
| 100309 | 100309 | 52291 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 37 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48450 | 6004924.5040582 | 2101031.6740118 | 37.749311462905396 | -122.42577068505899 | (37.7493114629054, -122.425770685059) | ||
| 101224 | 101224 | 121527 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 101696 | 101696 | 121525 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | |||
| 101714 | 101714 | 121533 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 103221 | 103221 | 84454 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 2501 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52646 | 6010408.33356272 | 2105026.32367828 | 37.7605882462434 | -122.40708893520299 | (37.7605882462434, -122.407088935203) | ||
| 105705 | 105705 | 34776 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 1148 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 4x4 | Permit Number 38417 | 6008035.00461404 | 2101235.83901924 | 37.750047336859105 | -122.41502892690501 | (37.7500473368591, -122.415028926905) | ||
| 109417 | 109417 | 81524 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 1643 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53916 | 5993372.97126564 | 2104303.07947151 | 37.7576343572278 | -122.46595347138201 | (37.7576343572278, -122.465953471382) | |
| 111848 | 111848 | 108470 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 663 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773783 | 5992531.7071 | 2110944.78333 | 37.77582214338371 | -122.469346307299 | (37.7758221433837, -122.469346307299) | |||
| 112265 | 112265 | 104738 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 200X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree on the 23rd St side of property | 6005413.0 | 2102541.0 | 37.753483315938 | -122.42418878244499 | (37.753483315938, -122.424188782445) | ||||
| 112918 | 112918 | 96055 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 1358 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767683 | 6009525.0 | 2101259.0 | 37.750194548793104 | -122.40987805466801 | (37.7501945487931, -122.409878054668) | |
| 116384 | 116384 | 91211 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 2901 Mission St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52044 | 6007111.0 | 2101465.0 | 37.750624593534496 | -122.41824043826999 | (37.7506245935345, -122.41824043827) | |||
| 116751 | 116751 | 112882 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | 5994670.4 | 2110971.2 | 37.7760180351325 | -122.46194999449 | (37.7760180351325, -122.46194999449) | ||||
| 121482 | 121482 | 121532 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 121865 | 121865 | 121530 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 126000 | 126000 | 104740 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 200X Fair Oaks St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | On the 23rd side of property. | 6005413.0 | 2102541.0 | 37.753483315938 | -122.42418878244499 | (37.753483315938, -122.424188782445) | |||||
| 126691 | 126691 | 121528 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 126728 | 126728 | 83987 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 619 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52667 | 6007916.08016795 | 2104321.00982212 | 37.758511831079296 | -122.415658591374 | (37.7585118310793, -122.415658591374) | ||
| 127058 | 127058 | 96152 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767787 | 6008219.0 | 2096805.0 | 37.737891573023205 | -122.414079234094 | (37.7378915730232, -122.414079234094) | |
| 127155 | 127155 | 121523 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 128462 | 128462 | 94158 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53537 | 5993734.5 | 2104887.1 | 37.7592587757026 | -122.464745577182 | (37.7592587757026, -122.464745577182) | ||
| 129032 | 129032 | 109420 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 148 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774923 | 6001986.6 | 2096551.2 | 37.736842672732394 | -122.435609505262 | (37.7368426727324, -122.435609505262) |
| 129911 | 129911 | 123341 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994696.02985 | 2110963.62248 | 37.77599870477871 | -122.461860785147 | (37.7759987047787, -122.461860785147) | |||
| 133204 | 133204 | 197952 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 375 Beale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015071.9617800005 | 2114899.8114 | 37.7879585273121 | -122.39164977132499 | (37.7879585273121, -122.391649771325) | |||
| 134292 | 134292 | 47913 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 1025 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 7 | Permit Number 45650 | 6001905.584 | 2112009.098 | 37.7792817219988 | -122.43699595246099 | (37.7792817219988, -122.436995952461) | |
| 134751 | 134751 | 197939 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 351 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6015423.8989699995 | 2115043.66303 | 37.78837304012279 | -122.39044217697901 | (37.7883730401228, -122.390442176979) | |||
| 137801 | 137801 | 136738 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 48 Osgood Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6011887.1157599995 | 2118514.3122900003 | 37.7977057852396 | -122.402923146385 | (37.7977057852396, -122.402923146385) | |||
| 139116 | 139116 | 112147 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 101X 05TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6010794.0 | 2113100.0 | 37.782778280213 | -122.40632395916501 | (37.782778280213, -122.406323959165) | |||
| 139663 | 139663 | 84157 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 607 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52665 | 6007912.35762405 | 2104388.06639727 | 37.7586957437969 | -122.415676213523 | (37.7586957437969, -122.415676213523) | ||
| 142591 | 142591 | 95690 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 128 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767441 | 6000854.0 | 2105632.0 | 37.7617119784366 | -122.440176382755 | (37.7617119784366, -122.440176382755) | |
| 144469 | 144469 | 121529 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 333 Beale St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6015114.0 | 2115064.0 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | ||||
| 145213 | 145213 | 97026 | Property Tree 7 | Tilia cordata :: Littleleaf Linden 208 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145478 | 145478 | 121524 | Planning Code 138.1 required 4 | Tilia cordata :: Littleleaf Linden 208 | 280 Beale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x10 | 6014751.0 | 2115177.0 | 37.788701802156204 | -122.392779649259 | (37.7887018021562, -122.392779649259) | ||||
| 145869 | 145869 | 52304 | Permitted Site 1 | Tilia cordata :: Littleleaf Linden 208 | 180DANVERS Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48464 | 6000126.86103947 | 2104901.42011078 | 37.7596645617882 | -122.442638797859 | (37.7596645617882, -122.442638797859) | ||
| 146938 | 146938 | 215410 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 1955 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993444.9434400005 | 2102189.18609 | 37.751834303014796 | -122.465550997481 | (37.7518343030148, -122.465550997481) | |||
| 147122 | 147122 | 197975 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 1808 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013682.66617 | 2094773.96113 | 37.7326201220065 | -122.395046310152 | (37.7326201220065, -122.395046310152) | |||
| 148800 | 148800 | 197929 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 274 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014918.2545300005 | 2115471.99632 | 37.789521082269104 | -122.392221607957 | (37.7895210822691, -122.392221607957) | |||
| 149201 | 149201 | 197922 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 90 Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013927.10424 | 2116016.68419 | 37.7909615848495 | -122.395689086178 | (37.7909615848495, -122.395689086178) | |||
| 150222 | 150222 | 197936 | Undocumented 2 | Tilia cordata :: Littleleaf Linden 208 | 220 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6014628.26894 | 2115262.5797099997 | 37.7889299668815 | -122.393210274953 | (37.7889299668815, -122.393210274953) |
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");