trees

155 rows where qSpecies_id = 12 sorted by qAddress descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: qCaretaker_id

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

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