trees

1,121 rows where qSpecies_id = 6 sorted by PermitNotes descending

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

  • 7 290
  • 8 253
  • 3 185
  • 6 152
  • 4 80
  • 5 69
  • 9 28
  • 2 25
  • 1 20
  • - 15
  • 10 4
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)
12204 164659 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 150 Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2020 12:00:00 AM 3 Width 4ft Permit Number 785596 5994533.58351 2098539.8464 37.7418768645301 -122.461521809887 (37.7418768645301, -122.461521809887) 1 8 4 59 40
12222 31158 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 600 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2020 12:00:00 AM 3   Permit Number 785248 5993522.80361 2089878.90243 37.7180378119737 -122.464388049089 (37.7180378119737, -122.464388049089) 9 8 6 64 24
13775 68397 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 88 Lyell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2020 12:00:00 AM 3   Permit Number 785230 6003105.95459 2094517.30646 37.7313215783119 -122.43159424368 (37.7313215783119, -122.43159424368) 9 7 5 28861 25
6557 264929 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 4725 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 12:00:00 AM 3 3x3 Permit Number 784398 5981118.81181 2106198.14775 37.7621231273763 -122.508473270866 (37.7621231273763, -122.508473270866) 1 8 3 56 35
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
16027 261349 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
19087 261350 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
19183 261351 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
27064 182564 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2122 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft Permit Number 783239 5989402.8067 2098365.7306 37.7411021315374 -122.479249432397 (37.7411021315374, -122.479249432397) 1 8 3 29491 35
171435 258215 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2400 43rd Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/2019 12:00:00 AM 3   Permit Number 783182 5983025.27936 2098776.48804 37.7418574964013 -122.501330634264 (37.7418574964013, -122.501330634264) 1 8 3 29491 35
49016 257890 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1266 40th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2019 12:00:00 AM 3 3x3 Permit Number 782773 5983690.81524 2106537.44734 37.7632059962022 -122.499602915235 (37.7632059962022, -122.499602915235) 1 8 3 56 35
24945 89565 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5001X Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/2019 12:00:00 AM 3 3x3 Permit Number 782749 5983089.78021 2111680.23644 37.777291329944 -122.502062233879 (37.777291329944, -122.502062233879) 11 6 2 55 26
139625 184669 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1679 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/03/2019 12:00:00 AM 3 Width 0ft Permit Number 782746 5984671.7436 2103779.4399 37.7556907855566 -122.496006782875 (37.7556907855566, -122.496006782875) 1 8 3 56 35
158809 184688 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1611 37th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/03/2019 12:00:00 AM 3 Width 0ft Permit Number 782745 5984657.9281 2104207.7196 37.7568659135367 -122.496086155975 (37.7568659135367, -122.496086155975) 1 8 3 56 35
64938 256897 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2051 34th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2018 12:00:00 AM 3 3x3 Permit Number 782737 5985693.46852 2101265.2111 37.7488471905551 -122.492288254945 (37.7488471905551, -122.492288254945) 1 8 3 29491 35
6798 125247 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1085 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2020 12:00:00 AM 3 3x3 Permit Number 782055 6008420.1565 2118241.89629 37.796763597016 -122.414900521554 (37.796763597016, -122.414900521554) 5 1 10 308 21
18773 255529 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2018 12:00:00 AM 3 3x3 Permit Number 782018                    
60329 255502 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 248 Arlington St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/2018 12:00:00 AM 3 3x3 Permit Number 781971 6004730.8147 2096705.01729 37.7374205056678 -122.426132488181 (37.7374205056678, -122.426132488181) 2 7 5 63 7
28945 157260 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1059 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2018 12:00:00 AM 3 Width 0ft Permit Number 781960 5995594.16193 2098091.79633 37.7407076181758 -122.457822284089 (37.7407076181758, -122.457822284089) 9 7 4 59 40
142719 124805 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2798 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2018 12:00:00 AM 3 Width 5ft Permit Number 781937 5999607.72686 2118800.07594 37.7977970943207 -122.445433600384 (37.7977970943207, -122.445433600384) 13 9 1 57 17
59553 237223 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 478 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2018 12:00:00 AM 3 Width 3ft Permit Number 781633 6003374.63036 2100117.41801 37.7467134247776 -122.431064932422 (37.7467134247776, -122.431064932422) 2 7 5 63 22
194470 254768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 415 Victoria St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/2018 12:00:00 AM 3 3x3 Permit Number 781626 5993212 2089957 37.7182343284954 -122.4654680237 (37.7182343284954, -122.4654680237) 9 8 6 64 24
179045 19350 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 618 Shields St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2018 12:00:00 AM 3 3X3 Permit Number 781612 5992350.09465 2089866.75515 37.7179367902328 -122.468440675709 (37.7179367902328, -122.468440675709) 9 8 6 64 24
52571 182607 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1867 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2018 12:00:00 AM 3 Width 0ft Permit Number 781588 5986269.2088 2102542.1488 37.7523869566931 -122.49039129916 (37.7523869566931, -122.49039129916) 1 8 3 56 35
59117 184544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3425 Moraga St 1 Sidewalk: Curb side : Yard Tree Private 2   03/06/2018 12:00:00 AM 3 Width 0ft Permit Number 781517 5983632.4928 2103556.7404 37.7550183908439 -122.499584326949 (37.7550183908439, -122.499584326949) 1 8 3 56 35
110666 254576 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2138 45th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2018 12:00:00 AM 3 3x3 Permit Number 781492 5982342.68444 2100548.37441 37.7466824957237 -122.50382198427 (37.7466824957237, -122.50382198427) 1 8 3 29491 35
135324 184721 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1630 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2018 12:00:00 AM 3 Width 0ft Permit Number 781490 5982537.7064 2103994.8819 37.7561571061486 -122.503402789254 (37.7561571061486, -122.503402789254) 1 8 3 56 35
166701 254575 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2446 43rd Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2018 12:00:00 AM 3 3x3 Permit Number 781489 5983035.61421 2098477.14413 37.7410361869592 -122.501272763587 (37.7410361869592, -122.501272763587) 1 8 3 29491 35
80376 184160 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3538 Lawton St 1 Sidewalk: Curb side : Yard Tree Private 2   02/28/2018 12:00:00 AM 3 Width 0ft Permit Number 781479 5983222.1931 2104276.0104 37.7569692214498 -122.50105643195 (37.7569692214498, -122.50105643195) 1 8 3 56 35
129549 184161 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3540 Lawton St 2 Sidewalk: Curb side : Yard Tree Private 2   02/28/2018 12:00:00 AM 3 Width 0ft Permit Number 781479 5983209.359 2104274.4825 37.7569642726582 -122.501100703383 (37.7569642726582, -122.501100703383) 1 8 3 56 35
146709 254547 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2908 Bush St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 02/26/2018 12:00:00 AM 3 3x3 Permit Number 781446 5999588.42992 2114352.40043 37.7855838475934 -122.445180440387 (37.7855838475934, -122.445180440387) 15 6 1 29490 31
76984 176882 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 371 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/2018 12:00:00 AM 3 3x3 Permit Number 781358 6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406) 9 7 8 309 39
47209 165132 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781230 5995776.8676 2094560.79185 37.7310228361347 -122.456935228771 (37.7310228361347, -122.456935228771) 9 7 4 28861 40
92269 165133 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 929 Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2018 12:00:00 AM 3 3x3 Permit Number 781230 5995820.38989 2094571.40487 37.731054476063 -122.456785533051 (37.731054476063, -122.456785533051) 9 7 4 28861 40
50062 254193 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1265 Monterey Blvd 1 Front Yard : Cutout Tree Private 2 FUF 01/19/2018 12:00:00 AM 3 3x3 Permit Number 781221 5994091.43615 2094320.67109 37.7302665946388 -122.462744594485 (37.7302665946388, -122.462744594485) 9 8 4 59 40
150802 61555 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1175- 1175 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/2018 12:00:00 AM 3 3x3 Permit Number 781207 6012252.19835 2102963.49184 37.7550271768774 -122.400566896541 (37.7550271768774, -122.400566896541) 10 3 8 28856 29
134165 258203 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2422 41st Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2019 12:00:00 AM 3 3x3 Permit Number 781120 5983650.02463 2098655.15546 37.741561019666 -122.499161539913 (37.741561019666, -122.499161539913) 1 8 3 29491 35
146202 83910 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1515 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 3x3 Permit Number 781100 5982467.7611 2104767.4351 37.7582742066085 -122.503701891018 (37.7582742066085, -122.503701891018) 1 8 3 56 35
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
14258 261352 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 297 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 780859 5994172 2087374 37.7111973453091 -122.461962532307 (37.7111973453091, -122.461962532307) 9 8 6 28861 24
15290 25338 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
41357 255423 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
56985 255424 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
170704 255422 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2398X 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3 Permit Number 780836 5982745 2098835 37.7420016902952 -122.502304062071 (37.7420016902952, -122.502304062071) 1 8 3 29491 35
93370 255421 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2727 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/21/2018 12:00:00 AM 3 10x10 Permit Number 780223 5985829 2096861 37.7367623321138 -122.491495459369 (37.7367623321138, -122.491495459369) 1 8 3 29491 35
67418 255648 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2834 Polk St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2018 12:00:00 AM 3 3x3 Permit Number 779253 6006100.90264 2120497.78973 37.8028271147622 -122.423086110708 (37.8028271147622, -122.423086110708) 5 9 1 28858 32
167406 176915 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 143 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2018 12:00:00 AM 3 3x3 Permit Number 778564 6009701.03874 2093769.75693 37.7296405745301 -122.408741008189 (37.7296405745301, -122.408741008189) 10 3 7 309 28
102876 119072 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 635 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2016 12:00:00 AM 3 Width 4ft Permit Number 778557 5981931.09212 2111414.85236 37.7764945246953 -122.506050759134 (37.7764945246953, -122.506050759134) 11 6 2 55 26
53066 54871 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 250 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3 3x3 Permit Number 778523 6005357.45103895 2109955.71553685 37.7738392293497 -122.424908369576 (37.7738392293497, -122.424908369576) 7 9 11 28852 10
35644 117055 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 762 34th Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/18/2016 12:00:00 AM 3   Permit Number 778404 5985439.6 2110687.7 37.7747038750392 -122.493860404631 (37.7747038750392, -122.493860404631) 11 6 2 55 26
181063 182513 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1573 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   03/23/2018 12:00:00 AM 3 Width 0ft Permit Number 777985 5985578.9968 2104511.5721 37.7577541150318 -122.492923184352 (37.7577541150318, -122.492923184352) 1 8 3 56 35
113377 115939 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 607 34TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777685 5985316 2111712 37.7775090776113 -122.494363475489 (37.7775090776113, -122.494363475489) 11 6 2 55 26
76325 253875 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 274 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2017 12:00:00 AM 3 3x3 Permit Number 777423 6003013.5236 2093666.24958 37.728979528994 -122.431853049446 (37.728979528994, -122.431853049446) 9 7 6 28861 25
59213 115174 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1234 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM     Permit Number 777353 5981842.5 2106688 37.7635107458641 -122.506006674694 (37.7635107458641, -122.506006674694) 1 8 3 56 35
14180 256094 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2018 12:00:00 AM 3 3x3 Permit Number 777292 5982503.90034 2112800.93962 37.7803340153983 -122.504171983842 (37.7803340153983, -122.504171983842) 11 6 2 55 26
49657 46433 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011103.47209 2089684.58226 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234) 10 7 8 309 28
132281 254353 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 2 Ankeny St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 777225 6011131.69741 2089639.6721 37.7183802415409 -122.403504586485 (37.7183802415409, -122.403504586485) 10 7 8 309 28
76042 79199 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 409 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/2015 12:00:00 AM 1   Permit Number 777130 5998120.56156 2115036.84682 37.7873792631851 -122.450308169597 (37.7873792631851, -122.450308169597) 11 6 1 54 31
113032 111713 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3038 CLEMENT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051 2113265 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217) 11 6 2 55 26
193198 111714 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3038 CLEMENT ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051 2113265 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217) 11 6 2 55 26
178481 117431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 730 Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 776696 6004211.11578 2091567.32576 37.7232841663055 -122.427563407639 (37.7232841663055, -122.427563407639) 9 7 6 28861 5
177745 78252 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 541 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2015 12:00:00 AM 1 3x3 Permit Number 776648 6003018.57122 2090471.02112 37.7202064317688 -122.431607573443 (37.7202064317688, -122.431607573443) 9 7 6 28861 5
193498 47037 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 714 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/2015 12:00:00 AM     Permit Number 776491 6002280.60768666 2108833.96933031 37.7705849188534 -122.435471392977 (37.7705849188534, -122.435471392977) 15 5 11 29492 9
14691 69919 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 95 Mercedes Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.7286182461033 -122.470591251084 (37.7286182461033, -122.470591251084) 9 8 4 59 40
53141 71841 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 95 Mercedes Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.7286182461033 -122.470591251084 (37.7286182461033, -122.470591251084) 9 8 4 59 40
116677 115268 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2275 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 775658 5987276.1 2099806.2 37.7449335319328 -122.486708467871 (37.7449335319328, -122.486708467871) 1 8 3 29491 35
96365 54968 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 526 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2015 12:00:00 AM 3   Permit Number 775624 5993160.60664 2111866.07895 37.7783880954675 -122.467237804922 (37.7783880954675, -122.467237804922) 11 6 2 54 11
192805 115237 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 867 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM     Permit Number 775536 5982900.6 2109891.1 37.7723677654738 -122.502584200594 (37.7723677654738, -122.502584200594) 11 6 2 55 26
175025 115381 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 1657X York St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 775521 6010720.61658 2099977.21326 37.7467419766429 -122.405653246985 (37.7467419766429, -122.405653246985) 2 7 7 28859 2
69435 114895 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 820 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2015 12:00:00 AM     Permit Number 775427 5986664.4 2110325.3 37.7737804103986 -122.489596975753 (37.7737804103986, -122.489596975753) 11 6 2 55 26
145011 117426 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 395 Athens St 1 Sidewalk: Curb side : Yard Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 775297 6003998.92006 2091015.17385 37.7217560742586 -122.428257595231 (37.7217560742586, -122.428257595231) 9 7 6 28861 5
63206 115239 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 863 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM     Permit Number 775147 5981970.6 2109880.3 37.7722834181785 -122.505800301349 (37.7722834181785, -122.505800301349) 11 6 2 55 26
176687 63095 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1314 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2016 12:00:00 AM 1   Permit Number 775034 5982157.61974918 2106142.20642168 37.7620306969809 -122.504876348182 (37.7620306969809, -122.504876348182) 1 8 3 56 35
93865 109578 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 10X Santa Rosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2015 12:00:00 AM 3 3x3 Permit Number 775018 6002262.55573 2092599.72242 37.7260084870829 -122.434372977031 (37.7260084870829, -122.434372977031) 9 7 6 28861 25
186425 109577 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 10X Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2015 12:00:00 AM 3 3x3 Permit Number 775018 6002290.3134 2092582.02308 37.72596146424 -122.434275755847 (37.72596146424, -122.434275755847) 9 7 6 28861 25
177072 81730 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2346 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2016 12:00:00 AM 3 3x3 Permit Number 774950 5982707.54204511 2099147.52139682 37.7428575871403 -122.502456702486 (37.7428575871403, -122.502456702486) 1 8 3 29491 35
39271 37722 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 04:53:00 PM 3 3x3 Permit Number 774917 5983850.6165 2098795.1757 37.7419572424052 -122.498478312402 (37.7419572424052, -122.498478312402) 1 8 3 29491 35
52675 37717 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 04:45:00 PM 3 3x3 Permit Number 774917 5983817.4661 2098794.1609 37.7419525119456 -122.498592859082 (37.7419525119456, -122.498592859082) 1 8 3 29491 35
91141 37721 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 05:19:00 PM 3 3x3 Permit Number 774917 5983882.4138 2098796.867 37.7419637508928 -122.498368494175 (37.7419637508928, -122.498368494175) 1 8 3 29491 35
98323 37723 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3001 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2015 05:05:00 PM 3 3x3 Permit Number 774917 5983867.1917 2098797.5436 37.7419647160194 -122.498421176446 (37.7419647160194, -122.498421176446) 1 8 3 29491 35
77162 102385 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 33 Buena Vista Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM   3x3 Permit Number 774895 6001524.4 2108057.6 37.7684102241102 -122.438031497558 (37.7684102241102, -122.438031497558) 15 5 5 29492 3
114382 102384 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 33 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM   3x3 Permit Number 774895 6001524.4 2108057.6 37.7684102241102 -122.438031497558 (37.7684102241102, -122.438031497558) 15 5 5 29492 3
3013 109184 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2015 12:00:00 AM 3 3x3 Permit Number 774827 6002270 2092514.4 37.7257746335194 -122.434341145327 (37.7257746335194, -122.434341145327) 9 7 6 28861 25
148517 109183 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 5 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2015 12:00:00 AM 3 3x3 Permit Number 774827 6002270 2092514.4 37.7257746335194 -122.434341145327 (37.7257746335194, -122.434341145327) 9 7 6 28861 25
169433 115802 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1218 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 774518 5981226.5 2106751.9 37.7636499175412 -122.50814192749 (37.7636499175412, -122.50814192749) 1 8 3 56 35
50859 114691 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 391 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761) 10 3 7 309 28
138944 114692 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 391 Girard St 2 Sidewalk: Curb side : Cutout Tree Port 6 Private 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761) 10 3 7 309 28
174553 115183 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3610 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/2016 12:00:00 AM     Permit Number 774488 5982230.3 2100857.8 37.7475254834273 -122.50423350924 (37.7475254834273, -122.50423350924) 1 8 3 29491 35
43518 114818 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 825 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2018 12:00:00 AM 3   Permit Number 774480 5986555.6 2110296.1 37.773693882861 -122.489971179067 (37.773693882861, -122.489971179067) 11 6 2 55 26
68598 109688 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 610 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774167 6002866.93373 2090069.72294 37.719095959684 -122.432103090885 (37.719095959684, -122.432103090885) 9 7 6 28861 5
61823 109689 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 836 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774161 6003406.50306 2089728.73547 37.7181902596385 -122.430213694415 (37.7181902596385, -122.430213694415) 9 7 6 28861 5
37255 108775 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
54619 108768 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
108222 108764 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
117917 108778 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
134524 108772 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 500X Lathrop Ave 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
174505 108825 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 146-150X Gillette Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773819 6013072.89275 2086799.91674 37.7106910734067 -122.39659568235 (37.7106910734067, -122.39659568235) 10 3 8 309 1
192015 108829 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 545 Lathrop Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 773819 6012931.90275 2086607.74701 37.7101555653976 -122.397069513169 (37.7101555653976, -122.397069513169) 10 3 8 309 1
2654 108556 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 62 San Gabriel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/09/2019 12:00:00 AM 3 3x3 Permit Number 773715 6001062.72482 2093636.21513 37.7287862806562 -122.43859494063 (37.7287862806562, -122.43859494063) 9 7 6 28861 25
50370 109275 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1437 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773660 5984291.9 2105367.5 37.7600289003771 -122.4974376175 (37.7600289003771, -122.4974376175) 1 8 3 56 35

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