143 rows where qSpecies_id = 304 sorted by SiteOrder

View and edit SQL

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)
50023 87297 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 4227 Lincoln Way   Sidewalk: Curb side : Cutout Tree Private 2   10/16/2014 12:00:00 AM 3 3x3 Permit Number 773956 5982573 2106897.6 37.7641292203973 -122.50349567213 (37.7641292203973, -122.50349567213) 1 8 3 56 35
147116 258205 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2434 41st Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2019 12:00:00 AM 3 3x3 Permit Number 783175 5983652.70062 2098576.97166 37.7413465052475 -122.499146511806 (37.7413465052475, -122.499146511806) 1 8 3 29491 35
7405 27583 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1781 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 5 3X3   6001531.97079 2112100.50741 37.7795114663002 -122.438294983579 (37.7795114663002, -122.438294983579) 15 5 11 29490 41
7625 31171 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 100 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34871 5993759.19888335 2089860.63162869 37.7180012684503 -122.463569614328 (37.7180012684503, -122.463569614328) 9 8 6 64 24
8617 72845 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2625 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5989234.0157 2097465.6374 37.7386209048407 -122.479767197253 (37.7386209048407, -122.479767197253) 1 8 3 29491 35
10760 31310 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 577 Birch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 0   Permit Number 34948 6005032.34705274 2111420.35666119 37.7778424079953 -122.4261372481 (37.7778424079953, -122.4261372481) 7 9 11 28852 10
15804 250985 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 169 Seal Rock Dr 1 : Tree Private 2     5 Width 3ft   5981053.81587 2112927.80421 37.7805969621145 -122.509197833038 (37.7805969621145, -122.509197833038) 11 6 2 55 26
16628 43623 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 210 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2000 12:00:00 AM     Permit Number 43272                    
26551 40541 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 389 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/2005 12:00:00 AM     Permit Number 48035 5992634.70647519 2093966.0670834 37.7292089323345 -122.467754881103 (37.7292089323345, -122.467754881103) 9 8 4 59 40
26585 39836 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2048 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM     Permit Number 41158 5981224.57274912 2101126.86261798 37.7482050538241 -122.507731152524 (37.7482050538241, -122.507731152524) 1 8 3 29491 35
28700 119904 Undocumented 4 Melaleuca nesophila :: Pink Melaleuca 304 517 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003302 2096146 37.7358047110715 -122.431032679091 (37.7358047110715, -122.431032679091) 2 7 5 63 7
32466 39815 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2090 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM 6   Permit Number 41146 5982333.7204 2100889.1498 37.7476176430491 -122.503878215538 (37.7476176430491, -122.503878215538) 1 8 3 29491 35
34851 98357 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 4201 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5981815.8 2104809.3 37.7583508013597 -122.505959722614 (37.7583508013597, -122.505959722614) 1 8 3 56 35
36692 31305 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 561 Birch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 0   Permit Number 34946 6005105.48028119 2111430.55673025 37.7778745481219 -122.425884980842 (37.7778745481219, -122.425884980842) 7 9 11 28852 10
39168 184530 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 4045 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5981394.5999 2102116.7749 37.7509330899515 -122.507216642728 (37.7509330899515, -122.507216642728) 1 8 3 29491 35
45362 193542 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 610 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6016043.65792 2103986.82395 37.7580477514291 -122.387526213378 (37.7580477514291, -122.387526213378) 10 3 8 28856 29
45790 46376 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2231 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 6   Permit Number 44613 5982943.5226 2099924.3833 37.7450044993486 -122.501698223647 (37.7450044993486, -122.501698223647) 1 8 3 29491 35
47196 232034 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 5 Clarendon Ave 1 Sidewalk: Curb side : Yard Tree Private 2     14 Width 2ft   5998231.75186 2104660.34285 37.7588944118522 -122.449175639859 (37.7588944118522, -122.449175639859) 15 5 4 28862 38
47245 37087 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1431 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39687 5981822.5647819 2105347.10091721 37.7598278475269 -122.50597620053 (37.7598278475269, -122.50597620053) 1 8 3 56 35
47286 40218 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 139 Seal Rock Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1999 12:00:00 AM     Permit Number 41397 5981206.29115693 2112930.16439571 37.7806124308083 -122.508670533035 (37.7806124308083, -122.508670533035) 11 6 2 55 26
47427 40023 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1571 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 5   Permit Number 41268 6015526.3634 2095776.2911 37.7354746704031 -122.388742090508 (37.7354746704031, -122.388742090508) 10 3 8 58 1
48044 43824 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2539 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2000 12:00:00 AM     Permit Number 43452 5985490.59688758 2097934.34218836 37.7396896615859 -122.492744480822 (37.7396896615859, -122.492744480822) 1 8 3 29491 35
50721 31638 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2562 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35155 5981524.37597425 2097644.9749882 37.7386624172308 -122.506436285686 (37.7386624172308, -122.506436285686) 1 8 3 29491 35
50838 31635 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2538 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35152 5981511.7242527 2097800.56430497 37.7390888776464 -122.506491564023 (37.7390888776464, -122.506491564023) 1 8 3 29491 35
53444 31642 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 3601 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35157 5982065.15070434 2098736.73871701 37.7416919237879 -122.504647444825 (37.7416919237879, -122.504647444825) 1 8 3 29491 35
56030 183035 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2522 Lower Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5981504.4178 2097898.5163 37.7393573965741 -122.506524088332 (37.7393573965741, -122.506524088332) 1 8 3 29491 35
58613 232033 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 517 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003277.43124 2096153.40981 37.7358236645184 -122.431118151596 (37.7358236645184, -122.431118151596) 2 7 5 63 7
60249 39996 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 870 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41254 6019158.47829216 2094538.87688533 37.7322776068337 -122.376098579608 (37.7322776068337, -122.376098579608) 10 3 8 58 1
60427 38919 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 739 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/2002 12:00:00 AM     Permit Number 40729 5994644.0321122 2089899.68618843 37.7181594465135 -122.460513981509 (37.7181594465135, -122.460513981509) 9 8 6 28861 24
60730 114671 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 85X Peralta Ave 1 Side Yard : Yard Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 775155 6010502.29579 2100335.12269 37.7477125069204 -122.406433397576 (37.7477125069204, -122.406433397576) 2 7 7 28859 2
60747 31627 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2430 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM 0   Permit Number 35144 5981797.10260903 2098537.8771738 37.7411301336904 -122.505559512184 (37.7411301336904, -122.505559512184) 1 8 3 29491 35
61579 37484 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1246 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39953 5990822.12261544 2106914.97361747 37.7646584370326 -122.474965909131 (37.7646584370326, -122.474965909131) 11 8 11 56 12
61763 37119 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 4731 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39709 5981101.19035238 2106191.54023256 37.7621039464825 -122.508533725105 (37.7621039464825, -122.508533725105) 1 8 3 56 35
63875 43626 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2222 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM 7   Permit Number 43275 5985464.7649 2100074.5033 37.7455644571804 -122.49299140272 (37.7455644571804, -122.49299140272) 1 8 3 29491 35
63876 37113 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 4523 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39706 5981665.2 2106185.8 37.7621214108202 -122.506582640723 (37.7621214108202, -122.506582640723) 1 8 3 56 35
64173 37248 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 3038 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39801 5985578.39129143 2101634.00517992 37.7498530704582 -122.492713344722 (37.7498530704582, -122.492713344722) 1 8 3 29491 35
64734 47907 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 746 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2002 12:00:00 AM 7   Permit Number 45646 6000056.4472 2111499.7732 37.7777779701242 -122.4433562713 (37.7777779701242, -122.4433562713) 15 5 11 29490 16
65169 43610 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2174 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM     Permit Number 43264 5986078.58326706 2100441.09799391 37.746606905592 -122.490895913514 (37.746606905592, -122.490895913514) 1 8 3 29491 35
68371 80263 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2074 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50734 5982335.751 2100990.6763 37.7478965259448 -122.503878712284 (37.7478965259448, -122.503878712284) 1 8 3 29491 35
73709 31634 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2526 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35151 5981505.3983929 2097878.35895124 37.7393021077999 -122.506519203426 (37.7393021077999, -122.506519203426) 1 8 3 29491 35
74167 218220 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 300 Claremont Blvd 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   5993448.22771 2098043.70132 37.7404520434185 -122.465238556823 (37.7404520434185, -122.465238556823) 1 8 4 59 40
74428 46398 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2363 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/2002 12:00:00 AM     Permit Number 44628 5982038.69993379 2099019.08157606 37.7424656032555 -122.504759817001 (37.7424656032555, -122.504759817001) 1 8 3 29491 35
79593 37811 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 354 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40131 6004085.30799236 2091240.01678916 37.7223783311972 -122.427974988755 (37.7223783311972, -122.427974988755) 9 7 6 28861 5
81575 38360 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1610 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM     Permit Number 41156 5980983.59087853 2104088.99570474 37.7563240309044 -122.508784338324 (37.7563240309044, -122.508784338324) 1 8 3 56 35
87453 183353 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 3542 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5982133.0347 2100158.2902 37.7455991034071 -122.504518023708 (37.7455991034071, -122.504518023708) 1 8 3 29491 35
89838 49454 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 277@ BLANKEN Wheeler Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2003 12:00:00 AM 7   Permit Number 46388 6012179.13947 2087360.93121 37.7121817262883 -122.399724079808 (37.7121817262883, -122.399724079808) 10 3 8 309 1
92457 27582 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1777 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 5 3X3   6001533.8276 2112150.0507 37.7796476052413 -122.438292110376 (37.7796476052413, -122.438292110376) 15 5 11 29490 41
93100 35511 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 3484 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38913 6005154.64040446 2103144.1330954 37.75512478765 -122.42512515814 (37.75512478765, -122.42512515814) 2 4 5 28859 19
95363 210092 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 261 Granada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5995627.09016 2091704.91878 37.7231726926508 -122.457246512943 (37.7231726926508, -122.457246512943) 9 8 4 28861 24
98812 31632 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2518 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35149 5981501.18115239 2097930.22205683 37.7394442612499 -122.506537629785 (37.7394442612499, -122.506537629785) 1 8 3 29491 35
98951 35513 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 3488 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/2006 12:00:00 AM     Permit Number 38915 6005128.06949501 2103142.26204564 37.755118149138 -122.425216915019 (37.755118149138, -122.425216915019) 2 4 5 28859 19
110012 47074 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 106 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 0   Permit Number 45062 5996796.88091549 2112360.28017641 37.7799542788822 -122.454694357616 (37.7799542788822, -122.454694357616) 15 6 2 54 16
111078 40210 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 418 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1999 12:00:00 AM     Permit Number 41392 5981924.63262302 2112926.84029829 37.7806456178699 -122.506185243392 (37.7806456178699, -122.506185243392) 11 6 2 55 26
114045 43057 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1922 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/2010 12:00:00 AM 5 3x3 Permit Number 53821 5981365.4957 2101971.9303 37.7505336732727 -122.507306541093 (37.7505336732727, -122.507306541093) 1 8 3 29491 35
120686 31636 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2542 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37115 5981513.83287394 2097774.63274006 37.7390178008812 -122.506482350919 (37.7390178008812, -122.506482350919) 1 8 3 29491 35
122211 40219 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 165 Seal Rock Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1999 12:00:00 AM     Permit Number 41398 5981062.91201163 2112924.76539407 37.7805891547083 -122.509166139987 (37.7805891547083, -122.509166139987) 11 6 2 55 26
126706 37633 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 793 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40051 5990357.97842308 2109989.05024853 37.7730721073475 -122.476795862973 (37.7730721073475, -122.476795862973) 11 6 2 55 26
127757 39831 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1900 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM     Permit Number 41153 5981364.12857436 2102124.06115885 37.7509513011754 -122.507322554156 (37.7509513011754, -122.507322554156) 1 8 3 29491 35
128193 27691 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1765 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 7 3X3   6001581.2067 2112155.8038 37.779666096456 -122.438128618136 (37.779666096456, -122.438128618136) 15 5 11 29490 41
128694 46380 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2491 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 9   Permit Number 44617 5983004.0718 2098197.5632 37.7402666818538 -122.501361148049 (37.7402666818538, -122.501361148049) 1 8 3 29491 35
130685 35514 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 3492 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38916 6005101.49857239 2103140.39099496 37.7551115105514 -122.425308671927 (37.7551115105514, -122.425308671927) 2 4 5 28859 19
135160 48954 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1425 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/26/2002 12:00:00 AM     Permit Number 46141 6009586.08390989 2100908.24074194 37.7492348647629 -122.409642067631 (37.7492348647629, -122.409642067631) 2 4 7 28859 19
139470 15069 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1X Minerva St 1 Median : Cutout Tree DPW 1     12 11   5995941.11063 2089006.67134 37.715781972331 -122.455966040227 (37.715781972331, -122.455966040227) 9 8 6 28861 24
140436 46391 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2474 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 6   Permit Number 44624 5982733.735 2098287.5322 37.7404978321239 -122.502302505611 (37.7404978321239, -122.502302505611) 1 8 3 29491 35
141671 31308 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 569 Birch St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 0   Permit Number 34947 6005068.91365842 2111425.45669453 37.7778584781223 -122.426011114528 (37.7778584781223, -122.426011114528) 7 9 11 28852 10
145667 37115 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 4540 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39707 5981688.69009077 2106263.69511954 37.7623366715481 -122.506507175967 (37.7623366715481, -122.506507175967) 1 8 3 56 35
148562 31628 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2518 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35145 5981817.84640139 2097939.09313644 37.7394872587943 -122.505443416468 (37.7394872587943, -122.505443416468) 1 8 3 29491 35
148981 40206 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 540 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1999 12:00:00 AM     Permit Number 41388 5982575.37732497 2112101.53347145 37.7784178547501 -122.503872900243 (37.7784178547501, -122.503872900243) 11 6 2 55 26
152917 37635 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 797 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40053 5990358.92841621 2109962.95608948 37.7730005150319 -122.476790669979 (37.7730005150319, -122.476790669979) 11 6 2 55 26
153787 34825 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 3607 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1998 12:00:00 AM 12   Permit Number 38713 5984347.22188 2113130.44202 37.7813469659664 -122.497819514139 (37.7813469659664, -122.497819514139) 11 6 2 55 26
157007 39993 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 860 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM     Permit Number 41251 6019175.31340513 2094526.32452806 37.7322440672923 -122.376039506051 (37.7322440672923, -122.376039506051) 10 3 8 58 1
157065 39998 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 880 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41256 6019141.64317919 2094551.4292426 37.7323111463453 -122.376157653218 (37.7323111463453, -122.376157653218) 10 3 8 58 1
160239 40202 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 409 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/30/1999 12:00:00 AM 7   Permit Number 41384 5982801.49084 2112996.87637 37.7808894968635 -122.503157008013 (37.7808894968635, -122.503157008013) 11 6 2 55 26
161623 46393 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2483 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 11   Permit Number 44625 5982691.0939 2098244.5526 37.7403773164485 -122.502446759303 (37.7403773164485, -122.502446759303) 1 8 3 29491 35
163438 39825 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2311 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM     Permit Number 41150 5982026.95424167 2099360.52748006 37.7434024282005 -122.504825724634 (37.7434024282005, -122.504825724634) 1 8 3 29491 35
164172 49208 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1425 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46297 5998885.49389444 2108307.84265086 37.7689469010177 -122.447177209779 (37.7689469010177, -122.447177209779) 15 5 11 29492 9
170307 31639 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2594 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35156 5981541.24493631 2097437.52256583 37.738093803256 -122.506362582222 (37.738093803256, -122.506362582222) 1 8 3 29491 35
171636 38353 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 1800 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/31/1998 12:00:00 AM     Permit Number 40421 5981341.25756614 2102804.1865841 37.7528173861664 -122.507452100184 (37.7528173861664, -122.507452100184) 1 8 3 56 35
173300 15075 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 42 Minerva St 1 Median : Cutout Tree DPW 1     6 11   5996338.3066231 2089041.3064001 37.7158998615697 -122.454595656346 (37.7158998615697, -122.454595656346) 9 8 6 28861 24
174674 46406 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2443 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM 3 3x3 Permit Number 51149 5982682.2949 2098486.1858 37.7410402578887 -122.502495061788 (37.7410402578887, -122.502495061788) 1 8 3 29491 35
175675 43625 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 2218 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM 8   Permit Number 43274 5985464.7649 2100091.9996 37.7456124972844 -122.492992691297 (37.7456124972844, -122.492992691297) 1 8 3 29491 35
176489 51245 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 35 Majestic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/17/2004 12:00:00 AM     Permit Number 47620 5997371.20755939 2089722.08093206 37.7178282993487 -122.451074550694 (37.7178282993487, -122.451074550694) 9 8 6 28861 24
176738 37132 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 4447 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39714 5981086.08651436 2104832.07084282 37.7583703439041 -122.508485038953 (37.7583703439041, -122.508485038953) 1 8 3 56 35
176901 31633 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2522 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35150 5981503.28977265 2097904.29050404 37.7393731845257 -122.506528416597 (37.7393731845257, -122.506528416597) 1 8 3 29491 35
177399 31631 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2506 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/09/2000 12:00:00 AM     Permit Number 35148 5981494.85529112 2098008.01672128 37.7396574914298 -122.506565269459 (37.7396574914298, -122.506565269459) 1 8 3 29491 35
186962 43216 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 44 Dunsmuir St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM     Permit Number 43006 6008111.99433178 2094081.5468642 37.7304075516846 -122.41425657074 (37.7304075516846, -122.41425657074) 9 3 7 309 28
187001 44259 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 401 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2001 12:00:00 AM     Permit Number 43691 6001829.66372376 2103503.31899472 37.7559226344565 -122.436649584408 (37.7559226344565, -122.436649584408) 2 4 5 28862 22
188560 31626 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 2562 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1995 12:00:00 AM     Permit Number 35143 5982137.33816038 2097664.20833434 37.7387512967497 -122.504318413963 (37.7387512967497, -122.504318413963) 1 8 3 29491 35
188625 250990 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 418 45th Ave 1 : Tree Private 2     7 Width 3ft   5981922.57195 2112909.00953 37.7805965385427 -122.506191049593 (37.7805965385427, -122.506191049593) 11 6 2 55 26
19386 193544 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 900x Carolina St 10 Median : Yard Tree DPW 1     22     6012476.68739 2103624.07862 37.7568535209843 -122.399836927655 (37.7568535209843, -122.399836927655) 10 3 8 28856 29
148809 193548 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1300x De Haro St 12 Median : Yard Tree DPW 1     1     6012271.58863 2102171.1791 37.7528527402726 -122.400444188549 (37.7528527402726, -122.400444188549) 10 3 8 28856 29
122318 210100 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 700 Junipero Serra Blvd 125 : Tree Private 2     6 Width 0ft   5991216.87042 2091758.40738 37.7230652785221 -122.472495529943 (37.7230652785221, -122.472495529943) 9 8 4 64 40
25925 210093 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1x Minerva St 16 Median : Cutout Tree DPW 1     7 Width 0ft   5996144.00036 2089001.40747 37.715779161942 -122.455264383739 (37.715779161942, -122.455264383739) 9 8 6 28861 24
92789 193545 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 900x Carolina St 16 Median : Yard Tree DPW 1     14     6012471.27665 2103561.30428 37.7566808547541 -122.399851232248 (37.7566808547541, -122.399851232248) 10 3 8 28856 29
154787 210094 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 1x Minerva St 17 Median : Cutout Tree DPW 1     10 Width 0ft   5996151.37066 2089000.97081 37.7157783858469 -122.455238877198 (37.7157783858469, -122.455238877198) 9 8 6 28861 24
79028 210098 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 400 Junipero Serra Blvd 18 : Tree Private 2     17 Width 0ft   5991367.91013 2094058.78209 37.7293902761378 -122.472141017221 (37.7293902761378, -122.472141017221) 9 8 4 64 40
29792 24841 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 200X Alemany Blvd 19 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7   01/12/1996 12:00:00 AM 8 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
6845 31172 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 100 Shields St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34871 5993759.19888335 2089860.63162869 37.7180012684503 -122.463569614328 (37.7180012684503, -122.463569614328) 9 8 6 64 24
14501 31307 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 569 Birch St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 0   Permit Number 34947 6005068.91365842 2111425.45669453 37.7778584781223 -122.426011114528 (37.7778584781223, -122.426011114528) 7 9 11 28852 10
24353 34824 DPW Maintained 1 Melaleuca nesophila :: Pink Melaleuca 304 3607 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/10/1998 12:00:00 AM 10   Permit Number 38713 5984365.3802 2113132.09169 37.7813525599643 -122.49775681803 (37.7813525599643, -122.49775681803) 11 6 2 55 26

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