Street_Tree_List

Data source: data.sfgov.org

144 rows where qSpecies = 93 sorted by YCoord

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▼ Latitude Longitude Location
14525 43623 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 210 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2000 12:00:00 AM     Permit Number 43272          
149060 49454 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 277@ BLANKEN Wheeler Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/02/2003 12:00:00 AM 7   Permit Number 46388 6012179.13947 2087360.9312099998 37.71218172628829 -122.39972407980801 (37.7121817262883, -122.399724079808)
131557 210095 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 47 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5996479.95925 2088997.21564 37.7157869222034 -122.454102858955 (37.7157869222034, -122.454102858955)
169128 210094 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 17 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   5996151.37066 2089000.9708099999 37.715778385846896 -122.45523887719801 (37.7157783858469, -122.455238877198)
34976 210093 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 16 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   5996144.00036 2089001.40747 37.715779161942 -122.45526438373899 (37.715779161942, -122.455264383739)
20692 15069 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1X Minerva St 1 Median : Cutout 11 Tree 1 DPW 2     12 11   5995941.11063 2089006.6713400001 37.715781972331 -122.455966040227 (37.715781972331, -122.455966040227)
81132 15073 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 30X Minerva St 5 Median : Cutout 11 Tree 1 DPW 2     3 11   5996426.1222644 2089040.1488729 37.7159017196126 -122.45429204268801 (37.7159017196126, -122.454292042688)
138688 15075 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 42 Minerva St 1 Median : Cutout 11 Tree 1 DPW 2     6 11   5996338.306623099 2089041.3064001 37.7158998615697 -122.454595656346 (37.7158998615697, -122.454595656346)
89003 15081 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 80X Minerva St 2 Median : Cutout 11 Tree 1 DPW 2     3 11   5996060.1066716 2089044.9734463 37.7158939701237 -122.455557504311 (37.7158939701237, -122.455557504311)
139347 51245 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 35 Majestic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2004 12:00:00 AM     Permit Number 47620 5997371.20755939 2089722.08093206 37.7178282993487 -122.451074550694 (37.7178282993487, -122.451074550694)
18556 31172 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 100 Shields St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1995 12:00:00 AM     Permit Number 34871 5993759.19888335 2089860.63162869 37.7180012684503 -122.46356961432801 (37.7180012684503, -122.463569614328)
58677 31171 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 100 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/1995 12:00:00 AM     Permit Number 34871 5993759.19888335 2089860.63162869 37.7180012684503 -122.46356961432801 (37.7180012684503, -122.463569614328)
86051 38919 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 739 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/25/2002 12:00:00 AM     Permit Number 40729 5994644.0321122 2089899.68618843 37.7181594465135 -122.460513981509 (37.7181594465135, -122.460513981509)
97252 37811 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 354 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/1998 12:00:00 AM     Permit Number 40131 6004085.30799236 2091240.01678916 37.722378331197206 -122.427974988755 (37.7223783311972, -122.427974988755)
98714 38927 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 30 Lunado Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40735 5991530.391079799 2091455.54556163 37.7222518366051 -122.47138970523199 (37.7222518366051, -122.471389705232)
58602 210092 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 261 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5995627.09016 2091704.91878 37.72317269265079 -122.457246512943 (37.7231726926508, -122.457246512943)
159623 210100 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 700 Junipero Serra Blvd 125 : 4 Tree 1 Private 1     6 Width 0ft   5991216.87042 2091758.40738 37.7230652785221 -122.472495529943 (37.7230652785221, -122.472495529943)
40578 210099 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 700 Junipero Serra Blvd 70 : 4 Tree 1 Private 1     12 Width 0ft   5991230.12075 2092291.98484 37.72453111681111 -122.47248860785601 (37.7245311168111, -122.472488607856)
129115 40541 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 389 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/2005 12:00:00 AM     Permit Number 48035 5992634.70647519 2093966.0670834 37.7292089323345 -122.467754881103 (37.7292089323345, -122.467754881103)
75400 210098 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 400 Junipero Serra Blvd 18 : 4 Tree 1 Private 1     17 Width 0ft   5991367.910130001 2094058.78209 37.72939027613779 -122.47214101722099 (37.7293902761378, -122.472141017221)
142338 43216 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 44 Dunsmuir St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM     Permit Number 43006 6008111.99433178 2094081.5468642 37.73040755168461 -122.41425657074 (37.7304075516846, -122.41425657074)
182701 210097 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 300 Junipero Serra Blvd 46 : 4 Tree 1 Private 1     6 Width 0ft   5991383.70914 2094347.6763 37.7301844215576 -122.47210744821699 (37.7301844215576, -122.472107448217)
53662 210096 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 300 Junipero Serra Blvd 45 : 4 Tree 1 Private 1     4 Width 0ft   5991386.500659999 2094355.8588400001 37.73020705030461 -122.47209839385201 (37.7302070503046, -122.472098393852)
122101 39993 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 860 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/27/1999 12:00:00 AM     Permit Number 41251 6019175.31340513 2094526.32452806 37.73224406729229 -122.376039506051 (37.7322440672923, -122.376039506051)
86628 39996 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 870 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM     Permit Number 41254 6019158.47829216 2094538.87688533 37.7322776068337 -122.376098579608 (37.7322776068337, -122.376098579608)
117097 39998 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 880 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM     Permit Number 41256 6019141.64317919 2094551.4292426002 37.732311146345296 -122.376157653218 (37.7323111463453, -122.376157653218)
174219 40023 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1571 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM 5   Permit Number 41268 6015526.3634 2095776.2911 37.73547467040311 -122.388742090508 (37.7354746704031, -122.388742090508)
127824 24841 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 200X Alemany Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5   01/12/1996 12:00:00 AM 8 3X3   6009416.6826304 2095906.0445619 37.735490432624104 -122.409874802768 (37.7354904326241, -122.409874802768)
128271 119904 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 517 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003302.0 2096146.0 37.7358047110715 -122.43103267909099 (37.7358047110715, -122.431032679091)
71166 232033 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 517 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6003277.43124 2096153.4098099999 37.7358236645184 -122.431118151596 (37.7358236645184, -122.431118151596)
81901 31640 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2594 Great Hwy 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.50636258222201 (37.738093803256, -122.506362582222)
110105 31641 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2594 Great Hwy 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.50636258222201 (37.738093803256, -122.506362582222)
123186 31639 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2594 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.50636258222201 (37.738093803256, -122.506362582222)
57844 72845 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 2625 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1998 12:00:00 AM 10     5989234.0157 2097465.6374 37.7386209048407 -122.479767197253 (37.7386209048407, -122.479767197253)
80008 31638 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2562 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35155 5981524.37597425 2097644.9749882 37.7386624172308 -122.506436285686 (37.7386624172308, -122.506436285686)
139703 31626 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2562 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35143 5982137.33816038 2097664.20833434 37.738751296749705 -122.50431841396299 (37.7387512967497, -122.504318413963)
109535 31636 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2542 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM     Permit Number 37115 5981513.83287394 2097774.63274006 37.73901780088121 -122.506482350919 (37.7390178008812, -122.506482350919)
78297 31635 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2538 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35152 5981511.7242527 2097800.56430497 37.739088877646395 -122.506491564023 (37.7390888776464, -122.506491564023)
90838 31634 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2526 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35151 5981505.3983929 2097878.35895124 37.739302107799894 -122.506519203426 (37.7393021077999, -122.506519203426)
18168 28136 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 412 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     8 4X4   6006951.93492 2097890.14157 37.7407998823106 -122.41853703365 (37.7407998823106, -122.41853703365)
56108 183035 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 2522 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981504.4178 2097898.5163 37.7393573965741 -122.506524088332 (37.7393573965741, -122.506524088332)
142496 31633 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2522 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35150 5981503.28977265 2097904.29050404 37.739373184525704 -122.506528416597 (37.7393731845257, -122.506528416597)
102014 31632 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2518 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35149 5981501.18115239 2097930.22205683 37.7394442612499 -122.506537629785 (37.7394442612499, -122.506537629785)
79217 43824 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2539 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43452 5985490.59688758 2097934.34218836 37.7396896615859 -122.492744480822 (37.7396896615859, -122.492744480822)
114723 31628 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2518 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35145 5981817.84640139 2097939.09313644 37.7394872587943 -122.505443416468 (37.7394872587943, -122.505443416468)
140057 31631 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2506 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/09/2000 12:00:00 AM     Permit Number 35148 5981494.85529112 2098008.01672128 37.739657491429796 -122.506565269459 (37.7396574914298, -122.506565269459)
179294 218220 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 300 Claremont Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   5993448.22771 2098043.70132 37.7404520434185 -122.46523855682301 (37.7404520434185, -122.465238556823)
51621 46380 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2491 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 9   Permit Number 44617 5983004.0718 2098197.5632 37.7402666818538 -122.50136114804899 (37.7402666818538, -122.501361148049)
26121 46393 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2483 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 11   Permit Number 44625 5982691.0939 2098244.5526 37.740377316448495 -122.502446759303 (37.7403773164485, -122.502446759303)
178579 46391 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2474 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 6   Permit Number 44624 5982733.735 2098287.5322 37.7404978321239 -122.502302505611 (37.7404978321239, -122.502302505611)
54311 46406 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2443 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/03/2008 12:00:00 AM 3 3x3 Permit Number 51149 5982682.2949 2098486.1858 37.741040257888706 -122.50249506178801 (37.7410402578887, -122.502495061788)
28357 31627 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2430 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM 0   Permit Number 35144 5981797.10260903 2098537.8771738 37.7411301336904 -122.50555951218399 (37.7411301336904, -122.505559512184)
83318 31642 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3601 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825)
109235 31643 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3601 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825)
145753 31644 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3601 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825)
89643 46398 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2363 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/05/2002 12:00:00 AM     Permit Number 44628 5982038.69993379 2099019.08157606 37.7424656032555 -122.504759817001 (37.7424656032555, -122.504759817001)
104475 46397 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2363 46th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/05/2002 12:00:00 AM     Permit Number 44628 5982038.69993379 2099019.08157606 37.7424656032555 -122.504759817001 (37.7424656032555, -122.504759817001)
122518 39825 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2311 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41150 5982026.95424167 2099360.52748006 37.7434024282005 -122.504825724634 (37.7434024282005, -122.504825724634)
71672 46376 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2231 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 6   Permit Number 44613 5982943.5226 2099924.3833 37.7450044993486 -122.501698223647 (37.7450044993486, -122.501698223647)
42850 43626 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2222 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM 7   Permit Number 43275 5985464.7649 2100074.5033 37.7455644571804 -122.49299140272 (37.7455644571804, -122.49299140272)
30475 43625 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2218 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM 8   Permit Number 43274 5985464.7649 2100091.9996 37.7456124972844 -122.49299269129699 (37.7456124972844, -122.492992691297)
157211 183355 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3546 Rivera St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982088.9451 2100155.7156 37.74558944081421 -122.504670285508 (37.7455894408142, -122.504670285508)
60700 183354 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3544 Rivera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5982117.2654 2100157.6466 37.7455964086946 -122.504572502943 (37.7455964086946, -122.504572502943)
137755 183353 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3542 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982133.0347 2100158.2902 37.7455991034071 -122.504518023708 (37.7455991034071, -122.504518023708)
83587 114672 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 85X Peralta Ave 2 Side Yard : Yard 17 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.40643339757601 (37.7477125069204, -122.406433397576)
88155 114671 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 85X Peralta Ave 1 Side Yard : Yard 17 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.40643339757601 (37.7477125069204, -122.406433397576)
112258 114673 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 85X Peralta Ave 3 Side Yard : Yard 17 Tree 1 Private 1   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.40643339757601 (37.7477125069204, -122.406433397576)
86011 43610 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2174 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM     Permit Number 43264 5986078.58326706 2100441.09799391 37.746606905591996 -122.49089591351401 (37.746606905592, -122.490895913514)
136846 39815 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2090 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 6   Permit Number 41146 5982333.7204 2100889.1498 37.747617643049104 -122.50387821553801 (37.7476176430491, -122.503878215538)
112675 48954 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1425 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/26/2002 12:00:00 AM     Permit Number 46141 6009586.08390989 2100908.24074194 37.7492348647629 -122.409642067631 (37.7492348647629, -122.409642067631)
45817 39814 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2079 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 5   Permit Number 41145 5982286.3414 2100973.7552 37.747847159841704 -122.50404831238701 (37.7478471598417, -122.504048312387)
137605 80263 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2074 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50734 5982335.751 2100990.6763 37.747896525944796 -122.50387871228399 (37.7478965259448, -122.503878712284)
129052 39836 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 2048 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41158 5981224.57274912 2101126.86261798 37.7482050538241 -122.50773115252399 (37.7482050538241, -122.507731152524)
86529 37248 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3038 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM     Permit Number 39801 5985578.39129143 2101634.00517992 37.7498530704582 -122.492713344722 (37.7498530704582, -122.492713344722)
146438 43057 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1922 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/27/2010 12:00:00 AM 5 3x3 Permit Number 53821 5981365.4957 2101971.9303 37.750533673272706 -122.507306541093 (37.7505336732727, -122.507306541093)
61265 184530 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 4045 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5981394.5999 2102116.7749 37.7509330899515 -122.50721664272801 (37.7509330899515, -122.507216642728)
154502 184532 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 4041 Ortega St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5981429.119 2102119.1438 37.7509416273735 -122.507097450181 (37.7509416273735, -122.507097450181)
106401 39832 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1900 48th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156)
109875 39831 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1900 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156)
129256 39830 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1900 48th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156)
159827 193548 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1300x De Haro St 12 Median : Yard 3 Tree 1 DPW 2     1     6012271.58863 2102171.1791 37.7528527402726 -122.400444188549 (37.7528527402726, -122.400444188549)
141727 38353 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1800 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/31/1998 12:00:00 AM     Permit Number 40421 5981341.25756614 2102804.1865841 37.7528173861664 -122.507452100184 (37.7528173861664, -122.507452100184)
49522 193547 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 900x Carolina St 65 Median : Yard 3 Tree 1 DPW 2     11     6012516.839980001 2102871.66546 37.7547897972265 -122.39964523714501 (37.7547897972265, -122.399645237145)
40612 193546 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 900x Carolina St 56 Median : Yard 3 Tree 1 DPW 2     14     6012511.31155 2102952.5131599996 37.7550114792069 -122.39967003234699 (37.7550114792069, -122.399670032347)
107890 35514 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3492 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1998 12:00:00 AM     Permit Number 38916 6005101.49857239 2103140.39099496 37.7551115105514 -122.425308671927 (37.7551115105514, -122.425308671927)
100449 35513 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3488 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/21/2006 12:00:00 AM     Permit Number 38915 6005128.06949501 2103142.26204564 37.755118149138 -122.42521691501899 (37.755118149138, -122.425216915019)
91487 35511 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3484 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1998 12:00:00 AM     Permit Number 38913 6005154.64040446 2103144.1330954 37.75512478765 -122.42512515813999 (37.75512478765, -122.42512515814)
110594 44258 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 401 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43691 6001829.66372376 2103503.31899472 37.7559226344565 -122.436649584408 (37.7559226344565, -122.436649584408)
140746 44259 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 401 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM     Permit Number 43691 6001829.66372376 2103503.31899472 37.7559226344565 -122.436649584408 (37.7559226344565, -122.436649584408)
63329 193545 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 900x Carolina St 16 Median : Yard 3 Tree 1 DPW 2     14     6012471.27665 2103561.30428 37.7566808547541 -122.399851232248 (37.7566808547541, -122.399851232248)
27255 193544 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 900x Carolina St 10 Median : Yard 3 Tree 1 DPW 2     22     6012476.687390001 2103624.0786200003 37.75685352098429 -122.39983692765499 (37.7568535209843, -122.399836927655)
56979 193543 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 610 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6016026.74063 2103985.73325 37.7580438195766 -122.38758464502399 (37.7580438195766, -122.387584645024)
186695 193542 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 610 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6016043.65792 2103986.82395 37.7580477514291 -122.387526213378 (37.7580477514291, -122.387526213378)
94765 38360 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1610 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM     Permit Number 41156 5980983.59087853 2104088.99570474 37.756324030904395 -122.50878433832399 (37.7563240309044, -122.508784338324)
48730 38372 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4245 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 8   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
176806 38370 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4245 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 4   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
159177 232034 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 5 Clarendon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5998231.75186 2104660.34285 37.758894411852204 -122.449175639859 (37.7588944118522, -122.449175639859)
157813 98357 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4201 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   5981815.8 2104809.3 37.758350801359704 -122.50595972261401 (37.7583508013597, -122.505959722614)
140797 37132 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4447 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39714 5981086.08651436 2104832.07084282 37.7583703439041 -122.508485038953 (37.7583703439041, -122.508485038953)
84488 37087 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1431 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39687 5981822.5647819 2105347.10091721 37.7598278475269 -122.50597620053001 (37.7598278475269, -122.50597620053)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 70.077ms · Data source: data.sfgov.org