155 rows where qSpecies_id = 12 sorted by qAddress

View and edit SQL

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)
130472 197923 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 Width 5ft   6013948.03305 2115996.75839 37.7909080374275 -122.395615276145 (37.7909080374275, -122.395615276145) 12 2 9 28855 6
152347 197922 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 Width 5ft   6013927.10424 2116016.68419 37.7909615848495 -122.395689086178 (37.7909615848495, -122.395689086178) 12 2 9 28855 6
154232 197924 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 100 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 Width 5ft   6013969.61875 2115974.72965 37.7908487523134 -122.395539045996 (37.7908487523134, -122.395539045996) 12 2 9 28855 6
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                        
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                        
12795 259079 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1000 Visitacion Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1                              
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                        
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                        
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                        
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
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
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
188945 112147 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 101X 05TH ST 1 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
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
190151 47913 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1025 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2002 12:00:00 AM 7   Permit Number 45650 6001905.584 2112009.098 37.7792817219988 -122.436995952461 (37.7792817219988, -122.436995952461) 15 5 11 29490 41
166843 46865 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1114 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM 11 3x3 Permit Number 44932 6009363.96744 2117083.81904 37.793636788264 -122.411552843787 (37.793636788264, -122.411552843787) 3 1 10 28857 21
123127 34776 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 1148 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM   4x4 Permit Number 38417 6008035.00461404 2101235.83901924 37.7500473368591 -122.415028926905 (37.7500473368591, -122.415028926905) 2 4 7 28859 19
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
173662 95690 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 128 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/08/2011 12:00:00 AM   3x3 Permit Number 767441 6000854 2105632 37.7617119784366 -122.440176382755 (37.7617119784366, -122.440176382755) 15 5 5 28862 3
182009 243820 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 129 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/02/2018 12:00:00 AM 3 3x3 Permit Number 781316 6007254.97464 2100142.23654 37.747000687137 -122.417648817364 (37.747000687137, -122.417648817364) 2 7 7 28859 2
144433 241165 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 1358 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009520.35544 2101278.61377 37.7502481435534 -122.409895500301 (37.7502481435534, -122.409895500301) 2 4 7 28859 19
150053 96055 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 1358 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767683 6009525 2101259 37.7501945487931 -122.409878054668 (37.7501945487931, -122.409878054668) 2 4 7 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
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
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
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
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
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
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
184350 197968 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 153 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6010849.47884 2113039.65001 37.7826156766079 -122.406127771681 (37.7826156766079, -122.406127771681) 12 2 9 28853 34
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
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
182160 241176 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 16 Temple St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999954.14374 2105886.54526 37.7623596247176 -122.443306897094 (37.7623596247176, -122.443306897094) 15 5 5 28862 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
131589 81524 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 1643 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53916 5993372.97126564 2104303.07947151 37.7576343572278 -122.465953471382 (37.7576343572278, -122.465953471382) 1 8 4 56 12
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
174934 155501 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 175 Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/2018 12:00:00 AM 3 3x3 Permit Number 781267 5994415.96169 2098613.76746 37.7420730624341 -122.461933863951 (37.7420730624341, -122.461933863951) 1 8 4 59 40
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
193268 52304 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 180DANVERS Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/01/2005 12:00:00 AM     Permit Number 48464 6000126.86103947 2104901.42011078 37.7596645617882 -122.442638797859 (37.7596645617882, -122.442638797859) 2 4 5 28862 3
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
192727 97026 Property Tree 8 Tilia cordata :: Littleleaf Linden 12 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
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
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
140446 104738 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 200X Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2         Tree on the 23rd St side of property 6005413 2102541 37.753483315938 -122.424188782445 (37.753483315938, -122.424188782445) 2 4 5 28859 19
149175 156575 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 201 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/01/2018 12:00:00 AM 3 3x3 Permit Number 781304 6006859.44436 2096783.37934 37.7377557518137 -122.418778360432 (37.7377557518137, -122.418778360432) 2 7 7 28859 2
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
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
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
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
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
135379 241177 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 22 Temple St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999945.77757 2105873.29085 37.7623227543165 -122.443334880405 (37.7623227543165, -122.443334880405) 15 5 5 28862 3
144647 197937 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 220 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6014670.19606 2115221.91526 37.7888206408102 -122.393062365246 (37.7888206408102, -122.393062365246) 6 2 9 28855 6
150389 197935 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 220 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6014614.74747 2115277.87841 37.7889712224 -122.393258128754 (37.7889712224, -122.393258128754) 6 2 9 28855 6
190403 197938 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 220 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6014691.15207 2115201.2077 37.7887649467015 -122.392988410406 (37.7887649467015, -122.392988410406) 6 2 9 28855 6
191478 197936 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 220 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6014628.26894 2115262.57971 37.7889299668815 -122.393210274953 (37.7889299668815, -122.393210274953) 6 2 9 28855 6
174061 241170 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 223 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007925.87251 2097558.85626 37.7399450281481 -122.415146068833 (37.7399450281481, -122.415146068833) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
124406 197925 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 274 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6014850.28645 2115545.31088 37.7897186129805 -122.392461902306 (37.7897186129805, -122.392461902306) 6 2 9 28855 6
125287 197927 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 274 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6014884.10651 2115509.17799 37.7896212784354 -122.392342359022 (37.7896212784354, -122.392342359022) 6 2 9 28855 6
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
140184 255996 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 276 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 2ft   6014937.43234 2115453.8839 37.7894724145659 -122.392153987042 (37.7894724145659, -122.392153987042) 6 2 9 28855 6
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
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
194150 121524 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
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
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
151075 241171 DPW Maintained 1 Tilia cordata :: Littleleaf Linden 12 29 Levant St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000270.28212 2106683.67196 37.764566359572 -122.442270721627 (37.764566359572, -122.442270721627) 15 5 5 28862 3
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
160999 91211 Permitted Site 7 Tilia cordata :: Littleleaf Linden 12 2901 Mission St   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
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
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
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
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
152433 256772 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 300X Octavia St 15 Median : Cutout Tree Private 2       3x3   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
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
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
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
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
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
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
152599 121532 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
170258 121530 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184275 121529 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);