trees

155 rows where qSpecies_id = 12

✎ View and edit SQL

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

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