Street_Tree_List

Data source: data.sfgov.org

144 rows where qSpecies = 93

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
531 27691 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1765 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/2015 12:00:00 AM 7 3X3   6001581.2067 2112155.8038 37.779666096456 -122.438128618136 (37.779666096456, -122.438128618136)
5374 120897 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3760 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2016 12:00:00 AM 3 2x5 Permit Number 778876 6002560.418 2121574.39052 37.805582749215105 -122.43541504397301 (37.8055827492151, -122.435415043973)
6133 27582 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1777 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/2015 12:00:00 AM 5 3X3   6001533.8276 2112150.0507 37.7796476052413 -122.438292110376 (37.7796476052413, -122.438292110376)
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          
17904 27583 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1781 Turk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/25/2015 12:00:00 AM 5 3X3   6001531.97079 2112100.50741 37.7795114663002 -122.43829498357901 (37.7795114663002, -122.438294983579)
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)
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)
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)
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)
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)
27292 250990 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   5981922.57195 2112909.00953 37.7805965385427 -122.50619104959299 (37.7805965385427, -122.506191049593)
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)
30459 34825 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3607 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/10/1998 12:00:00 AM 12   Permit Number 38713 5984347.22188 2113130.44202 37.7813469659664 -122.49781951413901 (37.7813469659664, -122.497819514139)
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)
30918 117725 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 849 Clement St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5983504.07439 2113100.0545900003 37.7812140668155 -122.500734098102 (37.7812140668155, -122.500734098102)
31021 40202 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 409 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1999 12:00:00 AM 7   Permit Number 41384 5982801.49084 2112996.87637 37.7808894968635 -122.503157008013 (37.7808894968635, -122.503157008013)
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)
36904 31305 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 561 Birch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/1995 12:00:00 AM 0   Permit Number 34946 6005105.48028119 2111430.55673025 37.7778745481219 -122.425884980842 (37.7778745481219, -122.425884980842)
37360 34824 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 3607 Clement St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/10/1998 12:00:00 AM 10   Permit Number 38713 5984365.3802 2113132.09169 37.7813525599643 -122.49775681803001 (37.7813525599643, -122.49775681803)
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)
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)
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)
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)
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)
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)
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)
53256 47907 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 746 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2002 12:00:00 AM 7   Permit Number 45646 6000056.4472 2111499.7732 37.7777779701242 -122.44335627129999 (37.7777779701242, -122.4433562713)
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)
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)
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)
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)
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)
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)
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)
59532 250982 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 145 Seal Rock Dr 2 : 4 Tree 1 Private 1     6 Width 3ft   5981196.97714 2112934.78303 37.7806245632172 -122.50870309708901 (37.7806245632172, -122.508703097089)
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)
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)
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)
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)
71380 141700 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 150 BEAUMONT AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5996841.3555 2111986.1699 37.778929621332004 -122.454513467721 (37.778929621332, -122.454513467721)
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)
73512 122029 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 791 18th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5990357.66226 2109998.66338 37.773098484036495 -122.47679765911 (37.7730984840365, -122.47679765911)
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)
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)
78788 40218 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 139 Seal Rock Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41397 5981206.29115693 2112930.16439571 37.7806124308083 -122.50867053303499 (37.7806124308083, -122.508670533035)
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)
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)
80926 87297 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4227 Lincoln Way   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/16/2014 12:00:00 AM 3 3x3 Permit Number 773956 5982573.0 2106897.6 37.764129220397294 -122.50349567213001 (37.7641292203973, -122.50349567213)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
90351 37484 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1246 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/22/1998 12:00:00 AM     Permit Number 39953 5990822.12261544 2106914.97361747 37.7646584370326 -122.47496590913099 (37.7646584370326, -122.474965909131)
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)
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)
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)
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)
99708 30671 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 39 McCoppin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM     Permit Number 34597 6006368.06236527 2109117.19408355 37.7715938820876 -122.421352936259 (37.7715938820876, -122.421352936259)
100012 37107 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4501 Irving St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39705 5981809.38189346 2106215.79884963 37.7622122675222 -122.506086203855 (37.7622122675222, -122.506086203855)
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)
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)
103759 40210 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41392 5981924.63262302 2112926.84029829 37.780645617869894 -122.506185243392 (37.7806456178699, -122.506185243392)
104329 37633 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 793 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM     Permit Number 40051 5990357.97842308 2109989.05024853 37.773072107347495 -122.476795862973 (37.7730721073475, -122.476795862973)
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)
104871 40219 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 165 Seal Rock Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41398 5981062.91201163 2112924.76539407 37.780589154708295 -122.50916613998699 (37.7805891547083, -122.509166139987)
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)
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)
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)
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)
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)
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)
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)
110671 40211 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 418 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/1999 12:00:00 AM     Permit Number 41392 5981924.63262302 2112926.84029829 37.780645617869894 -122.506185243392 (37.7806456178699, -122.506185243392)
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)
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)
113920 40206 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 540 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/06/1999 12:00:00 AM     Permit Number 41388 5982575.37732497 2112101.53347145 37.778417854750096 -122.503872900243 (37.7784178547501, -122.503872900243)
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)
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)
120495 37116 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 4542 Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39708 5981682.74450716 2106263.49145698 37.762335762281 -122.506527724058 (37.762335762281, -122.506527724058)
121472 37635 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 797 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM     Permit Number 40053 5990358.92841621 2109962.95608948 37.7730005150319 -122.476790669979 (37.7730005150319, -122.476790669979)
121538 49208 Permitted Site 1 Melaleuca nesophila :: Pink Melaleuca 93 1425 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2003 12:00:00 AM     Permit Number 46297 5998885.49389444 2108307.84265086 37.768946901017706 -122.447177209779 (37.7689469010177, -122.447177209779)
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)
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)
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)
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)
128164 27505 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1761 Turk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2x2   6001633.12831 2112159.85861 37.779680182688104 -122.43794928965201 (37.7796801826881, -122.437949289652)
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)
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)
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)
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)
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)

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 58.991ms · Data source: data.sfgov.org