290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by Location

View and edit SQL

Police Districts

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)
79736 251742 Undocumented 4 Lagunaria patersonii :: Primrose Tree 6 300 Naylor St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002771 2086560 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389) 9 7 6 28861 5
100552 172375 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 216 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 07:37:00 AM 3 Width 2ft   6002574 2086750 37.7099641176609 -122.432878614235 (37.7099641176609, -122.432878614235) 9 7 6 28861 5
10101 180653 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 245 Chicago Way 1 Sidewalk: Curb side : Yard Tree Private 2   10/11/2017 07:56:00 AM 3 Width 6ft   6002847.75966 2086772.69306 37.7100419513527 -122.431934068713 (37.7100419513527, -122.431934068713) 9 7 6 28861 5
132775 180842 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 87 Laura St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.451155786013 (37.710473721248, -122.451155786013) 9 7 6 28861 25
15168 259102 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 619 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010517.89431 2086850.21293 37.7106866494876 -122.405429914879 (37.7106866494876, -122.405429914879) 9 7 8 309 39
9408 259103 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 625 Visitacion Ave   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3     6010501.76504 2086856.29359 37.7107024439005 -122.405486089504 (37.7107024439005, -122.405486089504) 9 7 8 309 39
122783 159336 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 523 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352) 9 7 6 28861 25
28544 159338 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.448328017142 (37.7108995709325, -122.448328017142) 9 7 6 28861 25
57846 159339 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 517 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.45786 2087195.02696 37.7109327990681 -122.44828212563 (37.7109327990681, -122.44828212563) 9 7 6 28861 25
84873 69398 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1174 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.44104 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606) 9 7 6 28861 5
51610 176885 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rey St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008580.05361 2087004.56736 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652) 9 7 8 309 39
82967 25763 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1682 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/20/2015 06:02:00 PM 3 2X3   6004184.86566 2087196.38583 37.711281031873 -122.427342931648 (37.711281031873, -122.427342931648) 9 7 6 28861 5
141967 159345 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131) 9 7 6 28861 25
81002 159346 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.80621 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285) 9 7 6 28861 25
139614 159347 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.7113673820764 -122.44773365339 (37.7113673820764, -122.44773365339) 9 7 6 28861 25
171958 159348 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 461 Ellington Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.36678 37.7114303786888 -122.447651252104 (37.7114303786888, -122.447651252104) 9 7 6 28861 25
154340 176919 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 140 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6001505.61042 2087336.29034 37.7115132862848 -122.436613103724 (37.7115132862848, -122.436613103724) 9 7 6 28861 5
1481 172310 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 63 Seville St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/23/2020 12:00:00 AM 3 Width 3ft   6001999.53893 2087418.49495 37.7117670587831 -122.434911834617 (37.7117670587831, -122.434911834617) 9 7 6 28861 5
173908 251743 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 143 Cordova St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001773 2087479 37.7119203272299 -122.43569914015 (37.7119203272299, -122.43569914015) 9 7 6 28861 5
121056 251749 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 601 Prague St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002875 2087693 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156) 9 7 6 28861 5
161307 176916 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 380 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001888.93185 2087835.89796 37.7129068748214 -122.435323960636 (37.7129068748214, -122.435323960636) 9 7 6 28861 5
103230 49761 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 366@ REY Leland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46555 6008949.54261 2087928.88077 37.713560633393 -122.41092664676 (37.713560633393, -122.41092664676) 9 7 8 309 39
144424 116545 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 1 Median : Yard Tree DPW 1     2 3x3   6001537.05763 2088100.5912 37.7136136745151 -122.436559085032 (37.7136136745151, -122.436559085032) 9 7 6 28861 5
116664 116546 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001545.43478 2088113.86518 37.7136505979649 -122.436531080144 (37.7136505979649, -122.436531080144) 9 7 6 28861 5
29210 176917 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 9 Median : Yard Tree DPW 1     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224) 9 7 6 28861 5
95040 116547 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 3 Median : Yard Tree DPW 1     4 3x3   6001554.67745 2088129.8106 37.7136949057732 -122.436500274771 (37.7136949057732, -122.436500274771) 9 7 6 28861 5
58866 116551 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 7 Median : Yard Tree DPW 1     4 3x3   6001523.56178 2088140.13665 37.713721490625 -122.436608560332 (37.713721490625, -122.436608560332) 9 7 6 28861 5
139455 116549 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 5 Median : Yard Tree DPW 1     4 3x3   6001562.82912 2088145.24079 37.7137377368707 -122.436473203396 (37.7137377368707, -122.436473203396) 9 7 6 28861 5
123255 116550 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001534.78323 2088160.34451 37.7137776146169 -122.436571220504 (37.7137776146169, -122.436571220504) 9 7 6 28861 5
69235 116543 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 6 Median : Yard Tree DPW 1     5 3x3   6001574.84931 2088164.89401 37.7137923832878 -122.43643306305 (37.7137923832878, -122.43643306305) 9 7 6 28861 5
138388 116548 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 4 Median : Yard Tree DPW 1     3 3x3   6001544.87474 2088178.15499 37.7138270917124 -122.436537614614 (37.7138270917124, -122.436537614614) 9 7 6 28861 5
7686 116544 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 7 Median : Yard Tree DPW 1     5 3x3   6001586.02621 2088182.95127 37.7138425996209 -122.436395723209 (37.7138425996209, -122.436395723209) 9 7 6 28861 5
44017 116540 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 3 Median : Yard Tree DPW 1     3 3x3   6001555.50616 2088195.95431 37.7138765688354 -122.436502141754 (37.7138765688354, -122.436502141754) 9 7 6 28861 5
17357 116552 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 8 Median : Yard Tree DPW 1     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838) 9 7 6 28861 5
138570 116539 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 2 Median : Yard Tree DPW 1     3 3x3   6001567.48738 2088213.72569 37.7139260459311 -122.436462001442 (37.7139260459311, -122.436462001442) 9 7 6 28861 5
155326 176918 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1041x Naples St 9 Median : Yard Tree DPW 1     4     6001604.80367 2088215.91202 37.7139341694897 -122.436333178956 (37.7139341694897, -122.436333178956) 9 7 6 28861 5
65853 116538 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1002x Naples St 1 Median : Yard Tree DPW 1     1 3x3   6001578.10158 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612) 9 7 6 28861 5
192989 181010 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 215 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.90059 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327) 9 7 6 28861 5
168066 181011 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 207 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.31583 2088326.00254 37.7142089699327 -122.438012171843 (37.7142089699327, -122.438012171843) 9 7 6 28861 5
194177 181017 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.438369065102 (37.7143700996689, -122.438369065102) 9 7 6 28861 5
30385 181018 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 197 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.04691 37.7143947132291 -122.43841724089 (37.7143947132291, -122.43841724089) 9 7 6 28861 5
109143 181019 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 191 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.7144296473919 -122.438501549606 (37.7144296473919, -122.438501549606) 9 7 6 28861 5
117385 181020 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 183 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.93011 37.7144764921819 -122.438602919392 (37.7144764921819, -122.438602919392) 9 7 6 28861 5
57710 181021 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 179 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2017 12:49:00 PM 3 8x6   6000934.69942 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076) 9 7 6 28861 5
151427 176883 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 4 Front Yard : Yard Tree Private 2     1     6011048.63475 2088252.82193 37.7145675926038 -122.403694172945 (37.7145675926038, -122.403694172945) 9 7 8 309 39
172292 176884 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 96 Alpha St 2 Front Yard : Yard Tree Private 2     1     6011062.55449 2088258.87965 37.7145850034576 -122.403646486396 (37.7145850034576, -122.403646486396) 9 7 8 309 39
139943 115757 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1718 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.21291 37.7151093927473 -122.448405831859 (37.7151093927473, -122.448405831859) 9 7 6 28861 25
133452 181027 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.24811 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188) 9 7 6 28861 5
39381 181028 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 95 Rolph St 2 Sidewalk: Curb side : Yard Tree Private 2   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.46766 37.7151323074928 -122.440070279342 (37.7151323074928, -122.440070279342) 9 7 6 28861 5
25 49783 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
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
8 264824 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
67542 95712 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 642 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767468 6003074.18539 2089625.7401 37.7178886288451 -122.431355025819 (37.7178886288451, -122.431355025819) 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
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
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
95475 46434 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174) 10 7 8 309 28
82669 46431 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.403656249429 (37.7185939356546, -122.403656249429) 10 7 8 309 28
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
102650 120680 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 522 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2016 12:00:00 AM 3 3x3   6003717 2090174 37.7194304401491 -122.42917217064 (37.7194304401491, -122.42917217064) 9 7 6 28861 5
163710 108371 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 575 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1 3x3   6001620.80772 2090281.19611 37.7196058887813 -122.43642558878 (37.7196058887813, -122.43642558878) 9 7 6 28861 5
27595 63507 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 574 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1987 12:00:00 AM 4   Permit Number 24113 6001588.8915 2090307.92108 37.7196774559426 -122.436537823274 (37.7196774559426, -122.436537823274) 9 7 6 28861 5
141360 176880 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3333 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012013.01229 2090122.10429 37.7197540907522 -122.400492099948 (37.7197540907522, -122.400492099948) 10 7 8 309 28
41454 253116 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 26 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
96295 253108 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
156762 253110 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 20 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
172760 253118 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 28 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
173524 253112 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
182173 253114 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 24 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.7197834059472 -122.442045963044 (37.7197834059472, -122.442045963044) 9 7 6 28861 25
143452 160073 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 16 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.99934 2090399.7386 37.7198438772755 -122.441749724582 (37.7198438772755, -122.441749724582) 9 7 6 28861 25
165323 160071 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 14 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:31:00 AM 3 Width 0ft   6000209.4859 2090450.10808 37.7199893866688 -122.44131611827 (37.7199893866688, -122.44131611827) 9 7 6 28861 25
186495 57147 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 578 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2012 12:00:00 AM 6 4x4 Permit Number 14422 6001353.29798 2090440.69811 37.7200286411902 -122.4373616868 (37.7200286411902, -122.4373616868) 9 7 6 28861 5
161401 37831 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 18 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003870.23097 2090403.35388 37.7200688687581 -122.428658848427 (37.7200688687581, -122.428658848427) 9 7 6 28861 5
23429 176881 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 3303 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011991.79808 2090250.44255 37.7201052985 -122.400574440964 (37.7201052985, -122.400574440964) 10 7 8 309 28
194372 37826 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.428571430748 (37.7201841150858, -122.428571430748) 9 7 6 28861 5
189866 37825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003912.01731 2090448.66207 37.7201956398999 -122.428517635078 (37.7201956398999, -122.428517635078) 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
14976 160069 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:26:00 AM 3 Width 0ft   6000296.79811 2090527.78789 37.7202076512361 -122.441019880684 (37.7202076512361, -122.441019880684) 9 7 6 28861 25
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
76214 37822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 10 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301) 9 7 6 28861 5
176834 37820 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003945.80086 2090498.97809 37.7203357084188 -122.428404441018 (37.7203357084188, -122.428404441018) 9 7 6 28861 5
92790 37817 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 5 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003961.27408 2090526.10251 37.7204110616965 -122.428352887393 (37.7204110616965, -122.428352887393) 9 7 6 28861 5
84190 253150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:41:00 AM 3 3x3   6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
104234 160065 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:13:00 AM 3 Width 0ft   6000417.53141 2090750.67913 37.7208265358932 -122.440618525839 (37.7208265358932, -122.440618525839) 9 7 6 28861 25
99068 176488 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 295 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 09:25:00 AM 3 Width 2ft   6004452.71642 2090718.28415 37.7209665468512 -122.4266678079 (37.7209665468512, -122.4266678079) 9 7 6 28861 5
27543 83558 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 483 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 7 3x3 Permit Number 52321 6001949.50225 2090800.06366 37.7210492547906 -122.435326507535 (37.7210492547906, -122.435326507535) 9 7 6 28861 5
133607 83264 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 483 Paris St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52321 6001958.21107 2090814.31383 37.7210888771378 -122.43529742254 (37.7210888771378, -122.43529742254) 9 7 6 28861 5
80180 160063 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:07:00 AM 3 Width 0ft   6000471.59074 2090857.95331 37.7211241647202 -122.440439349407 (37.7211241647202, -122.440439349407) 9 7 6 28861 25
117585 160061 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 11:02:00 AM 3 Width 0ft   6000547.45442 2091000.21878 37.7215191128017 -122.440187308101 (37.7215191128017, -122.440187308101) 9 7 6 28861 25
41858 83563 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 422 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2012 12:00:00 AM 5 3x3 Permit Number 769753 6002333.87212 2090986.92404 37.7215841526661 -122.434011205875 (37.7215841526661, -122.434011205875) 9 7 6 28861 5
122431 160059 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1000 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 10:50:00 AM 3 Width 0ft   6000588.55744 2091082.64129 37.7217477663201 -122.440051133668 (37.7217477663201, -122.440051133668) 9 7 6 28861 25
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
111712 253162 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 323 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004481 2091226 37.7223622223708 -122.426606175157 (37.7223622223708, -122.426606175157) 9 7 6 28861 5
131707 52954 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 975 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.11633 37.7224704120511 -122.439451120374 (37.7224704120511, -122.439451120374) 9 7 6 28861 25
140514 95742 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 86 Ina Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767488 6004830.44311 2091416.58174 37.7229052675357 -122.425411786848 (37.7229052675357, -122.425411786848) 9 7 6 28861 5
13726 80104 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 425 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 52309 6003144.80516 2091503.70271 37.7230491006299 -122.43124489935 (37.7230491006299, -122.43124489935) 9 7 6 28861 5
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
85730 43321 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 283 Athens St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2007 12:00:00 AM 5 3x3 Permit Number 49915 6004368.56572 2091597.24704 37.7233752280736 -122.427021263027 (37.7233752280736, -122.427021263027) 9 7 6 28861 5
29101 176889 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 277 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004392.5622 2091665.65248 37.7235644112504 -122.426943181195 (37.7235644112504, -122.426943181195) 9 7 6 28861 5
185386 83364 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 319 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 6 3x3 Permit Number 52323 6002520.66221 2091711.14442 37.7235832988126 -122.433417250421 (37.7235832988126, -122.433417250421) 9 7 6 28861 5

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