trees
155 rows where qSpecies_id = 12 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||
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 | |||||
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 | |||
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 | |||
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 | |
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 | |||
187036 | 197950 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.06913 | 2114845.42683 | 37.78781198099 | -122.39147260399 | (37.78781198099, -122.39147260399) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
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 | ||||
184080 | 84157 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 607 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52665 | 6007912.35762405 | 2104388.06639727 | 37.7586957437969 | -122.415676213523 | (37.7586957437969, -122.415676213523) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
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 |
180437 | 241173 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 344 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003615.63748 | 2108670.28544 | 37.7702112142959 | -122.430841829505 | (37.7702112142959, -122.430841829505) | 15 | 9 | 11 | 29492 | 10 | |||
177018 | 123142 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 588 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992875.98523 | 2111469.09089 | 37.7772816395031 | -122.468193521633 | (37.7772816395031, -122.468193521633) | 11 | 6 | 2 | 54 | 11 | |||
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 |
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 | |||
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 | |
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 | ||||
168053 | 197970 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011429.88 | 2113631.09913 | 37.7842721037271 | -122.404161460703 | (37.7842721037271, -122.404161460703) | 12 | 2 | 9 | 28853 | 34 | |||
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 |
165547 | 197954 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014967.3458 | 2115010.36938 | 37.7882562865359 | -122.392019461055 | (37.7882562865359, -122.392019461055) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
158604 | 197941 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015395.33914 | 2115073.46848 | 37.7884532947311 | -122.390543073727 | (37.7884532947311, -122.390543073727) | 6 | 2 | 9 | 28855 | 6 | |||
154596 | 197947 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015181.90784 | 2114782.68657 | 37.7876430316507 | -122.39126118415 | (37.7876430316507, -122.39126118415) | 6 | 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 | ||
153468 | 197958 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014908.62801 | 2115077.84616 | 37.7884383021313 | -122.392227337523 | (37.7884383021313, -122.392227337523) | 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 | ||||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | |
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 |
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 | |||
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 | |||
143196 | 108470 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 663 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773783 | 5992531.7071 | 2110944.78333 | 37.7758221433837 | -122.469346307299 | (37.7758221433837, -122.469346307299) | 11 | 6 | 2 | 54 | 11 | |||
142926 | 241167 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008217.59189 | 2096787.94812 | 37.7378446732024 | -122.41408289663 | (37.7378446732024, -122.41408289663) | 2 | 7 | 7 | 28859 | 2 | |||
141989 | 197943 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015369.55372 | 2115100.01237 | 37.7885247476754 | -122.390634143574 | (37.7885247476754, -122.390634143574) | 6 | 2 | 9 | 28855 | 6 | |||
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 | ||||
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 | ||||
137275 | 197960 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014878.139 | 2115106.33815 | 37.7885148416282 | -122.392334819105 | (37.7885148416282, -122.392334819105) | 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 | |||
132212 | 197951 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015100.083 | 2114872.3871 | 37.7878847873904 | -122.391550558114 | (37.7878847873904, -122.391550558114) | 6 | 2 | 9 | 28855 | 6 | |||
132182 | 31880 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 357 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35318 | 5986819.04944 | 2113546.00987 | 37.7826325931106 | -122.489298876891 | (37.7826325931106, -122.489298876891) | 11 | 6 | 2 | 55 | 26 | ||
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 | |
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 | ||
130425 | 197965 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 542 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013312.52382 | 2111204.97894 | 37.7777155477834 | -122.397477924066 | (37.7777155477834, -122.397477924066) | 6 | 2 | 9 | 28856 | 34 | |||
126569 | 197952 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015071.96178 | 2114899.8114 | 37.7879585273121 | -122.391649771325 | (37.7879585273121, -122.391649771325) | 6 | 2 | 9 | 28855 | 6 | |||
126102 | 197948 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015157.51241 | 2114808.67556 | 37.7877130375663 | -122.391347405751 | (37.7877130375663, -122.391347405751) | 6 | 2 | 9 | 28855 | 6 | |||
125340 | 197946 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015324.49804 | 2115147.49947 | 37.78865263665 | -122.390793350551 | (37.78865263665, -122.390793350551) | 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 | |||
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 | |||
123910 | 197949 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015139.49005 | 2114827.68285 | 37.7877642269846 | -122.391411089446 | (37.7877642269846, -122.391411089446) | 6 | 2 | 9 | 28855 | 6 | |||
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 | ||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | ||
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 |
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) );