trees

513 rows where qLegalStatus_id = 7 and qSpecies_id = 53 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

qLegalStatus_id ✖

  • Permitted Site · 513 ✖
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)
9205 96542 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
11874 110985 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
13161 4609 Permitted Site 7 Ficus nitida :: Laurel Fig 53 316 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2015 12:00:00 AM 3 3X3 Permit Number 774670 6010771.0363 2118706.95943 37.7981723635161 -122.406798689949 (37.7981723635161, -122.406798689949) 3 1 10 308 23
18979 110983 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
21287 23131 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610X Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1999 12:00:00 AM 3 4x4   6010622.64357 2118948.98987 37.7988286159864 -122.407329246317 (37.7988286159864, -122.407329246317) 3 1 10 308 23
25834 93215 Permitted Site 7 Ficus nitida :: Laurel Fig 53 499 Jackson St   Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53209 6011715 2118034 37.7963773511427 -122.403484907832 (37.7963773511427, -122.403484907832) 3 1 10 28860 4
25882 40606 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48110 6011762.49765618 2117875.03517526 37.7959435248288 -122.403309366526 (37.7959435248288, -122.403309366526) 3 1 10 28860 4
26107 21817 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2683 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008202.62871 2121958.17011 37.8069553278433 -122.4159165161 (37.8069553278433, -122.4159165161) 5 1 10 308 23
28833 21815 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2653 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008264.14138 2121978.44796 37.8070144637358 -122.415705074993 (37.8070144637358, -122.415705074993) 5 1 10 308 23
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32
31137 4747 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1199X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     22 3X4   6007816.30894 2121179.41413 37.8047953349468 -122.417198239329 (37.8047953349468, -122.417198239329) 5 1 1 308 32
31247 106090 Permitted Site 7 Ficus nitida :: Laurel Fig 53 615 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012797.6 2118350.4 37.7973065196251 -122.399761086072 (37.7973065196251, -122.399761086072) 3 1 10 28860 6
34305 102625 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6010349.4 2120908.5 37.804193651889 -122.408413053021 (37.804193651889, -122.408413053021) 3 1 10 308 23
35514 110994 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
37194 4729 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1075 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008196.257 2120907.29394 37.8040695291651 -122.41586410452 (37.8040695291651, -122.41586410452) 5 1 10 308 32
38641 102621 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
44244 110995 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
45310 11177 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
49389 11091 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1906 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007294.23278 2118880.01642 37.7984523847496 -122.418841764779 (37.7984523847496, -122.418841764779) 5 1 10 28858 32
52775 18497 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6010150.58942 2115513.37022 37.7893688066449 -122.408720210327 (37.7893688066449, -122.408720210327) 5 1 10 28857 21
53203 110987 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
53504 11175 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
55775 44125 Permitted Site 7 Ficus nitida :: Laurel Fig 53 431 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43629 6012046.82946857 2118068.4414971 37.796490448112 -122.402339123693 (37.796490448112, -122.402339123693) 3 1 10 28860 4
56045 108604 Permitted Site 7 Ficus nitida :: Laurel Fig 53 625 LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6008310.7 2114660.6 37.7869240847944 -122.415025652231 (37.7869240847944, -122.415025652231) 13 1 9 28858 36
57727 4728 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1075 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008196.257 2120907.29394 37.8040695291651 -122.41586410452 (37.8040695291651, -122.41586410452) 5 1 10 308 32
57914 106105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744x MONTGOMERY ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6011751.6 2117873.5 37.7959387009634 -122.403346966666 (37.7959387009634, -122.403346966666) 3 1 10 28860 4
61232 12996 Permitted Site 7 Ficus nitida :: Laurel Fig 53 340 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6010677.76597 2120690.63206 37.8036138232581 -122.407261344489 (37.8036138232581, -122.407261344489) 3 1 10 308 23
63395 21810 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2627 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008310.29957 2121825.65474 37.806597526846 -122.415534509856 (37.806597526846, -122.415534509856) 5 1 10 308 23
65967 21814 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2653 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008264.14138 2121978.44796 37.8070144637358 -122.415705074993 (37.8070144637358, -122.415705074993) 5 1 10 308 23
67256 110998 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
70668 21818 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2693 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008270.97753 2122039.96134 37.8071837481777 -122.415685775277 (37.8071837481777, -122.415685775277) 5 1 10 308 23
73243 110988 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
74708 52076 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2005 12:00:00 AM     Permit Number 48272 6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
79809 4593 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     90 3X3   6011460.12974 2118136.30046 37.7966440043551 -122.404374021953 (37.7966440043551, -122.404374021953) 3 1 10 308 4
82985 51836 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
84456 254739 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009970 2119286 37.7997174141149 -122.409611414659 (37.7997174141149, -122.409611414659) 3 1 10 308 4
85015 21812 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2631 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008221.30715 2121822.90168 37.806584965078 -122.415842290697 (37.806584965078, -122.415842290697) 5 1 10 308 23
88657 110984 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
90288 9941 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 5x6 Resulted descion 9/7/16 -DE 6010050.95997 2119172.47111 37.7994102279433 -122.409323246083 (37.7994102279433, -122.409323246083) 3 1 10 308 4
96003 4693 Permitted Site 7 Ficus nitida :: Laurel Fig 53 781 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6009263.30605 2120079.28345 37.801855948749 -122.412112938993 (37.801855948749, -122.412112938993) 3 1 10 308 23
96257 4573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     75 4   6011767.886 2117749.45401 37.7955990100454 -122.403281883117 (37.7955990100454, -122.403281883117) 3 1 10 28860 4
103458 59152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/02/1980 12:00:00 AM 12 3x3 Permit Number 18461 6009909.46799044 2121095.5996991 37.8046827351828 -122.409948693589 (37.8046827351828, -122.409948693589) 3 1 10 308 23
104635 9944 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601X Green St 4 Sidewalk: Curb side : Cutout Tree Private 2     80 3X3   6010102.57699 2119179.92896 37.7994335971632 -122.409145158717 (37.7994335971632, -122.409145158717) 3 1 10 308 4
107778 51837 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
110473 49870 Permitted Site 7 Ficus nitida :: Laurel Fig 53 607@ JACKSON Front St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2003 12:00:00 AM     Permit Number 46636 6012838.36008757 2118235.08187981 37.7969921557212 -122.399611944085 (37.7969921557212, -122.399611944085) 3 1 10 28860 6
118093 102618 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
118656 96541 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
120103 40159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2211 Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1999 12:00:00 AM     Permit Number 41353 6009783.18603588 2121626.8328918 37.8061342908169 -122.410423240295 (37.8061342908169, -122.410423240295) 3 1 10 308 23
122892 21816 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2669 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008202.59065 2121958.17011 37.8069553257036 -122.415916647815 (37.8069553257036, -122.415916647815) 5 1 10 308 23
126032 110991 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
126620 13077 Permitted Site 7 Ficus nitida :: Laurel Fig 53 645X Lombard St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
128036 4704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 940 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008705.2823 2120549.3769 37.8031153821632 -122.414077244448 (37.8031153821632, -122.414077244448) 3 1 10 308 23
131150 51835 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
135761 11176 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
136446 110992 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
138529 4746 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1199X Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3X4   6007816.30894 2121179.41413 37.8047953349468 -122.417198239329 (37.8047953349468, -122.417198239329) 5 1 1 308 32
138984 110996 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
142193 102620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
146277 18498 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Powell St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6010152.17541 2115498.44033 37.7893279015823 -122.408713669265 (37.7893279015823, -122.408713669265) 5 1 10 28857 21
147035 13023 Permitted Site 7 Ficus nitida :: Laurel Fig 53 440 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2015 08:29:00 AM 3 4X4   6010228.79362 2120718.91833 37.8036663528767 -122.408817039093 (37.8036663528767, -122.408817039093) 3 1 10 308 23
150611 4595 Permitted Site 7 Ficus nitida :: Laurel Fig 53 170 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6011285.22621 2118219.63855 37.7968630551885 -122.404985101368 (37.7968630551885, -122.404985101368) 3 1 10 308 4
151684 4640 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   6010023.44398 2119255.15348 37.7996357117478 -122.409424299905 (37.7996357117478, -122.409424299905) 3 1 10 308 4
152048 92896 Permitted Site 7 Ficus nitida :: Laurel Fig 53 226 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2009 12:00:00 AM   3x3   6009506.8 2122067 37.8073273816355 -122.411410840149 (37.8073273816355, -122.411410840149) 3 1 10 308 23
155310 11113 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2037 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6007192.03327 2119340.88684 37.7997120641075 -122.41922811701 (37.7997120641075, -122.41922811701) 5 1 1 28858 32
157130 11034 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1509 HYDE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007406.1 2117518.3 37.7947197495209 -122.418358066687 (37.7947197495209, -122.418358066687) 5 1 10 28858 32
157239 44224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 150 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43669 6012974 2118691 37.7982515579635 -122.399174613744 (37.7982515579635, -122.399174613744) 3 1 10 28860 6
159917 122820 Permitted Site 7 Ficus nitida :: Laurel Fig 53 776 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009771.51732552 2115777.23613944 37.7900720800575 -122.410050397484 (37.7900720800575, -122.410050397484) 5 1 10 28857 21
163667 102619 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
168710 21809 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2627 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6008310.29957 2121825.65474 37.806597526846 -122.415534509856 (37.806597526846, -122.415534509856) 5 1 10 308 23
171851 110997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
172294 110990 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
182516 44225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43670 6013393.18767606 2119056.04835121 37.799277245684 -122.397749707821 (37.799277245684, -122.397749707821) 3 1 10 28860 6
183563 110986 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
190730 110993 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
191709 52838 Permitted Site 7 Ficus nitida :: Laurel Fig 53 795on Trenton Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48857 6010309.20673902 2118158.51574656 37.7966406195852 -122.408358059553 (37.7966406195852, -122.408358059553) 3 1 10 308 4
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
8874 15149 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
19070 15154 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 8 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
24140 32644 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
24565 10586 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Harrison St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     75 3X3   6011036.2882597 2110765.2479161 37.7763811461579 -122.405321269139 (37.7763811461579, -122.405321269139) 14 2 9 28853 34
24912 32645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
27832 15155 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
31550 15160 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 14 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
34792 15148 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
39348 97611 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
39622 15164 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 18 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
40083 49240 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 24 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
40156 49286 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 14 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
40462 48697 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
43665 94218 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 3 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
45235 15147 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
45439 49260 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
45931 49235 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
52966 66275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1065 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1990 12:00:00 AM   3x3 Permit Number 768678 6007678.31560988 2109516.6646006 37.7727645184447 -122.416848989215 (37.7727645184447, -122.416848989215) 8 2 9 28853 19
53416 48709 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
58538 15152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
58892 40350 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011468.97735143 2112560.39183232 37.7813343766323 -122.403950824176 (37.7813343766323, -122.403950824176) 6 2 9 28853 34

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