trees
155 rows where qSpecies_id = 12 sorted by qSpecies_id descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15 | 264849 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 15 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010381 | 2094903 | 37.7327902820185 | -122.40647012075 | (37.7327902820185, -122.40647012075) | 10 | 3 | 7 | 309 | 28 | |||
28 | 264848 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 15 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010381 | 2094903 | 37.7327902820185 | -122.40647012075 | (37.7327902820185, -122.40647012075) | 10 | 3 | 7 | 309 | 28 | |||
1320 | 124050 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 663 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992519.13358 | 2110941.9567 | 37.7758136556158 | -122.469389596118 | (37.7758136556158, -122.469389596118) | 11 | 6 | 2 | 54 | 11 | |||
2213 | 261044 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
3511 | 254247 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2018 12:00:00 AM | 3 | |||||||||||||
4957 | 254245 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2018 12:00:00 AM | 3 | |||||||||||||
5568 | 250930 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 263 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5987104.77973 | 2114208.46331 | 37.7844681757127 | -122.488359085215 | (37.7844681757127, -122.488359085215) | 11 | 6 | 1 | 55 | 33 | |||
6150 | 259078 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
6884 | 259077 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
9433 | 261043 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||||
10107 | 259081 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1001 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
11266 | 259076 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2019 12:00:00 AM | 3 | |||||||||||||
11832 | 197944 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015356.38098 | 2115113.47831 | 37.7885609912507 | -122.390680660994 | (37.7885609912507, -122.390680660994) | 6 | 2 | 9 | 28855 | 6 | |||
12795 | 259079 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1000 Visitacion Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
13327 | 197932 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6014511.51685 | 2115383.38885 | 37.7892551941278 | -122.393622683336 | (37.7892551941278, -122.393622683336) | 6 | 2 | 9 | 28855 | 6 | |||
13771 | 15042 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1024 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2008 12:00:00 AM | 3 | 3X3 | 6015618.91517 | 2096257.6222 | 37.7368014371311 | -122.388455686999 | (37.7368014371311, -122.388455686999) | 10 | 3 | 8 | 58 | 1 | ||
14109 | 215410 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1955 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993444.94344 | 2102189.18609 | 37.7518343030148 | -122.465550997481 | (37.7518343030148, -122.465550997481) | 1 | 8 | 4 | 29491 | 12 | |||
16235 | 112148 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
16799 | 261042 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
17788 | 254246 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 100x Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2018 12:00:00 AM | 3 | |||||||||||||
19998 | 69332 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 160 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 11 | Permit Number 781107 | 6013130.58112 | 2106316.68773 | 37.7642832664742 | -122.397764366249 | (37.7642832664742, -122.397764366249) | 14 | 3 | 8 | 28856 | 29 | ||
20157 | 121528 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
21846 | 83987 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 619 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52667 | 6007916.08016795 | 2104321.00982212 | 37.7585118310793 | -122.415658591374 | (37.7585118310793, -122.415658591374) | 2 | 4 | 7 | 28859 | 19 | ||
21950 | 104740 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | On the 23rd side of property. | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | |||||
23049 | 96152 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767787 | 6008219 | 2096805 | 37.7378915730232 | -122.414079234094 | (37.7378915730232, -122.414079234094) | 2 | 7 | 7 | 28859 | 2 | |
24409 | 246997 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004899.11495 | 2101036.5235 | 37.7493233437145 | -122.425858826318 | (37.7493233437145, -122.425858826318) | 2 | 4 | 5 | 28862 | 22 | |||
25972 | 121523 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 280 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
28759 | 197973 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011498.91524 | 2113552.62708 | 37.7840604950255 | -122.403917097798 | (37.7840604950255, -122.403917097798) | 12 | 2 | 9 | 28853 | 34 | |||
28889 | 197972 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011477.0733 | 2113572.89989 | 37.7841149391088 | -122.403994090559 | (37.7841149391088, -122.403994090559) | 12 | 2 | 9 | 28853 | 34 | |||
32669 | 256769 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
32676 | 94158 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53537 | 5993734.5 | 2104887.1 | 37.7592587757026 | -122.464745577182 | (37.7592587757026, -122.464745577182) | 1 | 8 | 4 | 56 | 12 | ||
33696 | 49458 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 548 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013268.6937 | 2111162.24572 | 37.7775957715643 | -122.397626550549 | (37.7775957715643, -122.397626550549) | 6 | 2 | 9 | 28856 | 34 | |
37313 | 49455 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 548 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013246.33649 | 2111139.83952 | 37.7775330042846 | -122.39770232023 | (37.7775330042846, -122.39770232023) | 6 | 2 | 9 | 28856 | 34 | |
37623 | 241174 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 315 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 778328 | 6003586.53553 | 2106468.03188 | 37.7641627114691 | -122.430785309798 | (37.7641627114691, -122.430785309798) | 8 | 4 | 5 | 28862 | 3 | ||
37821 | 109420 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 148 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774923 | 6001986.6 | 2096551.2 | 37.7368426727324 | -122.435609505262 | (37.7368426727324, -122.435609505262) | 2 | 7 | 5 | 63 | 7 |
38450 | 197928 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014902.20963 | 2115489.69757 | 37.7895687949157 | -122.392278360564 | (37.7895687949157, -122.392278360564) | 6 | 2 | 9 | 28855 | 6 | |||
38525 | 197926 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014867.69164 | 2115525.84421 | 37.7896661285247 | -122.392400319429 | (37.7896661285247, -122.392400319429) | 6 | 2 | 9 | 28855 | 6 | |||
39209 | 197933 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014535.65426 | 2115358.35954 | 37.7891878106184 | -122.393537417717 | (37.7891878106184, -122.393537417717) | 6 | 2 | 9 | 28855 | 6 | |||
39316 | 102940 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 115 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769103 | 6000989 | 2105709 | 37.7619310864697 | -122.439714993758 | (37.7619310864697, -122.439714993758) | 15 | 5 | 5 | 28862 | 3 | |||
40138 | 121526 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
40312 | 197971 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011459.89889 | 2113592.30017 | 37.7841672481653 | -122.404054873931 | (37.7841672481653, -122.404054873931) | 12 | 2 | 9 | 28853 | 34 | |||
42209 | 112149 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
42435 | 197929 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 274 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014918.25453 | 2115471.99632 | 37.7895210822691 | -122.392221607957 | (37.7895210822691, -122.392221607957) | 6 | 2 | 9 | 28855 | 6 | |||
42591 | 197967 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010879.01966 | 2113009.66156 | 37.7825349876424 | -122.406023459311 | (37.7825349876424, -122.406023459311) | 12 | 2 | 9 | 28853 | 34 | |||
43435 | 197956 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014936.72139 | 2115049.06267 | 37.7883608291328 | -122.392128124328 | (37.7883608291328, -122.392128124328) | 6 | 2 | 9 | 28855 | 6 | |||
44644 | 197934 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6014577.15457 | 2115321.46001 | 37.7890887988504 | -122.393391247314 | (37.7890887988504, -122.393391247314) | 6 | 2 | 9 | 28855 | 6 | |||
45003 | 197963 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 530 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013370.97049 | 2111262.30601 | 37.7778762089677 | -122.397279756668 | (37.7778762089677, -122.397279756668) | 6 | 2 | 9 | 28856 | 34 | |||
45536 | 50054 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 646 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51273 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | ||
46251 | 197930 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 276 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014937.43234 | 2115453.8839 | 37.7894724145659 | -122.392153987042 | (37.7894724145659, -122.392153987042) | 6 | 2 | 9 | 28855 | 6 | |||
46324 | 112150 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
48369 | 256770 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 2 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
50611 | 241169 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 148 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001996.12146 | 2096541.93476 | 37.7368177733266 | -122.435575922793 | (37.7368177733266, -122.435575922793) | 2 | 7 | 5 | 63 | 7 | |||
51885 | 92266 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 29 Allston Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52717 | 5994298.9 | 2098344 | 37.7413256083624 | -122.462319061907 | (37.7413256083624, -122.462319061907) | 1 | 8 | 4 | 59 | 40 | ||
52544 | 197961 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014857.78399 | 2115129.52624 | 37.7885773804879 | -122.392406867389 | (37.7885773804879, -122.392406867389) | 6 | 2 | 9 | 28855 | 6 | |||
52894 | 121531 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
53766 | 83269 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2501 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52646 | 6010408.33356272 | 2105026.32367828 | 37.7605882462434 | -122.407088935203 | (37.7605882462434, -122.407088935203) | 10 | 4 | 8 | 28859 | 19 | ||
54192 | 114572 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 3633 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 777013 | 5997417 | 2115685 | 37.7891186297883 | -122.452789133032 | (37.7891186297883, -122.452789133032) | 11 | 6 | 1 | 54 | 31 | ||
54236 | 136738 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 48 Osgood Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011887.11576 | 2118514.31229 | 37.7977057852396 | -122.402923146385 | (37.7977057852396, -122.402923146385) | 3 | 1 | 10 | 308 | 23 | |||
56111 | 197942 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015382.55256 | 2115087.30392 | 37.7884905743282 | -122.390588280823 | (37.7884905743282, -122.390588280823) | 6 | 2 | 9 | 28855 | 6 | |||
58032 | 241175 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 3387 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007208.84788 | 2101457.68369 | 37.7506100118607 | -122.417901552934 | (37.7506100118607, -122.417901552934) | 2 | 4 | 7 | 28859 | 19 | |||
62007 | 51401 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 423 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774507 | 6011161.37558 | 2112281.69407 | 37.7805519474533 | -122.404995352556 | (37.7805519474533, -122.404995352556) | 14 | 2 | 9 | 28853 | 34 | |
62557 | 136739 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 48 Osgood Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011886.33726 | 2118519.22734 | 37.7977192373121 | -122.402926186096 | (37.7977192373121, -122.402926186096) | 3 | 1 | 10 | 308 | 23 | |||
63000 | 197955 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014952.39535 | 2115030.72864 | 37.7883113583401 | -122.392072611873 | (37.7883113583401, -122.392072611873) | 6 | 2 | 9 | 28855 | 6 | |||
66782 | 197966 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010894.68049 | 2112991.13579 | 37.7824849961321 | -122.405967973868 | (37.7824849961321, -122.405967973868) | 12 | 2 | 9 | 28853 | 34 | |||
67272 | 241164 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 2720 17th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009338.64709 | 2106411.92088 | 37.7643328604997 | -122.410886372426 | (37.7643328604997, -122.410886372426) | 8 | 4 | 7 | 28859 | 19 | |||
69957 | 112882 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | 5994670.4 | 2110971.2 | 37.7760180351325 | -122.46194999449 | (37.7760180351325, -122.46194999449) | 11 | 6 | 2 | 54 | 11 | ||||
74783 | 256773 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 16 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
77213 | 59528 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 286 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/1981 12:00:00 AM | 6 | 3x3 | Permit Number 18910 | 6010887.1653 | 2111573.26099 | 37.7785914236007 | -122.405894062179 | (37.7785914236007, -122.405894062179) | 14 | 2 | 9 | 28853 | 34 | |
77617 | 197959 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014895.93588 | 2115091.70056 | 37.7884756383871 | -122.392272219997 | (37.7884756383871, -122.392272219997) | 6 | 2 | 9 | 28855 | 6 | |||
78617 | 120014 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 359 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5986817.89176 | 2113535.36693 | 37.7826033030644 | -122.489302099137 | (37.7826033030644, -122.489302099137) | 11 | 6 | 2 | 55 | 26 | |||
80358 | 121522 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 280 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6014751 | 2115177 | 37.7887018021562 | -122.392779649259 | (37.7887018021562, -122.392779649259) | 6 | 2 | 9 | 28855 | 6 | ||||
80443 | 197975 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1808 Newhall St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013682.66617 | 2094773.96113 | 37.7326201220065 | -122.395046310152 | (37.7326201220065, -122.395046310152) | 10 | 3 | 8 | 58 | 1 | |||
80481 | 197953 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015054.91567 | 2114917.83312 | 37.7880070646074 | -122.391710008824 | (37.7880070646074, -122.391710008824) | 6 | 2 | 9 | 28855 | 6 | |||
83512 | 197964 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 542 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013328.41225 | 2111219.96647 | 37.777757584773 | -122.397424011506 | (37.777757584773, -122.397424011506) | 6 | 2 | 9 | 28856 | 34 | |||
85936 | 91212 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2901 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2009 12:00:00 AM | 3x3 | Permit Number 52044 | 6007111 | 2101465 | 37.7506245935345 | -122.41824043827 | (37.7506245935345, -122.41824043827) | 2 | 4 | 7 | 28859 | 19 | ||
86775 | 67922 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 17 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2016 12:00:00 AM | 3 | Permit Number 776405 | 6003746.91064441 | 2095538.27676938 | 37.7341612413777 | -122.429451123322 | (37.7341612413777, -122.429451123322) | 2 | 7 | 5 | 28861 | 25 | |
86809 | 250931 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 263 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5987106.46019 | 2114196.92222 | 37.7844365852323 | -122.488352423026 | (37.7844365852323, -122.488352423026) | 11 | 6 | 1 | 55 | 33 | |||
87447 | 241172 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 29 Levant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000269.35575 | 2106710.14367 | 37.7646389915166 | -122.442275826165 | (37.7646389915166, -122.442275826165) | 15 | 5 | 5 | 28862 | 3 | |||
87448 | 197940 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015409.43942 | 2115059.04086 | 37.7884144620023 | -122.39049328005 | (37.7884144620023, -122.39049328005) | 6 | 2 | 9 | 28855 | 6 | |||
87777 | 104163 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 2127 12TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 76 | 4x3 | Permit Number 770670 | 5992542 | 2100965 | 37.7484208831153 | -122.468584409749 | (37.7484208831153, -122.468584409749) | 1 | 8 | 4 | 29491 | 40 | ||
88352 | 197962 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014844.47808 | 2115146.79251 | 37.7886240508001 | -122.392454112385 | (37.7886240508001, -122.392454112385) | 6 | 2 | 9 | 28855 | 6 | |||
91367 | 104739 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 200X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | On the 23rd St Side of property | 6005413 | 2102541 | 37.753483315938 | -122.424188782445 | (37.753483315938, -122.424188782445) | 2 | 4 | 5 | 28859 | 19 | ||||
92229 | 215408 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1478 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5993690.81703 | 2105468.21978 | 37.7608518609501 | -122.46493885685 | (37.7608518609501, -122.46493885685) | 1 | 8 | 11 | 56 | 12 | |||
95482 | 84454 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 2501 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52646 | 6010408.33356272 | 2105026.32367828 | 37.7605882462434 | -122.407088935203 | (37.7605882462434, -122.407088935203) | 10 | 4 | 8 | 28859 | 19 | ||
100470 | 121527 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
100647 | 197939 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015423.89897 | 2115043.66303 | 37.7883730401228 | -122.390442176979 | (37.7883730401228, -122.390442176979) | 6 | 2 | 9 | 28855 | 6 | |||
102491 | 123341 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994696.02985 | 2110963.62248 | 37.7759987047787 | -122.461860785147 | (37.7759987047787, -122.461860785147) | 11 | 6 | 2 | 54 | 11 | |||
103030 | 121533 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | ||||
103456 | 121525 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 333 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6x10 | 6015114 | 2115064 | 37.7884116849322 | -122.391515808663 | (37.7884116849322, -122.391515808663) | 6 | 2 | 9 | 28855 | 6 | |||
105784 | 215409 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 1556 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993712.25346 | 2104885.19549 | 37.7592522638043 | -122.464822377549 | (37.7592522638043, -122.464822377549) | 1 | 8 | 4 | 56 | 12 | |||
106319 | 197974 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 248 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010760.66114 | 2111705.859 | 37.7789484310553 | -122.406341036019 | (37.7789484310553, -122.406341036019) | 14 | 2 | 9 | 28853 | 34 | |||
107007 | 256771 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 300X Octavia St | 14 | Median : Cutout | Tree | Private 2 | 3x3 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
107947 | 28499 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 270 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010842.7805 | 2111615.69591 | 37.7787054576155 | -122.406050597275 | (37.7787054576155, -122.406050597275) | 14 | 2 | 9 | 28853 | 34 | |||
111850 | 197969 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010835.00932 | 2113053.67977 | 37.7826533896919 | -122.406178819023 | (37.7826533896919, -122.406178819023) | 12 | 2 | 9 | 28853 | 34 | |||
112670 | 52291 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48450 | 6004924.5040582 | 2101031.6740118 | 37.7493114629054 | -122.425770685059 | (37.7493114629054, -122.425770685059) | 2 | 4 | 5 | 28862 | 22 | ||
113100 | 197945 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015345.08989 | 2115126.34059 | 37.7885956816912 | -122.390720625978 | (37.7885956816912, -122.390720625978) | 6 | 2 | 9 | 28855 | 6 | |||
115101 | 241168 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 3387 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007165.54985 | 2101454.26646 | 37.7505981920648 | -122.418051039151 | (37.7505981920648, -122.418051039151) | 2 | 4 | 7 | 28859 | 19 | |||
115896 | 197931 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 218 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6014498.28246 | 2115400.43441 | 37.7893012619026 | -122.393669666621 | (37.7893012619026, -122.393669666621) | 6 | 2 | 9 | 28855 | 6 | |||
121522 | 197957 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014920.6101 | 2115062.64622 | 37.7883972318904 | -122.392184817599 | (37.7883972318904, -122.392184817599) | 6 | 2 | 9 | 28855 | 6 | |||
122098 | 241166 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 2501 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781891 | 6010275.23752 | 2105021.26338 | 37.7605669026512 | -122.407548899265 | (37.7605669026512, -122.407548899265) | 10 | 4 | 8 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );