Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71324 | 71324 | 186604 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984777.686000001 | 2104434.4069 | 37.757495347708605 | -122.495688715119 | (37.7574953477086, -122.495688715119) | |||
| 22341 | 22341 | 3629 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017712.663240001 | 2098437.04484 | 37.7429014981049 | -122.38136811194201 | (37.7429014981049, -122.381368111942) | |||
| 140370 | 140370 | 3553 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 119957 | 119957 | 3551 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 61 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
| 16233 | 16233 | 3547 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018659.18869 | 2097627.86643 | 37.7407318647912 | -122.378039097821 | (37.7407318647912, -122.378039097821) | |||
| 16604 | 16604 | 3546 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018623.4169 | 2097653.5081700003 | 37.740800300486704 | -122.378164564055 | (37.7408003004867, -122.378164564055) | ||
| 16434 | 16434 | 3544 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6018582.49326 | 2097682.52078 | 37.740877707832 | -122.378308077855 | (37.740877707832, -122.378308077855) | |||
| 1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
| 58603 | 58603 | 186242 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1701 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984785.2956 | 2103243.6568 | 37.7542263235306 | -122.49557457374901 | (37.7542263235306, -122.495574573749) | |||
| 10572 | 10572 | 20406 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13427 | 13427 | 3615 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017970.88261 | 2098244.46459 | 37.7423869635862 | -122.380461869644 | (37.7423869635862, -122.380461869644) | ||
| 36741 | 36741 | 213231 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1x Minerva St | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 5996543.8328 | 2088997.86009 | 37.7157923540991 | -122.45388213025299 | (37.7157923540991, -122.453882130253) | |||
| 87844 | 87844 | 10843 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6018044.17001 | 2094607.0340099998 | 37.732403344492 | -122.379955772489 | (37.732403344492, -122.379955772489) | ||
| 16754 | 16754 | 3613 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.742321475865296 | -122.380345828295 | (37.7423214758653, -122.380345828295) | |||
| 14540 | 14540 | 20403 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 123512 | 123512 | 10838 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X4 | 6017982.97201 | 2094620.0550099998 | 37.732435721384505 | -122.380168255061 | (37.7324357213845, -122.380168255061) | |||
| 33392 | 33392 | 187108 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985154.9931 | 2097244.7147 | 37.7377764992933 | -122.493854030446 | (37.7377764992933, -122.493854030446) | |||
| 76514 | 76514 | 210024 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400x Marietta Dr | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999068.6414 | 2096968.17305 | 37.737821414033796 | -122.445728113076 | (37.7378214140338, -122.445728113076) | |||
| 124058 | 124058 | 10837 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017972.5560099995 | 2094607.0340099998 | 37.7323993935967 | -122.380203361451 | (37.7323993935967, -122.380203361451) | ||
| 150369 | 150369 | 232589 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5200x Diamond Heights Blvd | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6001728.28871 | 2098778.49055 | 37.7429436178674 | -122.436661981881 | (37.7429436178674, -122.436661981881) | ||||
| 166635 | 166635 | 232588 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5200x Diamond Heights Blvd | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 59 | 6001719.64568 | 2098775.96763 | 37.742936199339795 | -122.436691686488 | (37.7429361993398, -122.436691686488) | ||||
| 15884 | 15884 | 3532 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018368.40332 | 2097843.5336 | 37.7413080145474 | -122.379059509092 | (37.7413080145474, -122.379059509092) | ||
| 53757 | 53757 | 185016 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2701 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985035.6199 | 2096418.3594 | 37.7355005636265 | -122.49420586477301 | (37.7355005636265, -122.494205864773) | |||
| 107602 | 107602 | 10835 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017959.53501 | 2094605.73201 | 37.7323951001445 | -122.380248288115 | (37.7323951001445, -122.380248288115) | |||
| 9064 | 9064 | 12160 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400X La Salle Ave | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016105.23501 | 2095780.8120099998 | 37.73551914997571 | -122.38674101011101 | (37.7355191499757, -122.386741010111) | |||
| 115621 | 115621 | 10833 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X4 | 6017942.60801 | 2094605.73201 | 37.7323941661952 | -122.380306809323 | (37.7323941661952, -122.380306809323) | |||
| 22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
| 143191 | 143191 | 10831 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017923.07701 | 2094607.0340099998 | 37.732396663570206 | -122.380374423717 | (37.7323966635702, -122.380374423717) | |||
| 149845 | 149845 | 184918 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1990 41st Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983532.5797 | 2102094.6082 | 37.7509979199961 | -122.49982178293399 | (37.7509979199961, -122.499821782934) | |||
| 13736 | 13736 | 3526 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018266.26649 | 2097919.3860299997 | 37.741510657881996 | -122.379417933909 | (37.741510657882, -122.379417933909) | ||
| 136541 | 136541 | 138760 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 GEARY BLVD | 35 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 0ft | 5999054.4649 | 2113219.8866 | 37.7824437672153 | -122.446946271589 | (37.7824437672153, -122.446946271589) | |||
| 114276 | 114276 | 109670 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
| 141462 | 141462 | 109668 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
| 100423 | 100423 | 109667 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
| 7953 | 7953 | 20384 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 117644 | 117644 | 109629 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X GELLERT DR | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||||
| 12584 | 12584 | 20383 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 14959 | 14959 | 3519 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018155.4524300005 | 2098002.8080700003 | 37.7417336061107 | -122.37980688978 | (37.7417336061107, -122.37980688978) | |||
| 31955 | 31955 | 119551 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601 30th Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5986577.57039 | 2111641.59198 | 37.7773895059554 | -122.48999416304702 | (37.7773895059554, -122.489994163047) | |||
| 1497 | 1497 | 20382 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 16763 | 16763 | 3518 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/13/1990 12:00:00 AM | 12 | 3X3 | 6018140.3962 | 2098014.05812 | 37.741763665963894 | -122.37985973126001 | (37.7417636659639, -122.37985973126) | ||
| 86967 | 86967 | 10759 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 100631 | 100631 | 10765 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | 3X4 | 6017565.8970099995 | 2094869.6883099999 | 37.733098145559204 | -122.381627551172 | (37.7330981455592, -122.381627551172) | ||
| 106807 | 106807 | 99373 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499X 29th Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.48908690310101 | (37.7799454996166, -122.489086903101) | ||
| 27368 | 27368 | 138258 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 GEARY BLVD | 26 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 0ft | 5999069.3554 | 2113186.3828 | 37.7823526251779 | -122.446892345537 | (37.7823526251779, -122.446892345537) | |||
| 61694 | 61694 | 99372 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499X 29th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 5986859.5 | 2112566.5 | 37.7799454996166 | -122.48908690310101 | (37.7799454996166, -122.489086903101) | ||
| 63481 | 63481 | 119552 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601 30th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5986575.72333 | 2111707.15268 | 37.7775694091625 | -122.490005375825 | (37.7775694091625, -122.490005375825) | |||
| 7547 | 7547 | 8637 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999081.877 | 2113180.2912 | 37.7823366145664 | -122.44684858803001 | (37.7823366145664, -122.44684858803) | |||
| 24169 | 24169 | 232579 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500x 27th St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002958.22552 | 2100071.04753 | 37.746562497872205 | -122.43250150584801 | (37.7465624978722, -122.432501505848) | |||
| 114464 | 114464 | 38729 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 127856 | 127856 | 99371 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986853.20034 | 2112633.2968599997 | 37.7801285370834 | -122.48911360833598 | (37.7801285370834, -122.489113608336) | ||
| 133675 | 133675 | 185300 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2601 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984968.9381 | 2097336.9346 | 37.738018823068295 | -122.49450409942499 | (37.7380188230683, -122.494504099425) | |||
| 5832 | 5832 | 20376 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 6919 | 6919 | 8636 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999097.4445 | 2113192.4744 | 37.782370955794605 | -122.446795608488 | (37.7823709557946, -122.446795608488) | |||
| 13771 | 13771 | 3514 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 201X Cargo Way | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018078.86698 | 2098059.01516 | 37.7418837146726 | -122.380075604504 | (37.7418837146726, -122.380075604504) | ||
| 83187 | 83187 | 10817 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017674.37901 | 2094694.2740099998 | 37.732622481652704 | -122.381240303482 | (37.7326224816527, -122.381240303482) | ||
| 85591 | 85591 | 99370 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986851.72562 | 2112647.47743 | 37.7801673868145 | -122.489119752829 | (37.7801673868145, -122.489119752829) | ||
| 98627 | 98627 | 99346 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 5986570.64094 | 2113156.51142 | 37.7815486383406 | -122.49012959305401 | (37.7815486383406, -122.490129593054) | ||
| 105627 | 105627 | 38731 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 162729 | 162729 | 187005 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984963.7397 | 2098055.8287 | 37.7399924089099 | -122.49457505476299 | (37.7399924089099, -122.494575054763) | |||
| 165301 | 165301 | 193793 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501 25th St | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6014229.14205 | 2101967.67513 | 37.7524029335523 | -122.393660311891 | (37.7524029335523, -122.393660311891) | ||||
| 181371 | 181371 | 193953 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1322 Hudson Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017567.44108 | 2094871.5619299999 | 37.7331033754053 | -122.38162234311399 | (37.7331033754053, -122.381622343114) | |||
| 8093 | 8093 | 20375 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 21056 | 21056 | 29615 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991180.193109999 | 2090928.63197 | 37.720784797453206 | -122.47256184775 | (37.7207847974532, -122.47256184775) | ||
| 24795 | 24795 | 193920 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015113.53371 | 2111034.0348099996 | 37.777346287939295 | -122.39123561016198 | (37.7773462879393, -122.391235610162) | |||
| 78240 | 78240 | 99345 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 4x4 | 5986571.27659 | 2113136.01167 | 37.7814923890114 | -122.490125885703 | (37.7814923890114, -122.490125885703) | ||
| 88896 | 88896 | 38728 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 142697 | 142697 | 99369 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 5986847.81361 | 2112672.3215799998 | 37.7802353734381 | -122.489135113122 | (37.7802353734381, -122.489135113122) | ||
| 159024 | 159024 | 3587 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.3984199995 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) | ||
| 166860 | 166860 | 231266 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 Alemany Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009395.45855 | 2095915.1922400002 | 37.735514360685 | -122.40994882828501 | (37.735514360685, -122.409948828285) | |||
| 39067 | 39067 | 131360 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Jackson St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002031.37188 | 2116676.75667 | 37.792105070155294 | -122.436895043878 | (37.7921050701553, -122.436895043878) | |||
| 59529 | 59529 | 193919 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6015098.7686 | 2111019.91409 | 37.7773066961843 | -122.39128570057501 | (37.7773066961843, -122.391285700575) | |||
| 90275 | 90275 | 10815 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1139X Hudson Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/1993 12:00:00 AM | 6 | 3X4 | 6017647.03501 | 2094719.0130099999 | 37.7326889005557 | -122.38133655896999 | (37.7326889005557, -122.38133655897) | ||
| 96693 | 96693 | 38727 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 112307 | 112307 | 99368 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986849.57732 | 2112692.62378 | 37.7802912204421 | -122.48913050474701 | (37.7802912204421, -122.489130504747) | ||
| 177903 | 177903 | 187003 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984949.2797 | 2098059.1915 | 37.7400007959207 | -122.49462529858101 | (37.7400007959207, -122.494625298581) | |||
| 180544 | 180544 | 187337 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2200 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985071.5674 | 2099684.5129 | 37.7444706465068 | -122.49432225783501 | (37.7444706465068, -122.494322257835) | |||
| 188278 | 188278 | 183088 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 42nd Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983384.5770000005 | 2097376.5313 | 37.7380346904942 | -122.499984858817 | (37.7380346904942, -122.499984858817) | |||
| 72452 | 72452 | 187002 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984950.9611 | 2098062.2180000003 | 37.740009204287404 | -122.494619708142 | (37.7400092042874, -122.494619708142) | |||
| 78572 | 78572 | 29237 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1902X 41st Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 79916 | 79916 | 27854 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4 | 6006809.78536 | 2093659.54495 | 37.7291755925899 | -122.41872858497601 | (37.7291755925899, -122.418728584976) | |||
| 83791 | 83791 | 99367 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986848.243530001 | 2112713.4337400002 | 37.780348280813605 | -122.489136649255 | (37.7803482808136, -122.489136649255) | ||
| 94764 | 94764 | 5004 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5300 Diamond Heights Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 95643 | 95643 | 24843 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200X Alemany Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 6 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 113991 | 113991 | 38726 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 136552 | 136552 | 193918 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6015083.73845 | 2111007.60146 | 37.7772720543087 | -122.391336834226 | (37.7772720543087, -122.391336834226) | |||
| 170933 | 170933 | 183087 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2602 42nd Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983385.686000001 | 2097353.2436 | 37.7379708138783 | -122.499979303573 | (37.7379708138783, -122.499979303573) | |||
| 822 | 822 | 177714 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 4ft | 5991271.7328699995 | 2089255.2484 | 37.7161953951732 | -122.472123514597 | (37.7161953951732, -122.472123514597) | |||
| 7167 | 7167 | 35203 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 11282 | 11282 | 27078 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4 | 6006735.28367 | 2093656.03407 | 37.7291617575048 | -122.41898589519501 | (37.7291617575048, -122.418985895195) | |||
| 16789 | 16789 | 20000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY46 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 19215 | 19215 | 29612 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.99541 | 2090994.8659400002 | 37.7209667060276 | -122.472563900905 | (37.7209667060276, -122.472563900905) | ||
| 48746 | 48746 | 183086 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2604 42nd Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983387.3494 | 2097333.5599 | 37.7379168654029 | -122.49997209786801 | (37.7379168654029, -122.499972097868) | |||
| 50972 | 50972 | 193995 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 604 Keith St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6017076.54744 | 2096531.00508 | 37.7376327587424 | -122.38343498875099 | (37.7376327587424, -122.383434988751) | |||
| 88245 | 88245 | 11621 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 120802 | 120802 | 38725 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 222 Schwerin St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | |||
| 142333 | 142333 | 99366 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986848.25067 | 2112734.65735 | 37.7804065552175 | -122.48913818535101 | (37.7804065552175, -122.489138185351) | ||
| 149556 | 149556 | 187001 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984953.9876 | 2098070.625 | 37.7400324647869 | -122.49460986352699 | (37.7400324647869, -122.494609863527) | |||
| 159860 | 159860 | 186432 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1601 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984756.8545 | 2104040.7019 | 37.756413123178 | -122.495731717418 | (37.756413123178, -122.495731717418) |
JSON shape: default, array, newline-delimited
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");