Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114145 | 114145 | 482 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.75320127739371 | -122.406450377502 | (37.7532012773937, -122.406450377502) | |||
| 77711 | 77711 | 484 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.40670053704201 | (37.7532507356841, -122.406700537042) | |||
| 66021 | 66021 | 485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010468.2249 | 2102315.4128099997 | 37.7531480416193 | -122.40669074837099 | (37.7531480416193, -122.406690748371) | |||
| 113086 | 113086 | 486 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.40652353202299 | (37.7529942564805, -122.406523532023) | |||
| 87388 | 87388 | 488 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | |||
| 94730 | 94730 | 490 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | |||
| 85222 | 85222 | 504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | |||
| 146193 | 146193 | 505 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.40764958164499 | (37.7529538159215, -122.407649581645) | |||
| 106609 | 106609 | 506 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2773 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.75265268273179 | -122.407779587097 | (37.7526526827318, -122.407779587097) | |||
| 120595 | 120595 | 510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2781 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.75265268273179 | -122.407779587097 | (37.7526526827318, -122.407779587097) | |||
| 115050 | 115050 | 511 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010123.24297 | 2102258.68458 | 37.7529729707581 | -122.407879770058 | (37.7529729707581, -122.407879770058) | |||
| 128389 | 128389 | 512 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.40800714042601 | (37.7529955768562, -122.408007140426) | |||
| 128642 | 128642 | 516 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010023.971 | 2102231.1332900003 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | |||
| 78264 | 78264 | 525 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009855.900330001 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | |||
| 106647 | 106647 | 541 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009654.44601 | 2102141.49288 | 37.752624931831 | -122.409492696033 | (37.752624931831, -122.409492696033) | |||
| 106676 | 106676 | 550 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2899 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009498.42946 | 2102171.88233 | 37.75269963130629 | -122.410034375932 | (37.7526996313063, -122.410034375932) | |||
| 123037 | 123037 | 570 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2972 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6009057.78841 | 2102246.54845 | 37.7528799408325 | -122.411563471864 | (37.7528799408325, -122.411563471864) | |||
| 80364 | 80364 | 573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 776380 | 6009007.8652800005 | 2102243.7741799997 | 37.752869522851704 | -122.411735919997 | (37.7528695228517, -122.411735919997) | ||
| 78183 | 78183 | 575 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.752454954328606 | -122.41222072226999 | (37.7524549543286, -122.41222072227) | |||
| 128032 | 128032 | 578 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6008810.60715 | 2102251.6242299997 | 37.7528800095792 | -122.41241863259701 | (37.7528800095792, -122.412418632597) | |||
| 115579 | 115579 | 583 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3032 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008758.82346 | 2102183.2401799997 | 37.7526893362197 | -122.412592877178 | (37.7526893362197, -122.412592877178) | |||
| 113541 | 113541 | 585 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3035 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 122 | 3x3 | 6008718.0 | 2102146.0 | 37.752584791835105 | -122.412731419953 | (37.7525847918351, -122.412731419953) | |||
| 1579 | 1579 | 588 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | |||
| 93429 | 93429 | 594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3056 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008579.288380001 | 2102218.52685 | 37.7527761477761 | -122.413216238549 | (37.7527761477761, -122.413216238549) | |||
| 123995 | 123995 | 601 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6008510.860679401 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | ||||
| 20818 | 20818 | 603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008454.62539 | 2102106.73452 | 37.752462191692295 | -122.413639440921 | (37.7524621916923, -122.413639440921) | |||
| 20099 | 20099 | 615 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008105.608030001 | 2102127.9045700002 | 37.752500715042295 | -122.414847903135 | (37.7525007150423, -122.414847903135) | |||
| 120933 | 120933 | 617 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3141X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.41496254106501 | (37.7523835952977, -122.414962541065) | |||
| 103916 | 103916 | 618 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3141X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008071.59955 | 2102085.94599 | 37.7523835952977 | -122.41496254106501 | (37.7523835952977, -122.414962541065) | |||
| 109132 | 109132 | 624 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3157 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6007970.52254 | 2102065.21548 | 37.752320993709 | -122.415310615518 | (37.752320993709, -122.415310615518) | |||
| 95024 | 95024 | 628 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6007874.17365 | 2102144.23632 | 37.7525325514911 | -122.41564940087 | (37.7525325514911, -122.41564940087) | |||
| 94052 | 94052 | 631 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | |||
| 120426 | 120426 | 632 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3179 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | |||
| 139691 | 139691 | 634 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3194 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6007781.42285 | 2102140.57786 | 37.7525172919755 | -122.41596989079201 | (37.7525172919755, -122.415969890792) | |||
| 111485 | 111485 | 635 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3198 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6007763.62302 | 2102126.97717 | 37.752478946803606 | -122.416030482711 | (37.7524789468036, -122.416030482711) | |||
| 91976 | 91976 | 645 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 129104 | 129104 | 646 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 124697 | 124697 | 647 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 108234 | 108234 | 648 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 94745 | 94745 | 649 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.752380644434204 | -122.41725719966401 | (37.7523806444342, -122.417257199664) | |||
| 17517 | 17517 | 653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.752208423697205 | -122.41776437753201 | (37.7522084236972, -122.417764377532) | |||
| 124341 | 124341 | 661 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | |||
| 113025 | 113025 | 662 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3290X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | |||
| 79832 | 79832 | 665 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 80256 | 80256 | 668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 107557 | 107557 | 669 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3297X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | |||
| 83618 | 83618 | 693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 91816 | 91816 | 694 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1299X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 111276 | 111276 | 702 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1399X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005246.2674799 | 2100192.367786 | 37.747025098470004 | -122.42459832380699 | (37.74702509847, -122.424598323807) | |||
| 119613 | 119613 | 706 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1509X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005302.4951599995 | 2099477.85942 | 37.745066397258604 | -122.424353081707 | (37.7450663972586, -122.424353081707) | |||
| 77740 | 77740 | 1442 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | |||
| 92584 | 92584 | 1668 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999625.0 | 2119128.0 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | |||
| 105367 | 105367 | 1669 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2679X LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5999625.0 | 2119128.0 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | |||
| 98245 | 98245 | 1679 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 350X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994545.07613 | 2111468.1594 | 37.7773753373943 | -122.462419573309 | (37.7773753373943, -122.462419573309) | |||
| 101735 | 101735 | 1685 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 452X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994164.03145 | 2111506.7878 | 37.7774594509207 | -122.46374052558399 | (37.7774594509207, -122.463740525584) | |||
| 117188 | 117188 | 1760 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3041X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6005500.29496 | 2120778.87447 | 37.803564990343204 | -122.425184535531 | (37.8035649903432, -122.425184535531) | |||
| 145586 | 145586 | 2431 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004657.78302 | 2110211.2944799997 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | |||
| 139266 | 139266 | 2450 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1805X Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003959.5200660005 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | |||
| 82593 | 82593 | 2452 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1805X Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6003959.5200660005 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | |||
| 90423 | 90423 | 2714 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2185X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003185.15216 | 2114858.41892 | 37.787177886441796 | -122.43277299903099 | (37.7871778864418, -122.432772999031) | |||
| 98809 | 98809 | 2718 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2185X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | |||
| 139122 | 139122 | 2719 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2185X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | |||
| 4268 | 4268 | 2729 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | |||
| 110357 | 110357 | 4014 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1515X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999764.24548 | 2109470.85295 | 37.772190404364096 | -122.44422126053001 | (37.7721904043641, -122.44422126053) | |||
| 109528 | 109528 | 4281 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | |||
| 86273 | 86273 | 4418 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004420.057130001 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | |||
| 120738 | 120738 | 4455 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1404 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/2015 12:00:00 AM | 70 | 3X3 | 6004493.5375 | 2100668.30282 | 37.7482893665971 | -122.42723509655899 | (37.7482893665971, -122.427235096559) | ||
| 87573 | 87573 | 4493 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.745018530631796 | -122.42688241226101 | (37.7450185306318, -122.426882412261) | |||
| 124876 | 124876 | 4501 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | |||
| 101152 | 101152 | 4559 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 10x6 | 6005144.059593299 | 2101075.0968608996 | 37.749443096612204 | -122.425014546007 | (37.7494430966122, -122.425014546007) | |||
| 102076 | 102076 | 4573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 4 | 6011767.886 | 2117749.45401 | 37.7955990100454 | -122.403281883117 | (37.7955990100454, -122.403281883117) | |||
| 94766 | 94766 | 4593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.40437402195299 | (37.7966440043551, -122.404374021953) | |||
| 112890 | 112890 | 4595 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 81143 | 81143 | 4596 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 138416 | 138416 | 4597 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 80486 | 80486 | 4599 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 170 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6011285.22621 | 2118219.63855 | 37.796863055188496 | -122.40498510136801 | (37.7968630551885, -122.404985101368) | |||
| 19024 | 19024 | 4603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | |||
| 128568 | 128568 | 4604 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 270 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6010907.72336 | 2118541.73775 | 37.797726351991294 | -122.406314062528 | (37.7977263519913, -122.406314062528) | |||
| 66642 | 66642 | 4609 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | |
| 85762 | 85762 | 4619 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 358 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 6010602.3181300005 | 2118839.00805 | 37.798525495152795 | -122.407391821594 | (37.7985254951528, -122.407391821594) | |||
| 80323 | 80323 | 4626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010254.831619999 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | |||
| 138955 | 138955 | 4627 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 420 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 6010403.3977 | 2118996.0430900003 | 37.7989455393885 | -122.408091232197 | (37.7989455393885, -122.408091232197) | |||
| 96697 | 96697 | 4629 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.40859113666401 | (37.7990784717377, -122.408591136664) | |||
| 126838 | 126838 | 4630 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6010279.42625 | 2119026.32466 | 37.7990217431564 | -122.40852235367201 | (37.7990217431564, -122.408522353672) | |||
| 140339 | 140339 | 4631 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 430 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6010350.91598 | 2119042.6907900004 | 37.799070683936 | -122.408276129064 | (37.799070683936, -122.408276129064) | |||
| 115977 | 115977 | 4640 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 501 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6010023.44398 | 2119255.15348 | 37.7996357117478 | -122.409424299905 | (37.7996357117478, -122.409424299905) | |||
| 108750 | 108750 | 4652 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6009795.85928 | 2119479.51144 | 37.800238989308504 | -122.41022767808 | (37.8002389893085, -122.41022767808) | |||
| 112465 | 112465 | 4654 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6009795.85928 | 2119479.51144 | 37.800238989308504 | -122.41022767808 | (37.8002389893085, -122.41022767808) | |||
| 93705 | 93705 | 4657 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 599X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3x3 | 6009795.85928 | 2119479.51144 | 37.800238989308504 | -122.41022767808 | (37.8002389893085, -122.41022767808) | |||
| 100389 | 100389 | 4672 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 659 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6009562.16476 | 2119705.53614 | 37.8008464951643 | -122.411052329729 | (37.8008464951643, -122.411052329729) | |||
| 116547 | 116547 | 4683 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 707 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6009355.02929 | 2119856.39151 | 37.8012490888204 | -122.41177977375 | (37.8012490888204, -122.41177977375) | |||
| 109853 | 109853 | 4686 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 722 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6009336.3456 | 2120034.6979099996 | 37.8017376257964 | -122.411857034683 | (37.8017376257964, -122.411857034683) | |||
| 98281 | 98281 | 4693 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 781 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009263.30605 | 2120079.28345 | 37.801855948749 | -122.41211293899299 | (37.801855948749, -122.412112938993) | |||
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 126916 | 126916 | 4701 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456691999 | (37.8025035109944, -122.41317456692) | |||
| 7170 | 7170 | 4704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.803115382163206 | -122.414077244448 | (37.8031153821632, -122.414077244448) | |||
| 79031 | 79031 | 4709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 968 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/2016 07:32:00 AM | 3 | 5x5 | 6008598.6629099995 | 2120633.4675 | 37.8033402849031 | -122.41445215852801 | (37.8033402849031, -122.414452158528) | ||
| 90806 | 90806 | 4728 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 127950 | 127950 | 4729 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1075 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008196.257 | 2120907.2939400002 | 37.8040695291651 | -122.41586410452 | (37.8040695291651, -122.41586410452) | |||
| 116330 | 116330 | 4746 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1199X Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X4 | 6007816.30894 | 2121179.41413 | 37.804795334946796 | -122.417198239329 | (37.8047953349468, -122.417198239329) |
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");