97 rows where qSpecies_id = 220

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)
2166 31480 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 449 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1995 12:00:00 AM 25   Permit Number 35046 6001532.47021 2103206.30931 37.7550902238546 -122.43765610507 (37.7550902238546, -122.43765610507) 2 4 5 28862 22
4275 131242 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2620 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6006191.94248 2119872.7088 37.8011159388976 -122.422726618061 (37.8011159388976, -122.422726618061) 13 9 1 28858 32
7346 64500 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1372 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/1988 12:00:00 AM 11   Permit Number 25379 6001262.0877 2110774.7946 37.7758560402215 -122.43913358008 (37.7758560402215, -122.43913358008) 15 5 11 29492 10
10240 210220 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 17 Median : Yard Tree DPW 1     15     5993632.14987 2096264.78649 37.7355781918881 -122.464473499973 (37.7355781918881, -122.464473499973) 1 8 4 59 40
11560 78369 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 245 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6000940.17628 2093456.50389 37.7282858627778 -122.439005723929 (37.7282858627778, -122.439005723929) 9 7 6 28861 25
11684 233270 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 141 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5999376.63712 2107387.11473 37.7664468644518 -122.445412171329 (37.7664468644518, -122.445412171329) 15 5 5 29492 9
16039 69164 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1238 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 9   Permit Number 33201 5982780 2106679 37.7635411745389 -122.502763548474 (37.7635411745389, -122.502763548474) 1 8 3 56 35
16136 69166 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1271 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 14   Permit Number 33203 5982701 2106473 37.7629709142729 -122.50302152824 (37.7629709142729, -122.50302152824) 1 8 3 56 35
16927 70177 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 775 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5994102.47966 2110307.2614 37.7741623246726 -122.463866362064 (37.7741623246726, -122.463866362064) 11 6 2 54 11
17351 65204 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 427 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 18 8x6 Permit Number 27190 6003408.12323 2091088.56591 37.7219241458761 -122.430305058353 (37.7219241458761, -122.430305058353) 9 7 6 28861 5
18811 66084 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 906 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM 8   Permit Number 29128 6008591.3659 2119365.8184 37.7998592271665 -122.414387661561 (37.7998592271665, -122.414387661561) 5 1 10 308 32
25157 42444 Permitted Site 7 Melaleuca styphelliodes :: Paperbark Tree 220 274 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42587 5999614.61516538 2095259.78997024 37.7331617542013 -122.443717725893 (37.7331617542013, -122.443717725893) 9 7 4 63 40
25900 233271 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1999X Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008081.71858 2107125.17106 37.7662207200341 -122.415284243389 (37.7662207200341, -122.415284243389) 8 4 7 28853 19
30673 131235 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1847 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008651.38709 2119297.64389 37.7996754084389 -122.414175139164 (37.7996754084389, -122.414175139164) 5 1 10 308 32
33776 210208 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 1 Median : Yard Tree DPW 1     20     5993586.63469 2096365.42652 37.7358519005501 -122.464638167637 (37.7358519005501, -122.464638167637) 1 8 4 59 40
35211 210206 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1935 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5990623.96071 2102216.84894 37.7517471488267 -122.475308263088 (37.7517471488267, -122.475308263088) 1 8 4 29491 12
35277 233275 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 3338 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006084.23539 2103190.69618 37.7553051087666 -122.4219136507 (37.7553051087666, -122.4219136507) 2 4 5 28859 19
36783 210219 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 16 Median : Yard Tree DPW 1     8     5993631.10512 2096269.3526 37.7355906690669 -122.464477443476 (37.7355906690669, -122.464477443476) 1 8 4 59 40
38582 233273 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1632 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6003325.28023 2098683.83264 37.742774335764 -122.431133273676 (37.742774335764, -122.431133273676) 2 7 5 63 22
45221 210223 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 774 Joost Ave 2 Sidewalk: Property side : Yard Tree Private 2     19 Width 6ft   5996962.54423 2095026.99719 37.7323709396507 -122.452869803021 (37.7323709396507, -122.452869803021) 9 7 4 59 40
45501 92747 Permitted Site 7 Melaleuca styphelliodes :: Paperbark Tree 220 355 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2009 12:00:00 AM   3x3 Permit Number 52974 6003597 2099499 37.7450279906275 -122.430251888107 (37.7450279906275, -122.430251888107) 2 7 5 63 22
51121 62719 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1241 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/1986 12:00:00 AM 17   Permit Number 23064 6007049.25916 2119100.9249 37.799045147362 -122.419705133412 (37.799045147362, -122.419705133412) 5 1 10 28858 32
51292 62720 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1248 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/1986 12:00:00 AM 14   Permit Number 23065 6007040.59573 2119151.91867 37.7991846753936 -122.419738732056 (37.7991846753936, -122.419738732056) 5 1 1 28858 32
51540 131234 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1644 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006848.52759 2116740.36777 37.7925523389696 -122.42023210734 (37.7925523389696, -122.42023210734) 13 9 10 28858 32
53529 233260 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 199 Albion St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005929.47501 2106212.7898 37.7635943417292 -122.422663607059 (37.7635943417292, -122.422663607059) 8 4 5 28859 19
54609 210205 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1254 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5992401.91385 2106903.6529 37.7647187802823 -122.469501055528 (37.7647187802823, -122.469501055528) 11 8 11 56 12
56053 233267 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 232 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5998996.53935 2106805.72426 37.7648288069218 -122.446685019601 (37.7648288069218, -122.446685019601) 15 5 11 29492 9
58551 233265 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 265 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004168.64682 2099535.20951 37.7451597758063 -122.428277815579 (37.7451597758063, -122.428277815579) 2 7 5 63 22
60462 210221 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 8 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5996497.2578 2089023.70435 37.7158606459308 -122.454044979494 (37.7158606459308, -122.454044979494) 9 8 6 28861 24
62385 210218 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 15 Median : Yard Tree DPW 1     8     5993624.56026 2096270.05795 37.7355922284988 -122.464500122577 (37.7355922284988, -122.464500122577) 1 8 4 59 40
63193 62721 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1267 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/1986 12:00:00 AM 18   Permit Number 23066 6006918.19748 2119084.0905 37.7989915405963 -122.420157456395 (37.7989915405963, -122.420157456395) 5 1 10 28858 32
63454 210217 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 14 Median : Yard Tree DPW 1     9     5993628.33761 2096273.38662 37.7356015859488 -122.464487304551 (37.7356015859488, -122.464487304551) 1 8 4 59 40
67421 210214 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 11 Median : Yard Tree DPW 1     13     5993627.90476 2096279.92768 37.7356195211226 -122.464489275855 (37.7356195211226, -122.464489275855) 1 8 4 59 40
68381 210203 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1325 18th Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5990490.48009 2106231.92477 37.762763743169 -122.476063069479 (37.762763743169, -122.476063069479) 1 8 3 56 12
73428 16041 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 179 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/21/1998 12:00:00 AM 12 3X3   6000886.95379 2094621.40787 37.7314813923334 -122.43927317783 (37.7314813923334, -122.43927317783) 9 7 4 63 40
75053 120088 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 427 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5987764.34917 2113095.89861 37.7814518502142 -122.485995536238 (37.7814518502142, -122.485995536238) 11 6 2 55 26
75055 68534 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 783 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 11   Permit Number 32416 5994104.89047 2110263.20368 37.7740414928265 -122.463854824123 (37.7740414928265, -122.463854824123) 11 6 2 54 11
77828 210211 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 8 Median : Yard Tree DPW 1     13     5993625.99863 2096284.22791 37.7356312186052 -122.464496178161 (37.7356312186052, -122.464496178161) 1 8 4 59 40
78162 62977 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1275 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1987 12:00:00 AM 13   Permit Number 24218 6006900.71443 2119079.36792 37.7989775884912 -122.420217618347 (37.7989775884912, -122.420217618347) 5 1 10 28858 32
78653 210204 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1635 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5993371.42748 2104353.81185 37.7577735661119 -122.465962496675 (37.7577735661119, -122.465962496675) 1 8 4 56 12
78791 65525 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 731 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1990 12:00:00 AM 19   Permit Number 28412 6001332.96165 2089313.54222 37.7169325676664 -122.437351314008 (37.7169325676664, -122.437351314008) 9 7 6 28861 5
79680 50029 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 230 Hale St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM 10   Permit Number 46760 6009426.37824 2094583.05612 37.7318583332774 -122.409747926927 (37.7318583332774, -122.409747926927) 10 3 7 309 28
80663 106729 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2810 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5999990.6806 2114417.3336 37.7857850890204 -122.443793441299 (37.7857850890204, -122.443793441299) 15 6 1 29490 31
80675 68876 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 786 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 10   Permit Number 32847 5994148.87586 2110271.46514 37.77406671124 -122.463703272021 (37.77406671124, -122.463703272021) 11 6 2 54 11
81451 131241 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2620 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6006196.80083 2119852.56199 37.8010608949909 -122.422708373509 (37.8010608949909, -122.422708373509) 13 9 1 28858 32
84427 68875 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 789 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM 12   Permit Number 32846 5994105.67349 2110236.94876 37.773969448925 -122.463850209447 (37.773969448925, -122.463850209447) 11 6 2 54 11
84458 69173 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1281 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 6   Permit Number 33212 5982410.4657 2106404.5636 37.7627659267139 -122.504021300228 (37.7627659267139, -122.504021300228) 1 8 3 56 35
84954 131243 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2622 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006189.07869 2119896.63301 37.8011814671135 -122.42273822918 (37.8011814671135, -122.42273822918) 13 9 1 28858 32
86134 233262 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 132 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005878.98658 2106459.60731 37.7642691956966 -122.42285577327 (37.7642691956966, -122.42285577327) 8 4 5 28859 19
86602 187101 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2600 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5985154.9931 2097213.6802 37.7376912868614 -122.493851744055 (37.7376912868614, -122.493851744055) 1 8 3 29491 35
88421 131239 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2620 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6006202.33744 2119807.10392 37.800936391067 -122.422685982183 (37.800936391067, -122.422685982183) 13 9 1 28858 32
89053 210207 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 3 Median : Yard Tree DPW 1     18     5993593.33337 2096358.46993 37.7358331856616 -122.464614502861 (37.7358331856616, -122.464614502861) 1 8 4 59 40
89578 210216 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 13 Median : Yard Tree DPW 1     8     5993632.37635 2096275.57392 37.7356078245468 -122.464473499958 (37.7356078245468, -122.464473499958) 1 8 4 59 40
93088 193759 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 475 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6014106.58803 2104917.84652 37.760496657527 -122.394290662907 (37.760496657527, -122.394290662907) 10 3 8 28856 29
96121 233258 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 199 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6005933.67174 2106131.04263 37.7633701200567 -122.422643282386 (37.7633701200567, -122.422643282386) 8 4 5 28859 19
97542 210226 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 327 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5997915.14759 2093784.89777 37.7290149719508 -122.449486980653 (37.7290149719508, -122.449486980653) 9 7 4 28861 40
102167 43332 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 35 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2000 12:00:00 AM 14   Permit Number 43089 6004170.9674 2093332.45523 37.7281285497825 -122.42782790455 (37.7281285497825, -122.42782790455) 9 7 6 28861 5
105902 122470 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 400 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 7x6   6013473.95437 2105179.77215 37.7611806620664 -122.396497028119 (37.7611806620664, -122.396497028119) 10 3 8 28856 29
107791 233259 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 199 Albion St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005932.52388 2106166.17783 37.7634665282686 -122.422649749403 (37.7634665282686, -122.422649749403) 8 4 5 28859 19
108070 233272 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1620 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6003319.97566 2098761.27461 37.7429866728986 -122.431157141712 (37.7429866728986, -122.431157141712) 2 7 5 63 22
109738 139332 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1599 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004598.7898 2114310.265 37.7857528657193 -122.427843044646 (37.7857528657193, -122.427843044646) 13 9 11 28858 13
112645 210210 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 7 Median : Yard Tree DPW 1     9     5993621.19387 2096286.31658 37.7356366765974 -122.464512941539 (37.7356366765974, -122.464512941539) 1 8 4 59 40
112862 186272 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1800 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5985019.1249 2102470.2641 37.7521164898262 -122.494708930752 (37.7521164898262, -122.494708930752) 1 8 3 56 35
113885 210213 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 10 Median : Yard Tree DPW 1     12     5993620.46899 2096278.94791 37.7356164022734 -122.464514912841 (37.7356164022734, -122.464514912841) 1 8 4 59 40
115012 39748 Permitted Site 7 Melaleuca styphelliodes :: Paperbark Tree 220 20 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45481 6003474.95820405 2105681.94482069 37.7619979834905 -122.431115112407 (37.7619979834905, -122.431115112407) 15 4 5 28862 3
118678 210209 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 2 Median : Yard Tree DPW 1     14     5993590.58402 2096363.3558 37.7358464425468 -122.46462436304 (37.7358464425468, -122.46462436304) 1 8 4 59 40
119076 233268 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 238 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5998999.67646 2106769.65564 37.7647299507493 -122.446671573844 (37.7647299507493, -122.446671573844) 15 5 11 29492 9
121779 69171 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1227 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1994 12:00:00 AM 11   Permit Number 33208 5982399.593 2106729.909 37.7636585927864 -122.504083004532 (37.7636585927864, -122.504083004532) 1 8 3 56 35
122090 210222 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 16 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5996449.29501 2089023.85802 37.7158583175883 -122.454210771337 (37.7158583175883, -122.454210771337) 9 8 6 28861 24
122261 210225 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 325 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5999411.52369 2094223.90937 37.7303058831132 -122.44434544861 (37.7303058831132, -122.44434544861) 9 7 4 28861 40
123920 233266 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 420 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003110.25297 2099512.27157 37.745036849288 -122.431935918616 (37.745036849288, -122.431935918616) 2 7 5 63 22
129091 233257 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 194 Albion St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6005894.41741 2106144.61703 37.7634051774336 -122.422780015281 (37.7634051774336, -122.422780015281) 8 4 5 28859 19
133996 131236 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1248 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007015.2496 2119146.31841 37.7991678706523 -122.419826040933 (37.7991678706523, -122.419826040933) 5 1 1 28858 32
137748 131238 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2620 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006204.00833 2119783.443 37.8008715184688 -122.422678517811 (37.8008715184688, -122.422678517811) 13 9 1 28858 32
139736 3746 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 935X Carolina St 1 Median : Cutout Tree DPW 1     3 18   6012507 2103301 37.7559681076303 -122.399709410552 (37.7559681076303, -122.399709410552) 10 3 8 28856 29
144945 210212 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 9 Median : Yard Tree DPW 1     6     5993622.23293 2096281.46694 37.735623420589 -122.46450899712 (37.735623420589, -122.46450899712) 1 8 4 59 40
145749 233274 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 210 Mateo St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 4ft   6003938.32692 2096276.11657 37.7361980181072 -122.428841920733 (37.7361980181072, -122.428841920733) 2 7 5 63 7
145836 233261 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 173 Albion St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005925.72321 2106264.20438 37.7637353023602 -122.422680237296 (37.7637353023602, -122.422680237296) 8 4 5 28859 19
146182 210202 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1325 18th Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   5990487.72051 2106249.66992 37.7628123065761 -122.476073909902 (37.7628123065761, -122.476073909902) 1 8 3 56 12
147826 30899 Permitted Site 7 Melaleuca styphelliodes :: Paperbark Tree 220 207 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1995 12:00:00 AM     Permit Number 34726 6007587.55613934 2097699.29085358 37.7403116119395 -122.416325773777 (37.7403116119395, -122.416325773777) 2 7 7 28859 2
156062 233263 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 132 Albion St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6005882.26742 2106442.38448 37.7642220909944 -122.422843201655 (37.7642220909944, -122.422843201655) 8 4 5 28859 19
160610 233269 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 244 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5999001.20892 2106749.87977 37.7646757387134 -122.446664850507 (37.7646757387134, -122.446664850507) 15 5 11 29492 9
164589 210215 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 198x San Anselmo Ave 12 Median : Yard Tree DPW 1     7     5993623.26603 2096276.33312 37.7356093839492 -122.46450505268 (37.7356093839492, -122.46450505268) 1 8 4 59 40
167832 58796 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 566 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1979 12:00:00 AM 13   Permit Number 18044 5989731.56208 2111486.81707 37.777148205512 -122.479072270647 (37.777148205512, -122.479072270647) 11 6 2 55 26
168002 233264 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 3334 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 5ft   6006112.46637 2103194.07717 37.7553159842707 -122.421816259513 (37.7553159842707, -122.421816259513) 2 4 5 28859 19
169236 62718 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1224 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/1986 12:00:00 AM 19   Permit Number 23063 6007084.91971 2119157.47779 37.7992024361086 -122.419585750202 (37.7992024361086, -122.419585750202) 5 1 1 28858 32
170548 57115 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 543 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 40   Permit Number 14385 6001502.35867 2090596.57637 37.7204651208625 -122.436857588907 (37.7204651208625, -122.436857588907) 9 7 6 28861 5
170843 210224 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 184 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5999521.71577 2094097.12067 37.7299640373132 -122.443955394636 (37.7299640373132, -122.443955394636) 9 7 4 63 40
173117 65524 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 725 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1990 12:00:00 AM 23   Permit Number 28411 6001341.71732 2089325.79591 37.7169667113151 -122.437321926889 (37.7169667113151, -122.437321926889) 9 7 6 28861 5
175018 37774 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 639 Burrows St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM 5 3x3 Permit Number 51462 6009417.78473 2092931.63603 37.7273234029471 -122.409661118085 (37.7273234029471, -122.409661118085) 10 3 7 309 28
176831 62717 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1212 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/1986 12:00:00 AM 18   Permit Number 23062 6007155.94722 2119168.22039 37.7992359331517 -122.419340732582 (37.7992359331517, -122.419340732582) 5 1 1 28858 32
178908 131237 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2620 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6006208.66422 2119759.65196 37.800806457001 -122.422660714837 (37.800806457001, -122.422660714837) 13 9 1 28858 32
188500 46771 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 24 Harrington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2002 12:00:00 AM 8   Permit Number 44867 6002105.75891 2092403.8997 37.7254619007261 -122.434901014876 (37.7254619007261, -122.434901014876) 9 7 6 28861 25
190308 131240 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 2620 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6006199.90416 2119828.63287 37.8009953668036 -122.422695933174 (37.8009953668036, -122.422695933174) 13 9 1 28858 32
190492 43343 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 536 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/2000 12:00:00 AM 8   Permit Number 43098 6003413.7993 2091288.29783 37.7224728869914 -122.4302996804 (37.7224728869914, -122.4302996804) 9 7 6 28861 5
191574 18207 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1575 Post St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004651.3172937 2114317.5621297 37.7857758731644 -122.427661834419 (37.7857758731644, -122.427661834419) 13 9 11 28858 13
194180 62705 DPW Maintained 1 Melaleuca styphelliodes :: Paperbark Tree 220 1279 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1986 12:00:00 AM 16   Permit Number 23045 6006870.41308 2119076.22609 37.7989672544017 -122.420322248197 (37.7989672544017, -122.420322248197) 5 1 10 28858 32

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