Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 272 | 272 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 293 | 293 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 300 | 300 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 682 | 682 | 251365 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 712 | 712 | 251366 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 713 | 713 | 251364 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | ||||||||||
| 68489 | 68489 | 176113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Santa Barbara Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993424.30452 | 2086604.0814 | 37.709040256765 | -122.464490865868 | (37.709040256765, -122.464490865868) | |||
| 9640 | 9640 | 114128 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9648 | 9648 | 114133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9649 | 9649 | 114125 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9650 | 9650 | 114131 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9662 | 9662 | 114130 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9664 | 9664 | 114135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9666 | 9666 | 114127 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9669 | 9669 | 114126 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9671 | 9671 | 114132 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9673 | 9673 | 114129 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 166548 | 166548 | 206841 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 246 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5994549.17298 | 2089660.24802 | 37.7174965486989 | -122.46082452325199 | (37.7174965486989, -122.460824523252) | ||||
| 61768 | 61768 | 206845 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 5ft | 5993220.45249 | 2089938.0951 | 37.7181829076919 | -122.465437434707 | (37.7181829076919, -122.465437434707) | |||
| 147594 | 147594 | 206851 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3800 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 6ft | 5990535.05203 | 2090576.85379 | 37.7197815380709 | -122.47476621738899 | (37.7197815380709, -122.474766217389) | |||
| 78166 | 78166 | 111586 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 142323 | 142323 | 111587 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | ||||
| 36089 | 36089 | 206844 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 488 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992249.47453 | 2091186.11142 | 37.72155360809921 | -122.46888442997299 | (37.7215536080992, -122.468884429973) | |||
| 86774 | 86774 | 122640 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 88391 | 88391 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 91819 | 91819 | 122638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 120114 | 120114 | 122639 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 64573 | 64573 | 206839 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 112 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5998729.31623 | 2093223.3736599998 | 37.7275196997604 | -122.446631964111 | (37.7275196997604, -122.446631964111) | ||||
| 135006 | 135006 | 217828 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Ocean Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5991744.92986 | 2094549.5504299998 | 37.7307596144611 | -122.470873372405 | (37.7307596144611, -122.470873372405) | ||||
| 109835 | 109835 | 205875 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Ridgewood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5996774.44348 | 2094614.15423 | 37.7312265910382 | -122.453490310026 | (37.7312265910382, -122.453490310026) | |||
| 43852 | 43852 | 205920 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 511 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | 5998677.95267 | 2094953.56375 | 37.7322674609713 | -122.446933978918 | (37.7322674609713, -122.446933978918) | ||||
| 183624 | 183624 | 205888 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 300 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5996225.80911 | 2095294.3314200002 | 37.733062728758505 | -122.455436166843 | (37.7330627287585, -122.455436166843) | |||
| 160056 | 160056 | 205906 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 20 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 5ft | 6001210.67203 | 2095218.5824 | 37.7331395119639 | -122.438196788261 | (37.7331395119639, -122.438196788261) | |||
| 63370 | 63370 | 205913 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6000143.15756 | 2095258.9913 | 37.733189693253706 | -122.44189036057301 | (37.7331896932537, -122.441890360573) | ||||
| 71651 | 71651 | 205912 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | 6000155.51959 | 2095259.25814 | 37.733191130349795 | -122.441847640961 | (37.7331911303498, -122.441847640961) | ||||
| 159921 | 159921 | 205914 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198 Mangels Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 10ft | 6000135.021930001 | 2095259.68353 | 37.733191130361 | -122.441918537232 | (37.733191130361, -122.441918537232) | |||
| 183726 | 183726 | 205911 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 198 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | 6000172.88009 | 2095259.68329 | 37.733193286925996 | -122.441787651691 | (37.733193286926, -122.441787651691) | ||||
| 63473 | 63473 | 205910 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 192 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6000206.522969999 | 2095259.2471900003 | 37.7331940064051 | -122.44167130819599 | (37.7331940064051, -122.441671308196) | ||||
| 28910 | 28910 | 114708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 83296 | 83296 | 114710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 89777 | 89777 | 114709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 117956 | 117956 | 114707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 500X CONGO ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x10 | 6000185.0 | 2095264.0 | 37.733205830187 | -122.441746059696 | (37.733205830187, -122.441746059696) | ||||
| 34630 | 34630 | 205915 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000129.85009 | 2095267.01455 | 37.7332109649183 | -122.44193694363199 | (37.7332109649183, -122.441936943632) | |||
| 174210 | 174210 | 205916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6000130.425 | 2095272.3934400002 | 37.73322576685489 | -122.44193534195401 | (37.7332257668549, -122.441935341954) | |||
| 73236 | 73236 | 205917 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 5ft | 6000128.91533 | 2095279.34221 | 37.7332447605271 | -122.441941059855 | (37.7332447605271, -122.441941059855) | |||
| 25920 | 25920 | 205918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 506 Congo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 5ft | 6000129.127169999 | 2095289.54923 | 37.7332727986918 | -122.441941059826 | (37.7332727986918, -122.441941059826) | |||
| 165216 | 165216 | 205921 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 335 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | 5997888.47996 | 2095505.4814799998 | 37.7337377607861 | -122.449703111117 | (37.7337377607861, -122.449703111117) | ||||
| 185428 | 185428 | 205905 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 125 Hamerton Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 51 | Width 4ft | 6001385.86644 | 2095459.79202 | 37.7338117803923 | -122.437608363645 | (37.7338117803923, -122.437608363645) | |||
| 185031 | 185031 | 190987 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6012468.98817 | 2095242.94143 | 37.7338402790006 | -122.39927522817 | (37.7338402790006, -122.39927522817) | |||
| 142696 | 142696 | 185115 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5985005.2624 | 2095904.376 | 37.7340875257112 | -122.49427294726802 | (37.7340875257112, -122.494272947268) | |||
| 134099 | 134099 | 185113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | Width 0ft | 5985054.6718 | 2095908.9819999998 | 37.7341030638616 | -122.49410246540701 | (37.7341030638616, -122.494102465407) | |||
| 47724 | 47724 | 185114 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 0ft | 5985037.5041 | 2095909.8194 | 37.734104358561204 | -122.49416188034901 | (37.7341043585612, -122.494161880349) | |||
| 148420 | 148420 | 186930 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 0ft | 5985213.3988 | 2095920.241 | 37.73414326467 | -122.49355453377399 | (37.73414326467, -122.493554533774) | |||
| 147154 | 147154 | 185108 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 0ft | 5985043.3663 | 2095933.2680000002 | 37.734169085209295 | -122.49414334087099 | (37.7341690852093, -122.494143340871) | |||
| 180182 | 180182 | 186931 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 0ft | 5985210.3719 | 2095929.9944 | 37.7341698678439 | -122.49356571698799 | (37.7341698678439, -122.493565716988) | |||
| 175698 | 175698 | 205893 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 5998235.76076 | 2095666.83858 | 37.734200671531504 | -122.448514080556 | (37.7342006715315, -122.448514080556) | |||
| 41442 | 41442 | 205894 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5998252.60091 | 2095669.89095 | 37.7342100154709 | -122.44845607881099 | (37.7342100154709, -122.448456078811) | |||
| 155817 | 155817 | 186935 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 0ft | 5985193.8921 | 2095957.5728 | 37.7342446267333 | -122.493624723479 | (37.7342446267333, -122.493624723479) | |||
| 35232 | 35232 | 186940 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | Width 0ft | 5985184.4751 | 2095979.7701 | 37.734305023711 | -122.49365891568 | (37.734305023711, -122.49365891568) | |||
| 36835 | 36835 | 205892 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997819.94601 | 2095725.4811900002 | 37.734337906251504 | -122.44995590246 | (37.7343379062515, -122.44995590246) | |||
| 37595 | 37595 | 205891 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5997820.03941 | 2095729.96315 | 37.73435021798711 | -122.44995590246201 | (37.7343502179871, -122.449955902462) | |||
| 171960 | 171960 | 205890 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5997823.46765 | 2095740.1408099998 | 37.7343783595712 | -122.449944783251 | (37.7343783595712, -122.449944783251) | |||
| 38550 | 38550 | 205889 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5997824.88709 | 2095746.51675 | 37.734395947598 | -122.449940335175 | (37.734395947598, -122.449940335175) | |||
| 175707 | 175707 | 206835 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Casitas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5995050.15142 | 2095828.17097 | 37.7344609919799 | -122.459539348883 | (37.7344609919799, -122.459539348883) | |||
| 171054 | 171054 | 206834 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 375 Casitas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 5995064.96816 | 2095832.8748700002 | 37.7344747596986 | -122.45948846344 | (37.7344747596986, -122.45948846344) | |||
| 122958 | 122958 | 185079 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 55 | Width 0ft | 5985030.8045 | 2096063.9098 | 37.7345270577315 | -122.49419639626001 | (37.7345270577315, -122.49419639626) | |||
| 156508 | 156508 | 185080 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985014.892999999 | 2096064.5379 | 37.7345278512133 | -122.494251453083 | (37.7345278512133, -122.494251453083) | |||
| 32009 | 32009 | 185077 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985040.4352 | 2096082.543 | 37.7345787830951 | -122.49416447312599 | (37.7345787830951, -122.494164473126) | |||
| 132931 | 132931 | 185076 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985009.4496 | 2096100.1294 | 37.734625257445295 | -122.494272895008 | (37.7346252574453, -122.494272895008) | |||
| 27513 | 27513 | 186961 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5985200.1141 | 2096126.2386 | 37.7347081021486 | -122.493615636331 | (37.7347081021486, -122.493615636331) | |||
| 163766 | 163766 | 185074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984997.7254 | 2096135.7209 | 37.7347222961152 | -122.49431605154301 | (37.7347222961152, -122.494316051543) | |||
| 52563 | 52563 | 185073 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985016.5679 | 2096146.6077 | 37.7347532910302 | -122.494251709723 | (37.7347532910302, -122.494251709723) | |||
| 55436 | 55436 | 185037 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 0ft | 5985002.122 | 2096263.6409999998 | 37.7350737878985 | -122.49431027719999 | (37.7350737878985, -122.4943102772) | |||
| 160898 | 160898 | 186852 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5985203.396000001 | 2096268.9816 | 37.7351002284248 | -122.493614804408 | (37.7351002284248, -122.493614804408) | |||
| 154407 | 154407 | 186853 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985216.0775 | 2096268.8219 | 37.7351005317957 | -122.493570948779 | (37.7351005317957, -122.493570948779) | |||
| 28368 | 28368 | 185036 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984991.2351 | 2096277.6682 | 37.7351116657323 | -122.494348950198 | (37.7351116657323, -122.494348950198) | |||
| 3142 | 3142 | 217765 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 470 West Portal Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 42 | Width 10ft | 5991548.70787 | 2096139.0246599999 | 37.7351125606845 | -122.471667523249 | (37.7351125606845, -122.471667523249) | |||
| 153184 | 153184 | 185035 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985023.8956 | 2096287.7176 | 37.7351411700064 | -122.49423677323401 | (37.7351411700064, -122.494236773234) | |||
| 58439 | 58439 | 185034 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984995.8411 | 2096292.7423 | 37.7351533247412 | -122.494334136609 | (37.7351533247412, -122.494334136609) | |||
| 71780 | 71780 | 223731 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6005275.60501 | 2095869.1731 | 37.7351562416517 | -122.424189464283 | (37.7351562416517, -122.424189464283) | |||
| 54161 | 54161 | 223732 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6005270.68564 | 2095872.41003 | 37.7351648517715 | -122.424206702478 | (37.7351648517715, -122.424206702478) | |||
| 54807 | 54807 | 185025 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984994.5849 | 2096323.3091 | 37.7352371795053 | -122.494340732091 | (37.7352371795053, -122.494340732091) | |||
| 153477 | 153477 | 185020 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 61 | Width 0ft | 5984996.6786 | 2096354.7134 | 37.7353235298613 | -122.494335807629 | (37.7353235298613, -122.494335807629) | |||
| 72879 | 72879 | 185018 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 0ft | 5985002.5407 | 2096393.6547 | 37.735430795338004 | -122.494318409962 | (37.735430795338, -122.494318409962) | |||
| 147131 | 147131 | 186876 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 0ft | 5985187.8846 | 2096408.4112 | 37.7354821575293 | -122.49367870298799 | (37.7354821575293, -122.493678702988) | |||
| 31264 | 31264 | 185017 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985031.8513 | 2096412.4973 | 37.735484247333396 | -122.494218462115 | (37.7354842473334, -122.494218462115) | |||
| 71056 | 71056 | 185015 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5984992.91 | 2096422.1279 | 37.7355084115427 | -122.494353804567 | (37.7355084115427, -122.494353804567) | |||
| 185755 | 185755 | 205895 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995734.854669999 | 2096206.24435 | 37.7355384364582 | -122.457199459482 | (37.7355384364582, -122.457199459482) | |||
| 74975 | 74975 | 185009 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 70 | Width 0ft | 5984987.4666 | 2096476.9807 | 37.7356587041277 | -122.494376666271 | (37.7356587041277, -122.494376666271) | |||
| 76786 | 76786 | 185002 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985002.5407 | 2096492.8922 | 37.735703275025 | -122.49432572254999 | (37.735703275025, -122.49432572255) | |||
| 24265 | 24265 | 184994 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984981.6045 | 2096535.6021 | 37.735819319769895 | -122.494401253367 | (37.7358193197699, -122.494401253367) | |||
| 168039 | 168039 | 184986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985020.5458 | 2096630.2336 | 37.7360814314996 | -122.494273593011 | (37.7360814314996, -122.494273593011) | |||
| 161640 | 161640 | 184985 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984999.1909 | 2096642.3766 | 37.7361135232276 | -122.494348319272 | (37.7361135232276, -122.494348319272) | |||
| 158741 | 158741 | 186911 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985189.7183 | 2096710.0524 | 37.7363104911026 | -122.493694583533 | (37.7363104911026, -122.493694583533) | |||
| 165444 | 165444 | 186919 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2700 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985188.342999999 | 2096744.4340000001 | 37.7364048133414 | -122.493701871188 | (37.7364048133414, -122.493701871188) | |||
| 151754 | 151754 | 185361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 86 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 72 | Width 0ft | 5985015.9398 | 2096870.9998 | 37.7367422415889 | -122.49430725909599 | (37.7367422415889, -122.494307259096) | |||
| 162350 | 162350 | 185359 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 84 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 0ft | 5984996.2598 | 2096910.7786 | 37.7368503118256 | -122.49437823177 | (37.7368503118256, -122.49437823177) | |||
| 55074 | 55074 | 185341 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 65 | Width 0ft | 5984987.4666 | 2096984.4739 | 37.7370521447921 | -122.49441406407699 | (37.7370521447921, -122.494414064077) |
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");