Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5101 | 5101 | 253790 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
| 5106 | 5106 | 253787 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5083 | 5083 | 253786 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1675X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5104 | 5104 | 253785 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
| 4063 | 4063 | 253608 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 400X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 5998814.0 | 2100235.0 | 37.746776792757004 | -122.44684353081101 | (37.746776792757, -122.446843530811) | ||||
| 3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
| 1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
| 1347 | 1347 | 251504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 620x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5992030.0 | 2103590.0 | 37.7555988620986 | -122.470546036282 | (37.7555988620986, -122.470546036282) | ||||
| 22919 | 22919 | 251161 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 528 Noriega St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5992330.0 | 2103518.0 | 37.7554185113149 | -122.46950331083401 | (37.7554185113149, -122.469503310834) | ||||
| 22922 | 22922 | 251160 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1126x Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | Private 3 | 3x3 | 5994964.0 | 2098019.0 | 37.7404715144277 | -122.459995857341 | (37.7404715144277, -122.459995857341) | |||
| 51690 | 51690 | 251039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5400x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5990159.2899 | 2112663.7273 | 37.780404505362 | -122.47767868930201 | (37.780404505362, -122.477678689302) | |||
| 152991 | 152991 | 249486 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6006282.26007 | 2115524.70899 | 37.789182518996604 | -122.42210501295 | (37.7891825189966, -122.42210501295) | |||
| 174630 | 174630 | 249485 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006288.55578 | 2115489.9349599998 | 37.7890873932245 | -122.42208075914 | (37.7890873932245, -122.42208075914) | |||
| 52502 | 52502 | 249484 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006293.0295400005 | 2115454.9396 | 37.7889915569696 | -122.422062793377 | (37.7889915569696, -122.422062793377) | |||
| 154003 | 154003 | 249483 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6006303.991280001 | 2115419.81097 | 37.788895720704105 | -122.42202237063101 | (37.7888957207041, -122.422022370631) | |||
| 49822 | 49822 | 249482 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006310.58907 | 2115387.0991 | 37.788806274127104 | -122.42199721841601 | (37.7888062741271, -122.421997218416) | |||
| 161863 | 161863 | 249481 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6006314.60241 | 2115354.9571700003 | 37.7887182466994 | -122.4219810486 | (37.7887182466994, -122.4219810486) | |||
| 147308 | 147308 | 249472 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6006469.09533 | 2114171.09667 | 37.785476369688 | -122.42136241936599 | (37.785476369688, -122.421362419366) | |||
| 71548 | 71548 | 249471 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006474.14305 | 2114137.78522 | 37.7853851892236 | -122.421342589296 | (37.7853851892236, -122.421342589296) | |||
| 162246 | 162246 | 249470 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006480.79574 | 2114106.51606 | 37.7852997068671 | -122.421317351637 | (37.7852997068671, -122.421317351637) | |||
| 157902 | 157902 | 249469 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006493.04465 | 2114068.6458799997 | 37.7851964152265 | -122.421272283894 | (37.7851964152265, -122.421272283894) | |||
| 24987 | 24987 | 249468 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006497.80011 | 2114033.78335 | 37.7851009593808 | -122.421253354956 | (37.7851009593808, -122.421253354956) | |||
| 26885 | 26885 | 249467 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000x Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 3ft | 6006503.72956 | 2113992.67034 | 37.7849884074321 | -122.421229920427 | (37.7849884074321, -122.421229920427) | |||
| 171600 | 171600 | 248622 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 142x McCoppin St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6005746.1935 | 2109104.2775 | 37.7715233357229 | -122.423503100629 | (37.7715233357229, -122.423503100629) | |||
| 148059 | 148059 | 248621 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 132x McCoppin St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6005771.7237 | 2109102.262 | 37.7715192426118 | -122.42341464686501 | (37.7715192426118, -122.423414646865) | |||
| 38993 | 38993 | 248619 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1801x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005765.0052 | 2109117.0426 | 37.7715594473913 | -122.42343893750099 | (37.7715594473913, -122.423438937501) | |||
| 161211 | 161211 | 248618 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1801x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005754.9275 | 2109142.5728 | 37.771628978383795 | -122.42347561219299 | (37.7716289783838, -122.423475612193) | |||
| 51610 | 51610 | 247891 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001766.9155 | 2109631.5958 | 37.7727458146843 | -122.43730537854401 | (37.7727458146843, -122.437305378544) | |||
| 137243 | 137243 | 247890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001764.2019 | 2109653.3044 | 37.772805266826 | -122.43731631988899 | (37.772805266826, -122.437316319889) | |||
| 180234 | 180234 | 247518 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001762.8451 | 2109678.405 | 37.7728741096846 | -122.437322810858 | (37.7728741096846, -122.437322810858) | |||
| 178382 | 178382 | 247517 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001820.5087 | 2109214.383 | 37.771603298669 | -122.437090117747 | (37.771603298669, -122.437090117747) | |||
| 47914 | 47914 | 247516 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001823.2223 | 2109176.3929 | 37.7714991415406 | -122.43707801088101 | (37.7714991415406, -122.437078010881) | |||
| 170700 | 170700 | 247515 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001817.1167 | 2109233.3781 | 37.7716552616846 | -122.437103211063 | (37.7716552616846, -122.437103211063) | |||
| 32664 | 32664 | 247514 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001758.7748 | 2109713.6816 | 37.7729707390414 | -122.43733941693701 | (37.7729707390414, -122.437339416937) | |||
| 150662 | 150662 | 247513 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001705.0206 | 2109993.3481 | 37.773735577412 | -122.437545390376 | (37.773735577412, -122.437545390376) | |||
| 55733 | 55733 | 247512 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001707.9488 | 2109975.7789 | 37.773687503260604 | -122.437534002868 | (37.7736875032606, -122.437534002868) | |||
| 129960 | 129960 | 247511 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001702.677999999 | 2110029.6578 | 37.773835141586105 | -122.43755609455201 | (37.7738351415861, -122.437556094552) | |||
| 178645 | 178645 | 247510 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001703.2636 | 2110010.3317 | 37.7737821102395 | -122.43755268459299 | (37.7737821102395, -122.437552684593) | |||
| 158545 | 158545 | 247509 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001720.54 | 2109913.9939 | 37.773518572941896 | -122.4374860227 | (37.7735185729419, -122.4374860227) | |||
| 42109 | 42109 | 247508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.0539 | 2109895.2534 | 37.7734673159842 | -122.43747252535401 | (37.7734673159842, -122.437472525354) | |||
| 177449 | 177449 | 247507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | |||
| 31777 | 31777 | 247369 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001726.9821 | 2109863.6289 | 37.773380649478504 | -122.437460131244 | (37.7733806494785, -122.437460131244) | |||
| 177037 | 177037 | 246965 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6002901.60437 | 2106802.37956 | 37.7650419192671 | -122.433178178236 | (37.7650419192671, -122.433178178236) | |||
| 75617 | 75617 | 246964 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 6002901.21345 | 2106817.19927 | 37.7650825884135 | -122.433180589307 | (37.7650825884135, -122.433180589307) | |||
| 164702 | 164702 | 246548 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.772423585213794 | -122.423543772638 | (37.7724235852138, -122.423543772638) | |||
| 28092 | 28092 | 246547 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.772377152311705 | -122.42353021715599 | (37.7723771523117, -122.423530217156) | |||
| 135557 | 135557 | 246409 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6003700.7355 | 2107248.5843 | 37.7663123894934 | -122.43044602180001 | (37.7663123894934, -122.4304460218) | |||
| 182459 | 182459 | 246404 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6004606.9445 | 2108108.5245 | 37.7687248704296 | -122.427372879895 | (37.7687248704296, -122.427372879895) | |||
| 64559 | 64559 | 246403 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6004628.6575 | 2108127.683 | 37.7687787030374 | -122.427299141169 | (37.7687787030374, -122.427299141169) | |||
| 36176 | 36176 | 246402 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2000x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 0ft | 6004659.311000001 | 2108158.3365 | 37.7688646036969 | -122.42719529666901 | (37.7688646036969, -122.427195296669) | |||
| 136243 | 136243 | 246359 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2150x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6003779.011 | 2107326.8598 | 37.766531748826 | -122.430180866432 | (37.766531748826, -122.430180866432) | |||
| 178250 | 178250 | 246357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003963.462 | 2107490.3857 | 37.7669911968193 | -122.429554546796 | (37.7669911968193, -122.429554546796) | |||
| 181978 | 181978 | 246356 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2100x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003986.7122 | 2107511.3108 | 37.7670499684983 | -122.429475620431 | (37.7670499684983, -122.429475620431) | |||
| 24559 | 24559 | 246349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2190x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6003723.2107 | 2107266.4094 | 37.766362606026796 | -122.430369556243 | (37.7663626060268, -122.430369556243) | |||
| 54798 | 54798 | 246348 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2150x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6003809.2361 | 2107348.5599 | 37.766593043924 | -122.430077871393 | (37.766593043924, -122.430077871393) | |||
| 132737 | 132737 | 246343 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020x Market St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6004317.012999999 | 2107828.8108 | 37.767940442417604 | -122.428355792358 | (37.7679404424176, -122.428355792358) | |||
| 25198 | 25198 | 246342 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020x Market St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 0ft | 6004356.6072 | 2107872.2367 | 37.7680619198287 | -122.42822193571301 | (37.7680619198287, -122.428221935713) | |||
| 76295 | 76295 | 246340 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 2020x Market St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6004296.5773 | 2107812.2068 | 37.767893695460295 | -122.428425293549 | (37.7678936954603, -122.428425293549) | |||
| 172817 | 172817 | 245965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6005023.4835 | 2108512.8969 | 37.7698587289196 | -122.425960891085 | (37.7698587289196, -122.425960891085) | |||
| 170480 | 170480 | 245964 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 6005048.2837 | 2108538.5237 | 37.7699304954931 | -122.42587693213301 | (37.7699304954931, -122.425876932133) | |||
| 172221 | 172221 | 245963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1950x Market St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | |||
| 64231 | 64231 | 245918 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001860.7014 | 2108879.7604 | 37.770686792610604 | -122.43692712942499 | (37.7706867926106, -122.436927129425) | |||
| 42644 | 42644 | 245916 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001847.8677 | 2108968.7942 | 37.7709305279013 | -122.43697789640801 | (37.7709305279013, -122.436977896408) | |||
| 31973 | 31973 | 245913 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001839.4456 | 2109021.7333 | 37.771075406828295 | -122.437010819306 | (37.7710754068283, -122.437010819306) | |||
| 138258 | 138258 | 245912 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001842.253 | 2109004.087 | 37.771027114039 | -122.436999844882 | (37.771027114039, -122.436999844882) | |||
| 149118 | 149118 | 245911 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001845.0604 | 2108986.0395 | 37.770977719652706 | -122.43698884174499 | (37.7709777196527, -122.436988841745) | |||
| 154709 | 154709 | 245908 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001868.7225 | 2108822.4097 | 37.7705297776993 | -122.436895278053 | (37.7705297776993, -122.436895278053) | |||
| 150543 | 150543 | 245906 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001865.9151 | 2108842.8634 | 37.7705857789269 | -122.436906453346 | (37.7705857789269, -122.436906453346) | |||
| 182784 | 182784 | 245673 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005908.33244 | 2099840.7906299997 | 37.7460971157901 | -122.422283981647 | (37.7460971157901, -122.422283981647) | |||
| 150311 | 150311 | 245672 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005912.3551 | 2099779.75668 | 37.7459297573535 | -122.422265736192 | (37.7459297573535, -122.422265736192) | |||
| 167691 | 167691 | 245666 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005857.27695 | 2099307.6356900004 | 37.744630313449 | -122.422422649005 | (37.744630313449, -122.422422649005) | |||
| 60555 | 60555 | 245665 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005853.52339 | 2099296.15265 | 37.744598571882 | -122.42243481233 | (37.744598571882, -122.42243481233) | |||
| 173817 | 173817 | 245664 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738x San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005721.51625 | 2098863.78747 | 37.743403947541296 | -122.42286054508001 | (37.7434039475413, -122.42286054508) | |||
| 147815 | 147815 | 245663 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750x San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005696.33761 | 2098785.48588 | 37.7431875283974 | -122.422942042552 | (37.7431875283974, -122.422942042552) | |||
| 74580 | 74580 | 245662 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750x San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005689.97131 | 2098766.69991 | 37.743135587148 | -122.422962720654 | (37.743135587148, -122.422962720654) | |||
| 23390 | 23390 | 245365 | DPW Maintained 3 | Acer spp :: Maple 158 | 200x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001863.1078 | 2108862.114 | 37.770638476744296 | -122.436917542168 | (37.7706384767443, -122.436917542168) | |||
| 152287 | 152287 | 244924 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001808.976 | 2109286.2928 | 37.771800089557296 | -122.4371351594 | (37.7718000895573, -122.4371351594) | |||
| 141528 | 141528 | 244919 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001806.9408 | 2109318.1774 | 37.7718875210524 | -122.437144482547 | (37.7718875210524, -122.437144482547) | |||
| 137299 | 137299 | 244918 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001806.9408 | 2109337.8508 | 37.7719415393154 | -122.437145891369 | (37.7719415393154, -122.437145891369) | |||
| 71495 | 71495 | 244916 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001807.6192 | 2109359.5595 | 37.77200118456779 | -122.437145099308 | (37.7720011845678, -122.437145099308) | |||
| 45104 | 45104 | 244892 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001783.197000001 | 2109529.1582 | 37.772465472110895 | -122.437241723075 | (37.7724654721109, -122.437241723075) | |||
| 66685 | 66685 | 244891 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001778.4482 | 2109561.7211 | 37.7725546117714 | -122.437260481611 | (37.7725546117714, -122.437260481611) | |||
| 41565 | 41565 | 244890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001780.4834 | 2109546.7964 | 37.772513747957 | -122.43725237282601 | (37.772513747957, -122.437252372826) | |||
| 158413 | 158413 | 244889 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001777.0914 | 2109578.0026 | 37.7725992395847 | -122.437266340921 | (37.7725992395847, -122.437266340921) | |||
| 157229 | 157229 | 244857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Precita Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6009346.66532 | 2100208.95898 | 37.7473013727717 | -122.410420614427 | (37.7473013727717, -122.410420614427) | |||
| 148069 | 148069 | 244856 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6009332.074580001 | 2100182.02874 | 37.747226610324205 | -122.410469167039 | (37.7472266103242, -122.410469167039) | |||
| 138143 | 138143 | 244478 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | |||
| 158186 | 158186 | 244477 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | |||
| 66611 | 66611 | 244468 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | |||
| 68766 | 68766 | 244467 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.8918 | 2109690.1946 | 37.7731256707262 | -122.423940148458 | (37.7731256707262, -122.423940148458) | |||
| 73396 | 73396 | 244466 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005631.2066 | 2109707.3231 | 37.7731726627699 | -122.423943736898 | (37.7731726627699, -122.423943736898) | |||
| 174364 | 174364 | 244465 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | |||
| 155187 | 155187 | 244456 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.773319011501705 | -122.42397123777799 | (37.7733190115017, -122.423971237778) | |||
| 161664 | 161664 | 244455 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | |||
| 153505 | 153505 | 244434 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6005644.2243 | 2109791.2526 | 37.7734038478353 | -122.42390467617399 | (37.7734038478353, -122.423904676174) | |||
| 150135 | 150135 | 244433 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005647.6499 | 2109776.1795 | 37.7733626541324 | -122.42389175449499 | (37.7733626541324, -122.423891754495) | |||
| 155716 | 155716 | 244432 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6005649.0202 | 2109761.1065 | 37.7733213446724 | -122.423885942412 | (37.7733213446724, -122.423885942412) |
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");