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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3331 | 3331 | 140432 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6003204.3695 | 2112383.9326 | 37.7803846599605 | -122.432529697936 | (37.7803846599605, -122.432529697936) | |||
| 3348 | 3348 | 140430 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 TURK ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 05/18/1992 12:00:00 AM | 5 | Width 0ft | 6003115.3712 | 2112373.8844 | 37.7803520228236 | -122.432836866316 | (37.7803520228236, -122.432836866316) | ||
| 83157 | 83157 | 22713 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1401X Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 116875 | 116875 | 22715 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1401X Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 05/18/1992 12:00:00 AM | 12 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | ||
| 1491 | 1491 | 110535 | Private 5 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | Private 3 | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |
| 121101 | 121101 | 110540 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | City College 13 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |||
| 144922 | 144922 | 110534 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | City College 13 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |||
| 81407 | 81407 | 4017 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 700X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) | ||
| 89465 | 89465 | 114506 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 LOMBARD ST | 1 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 125405 | 125405 | 114508 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 LOMBARD ST | 3 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 79581 | 79581 | 117011 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 457X CASTRO ST | 1 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | Private 3 | 27 | 3x6 | 6002348.0 | 2105584.0 | 37.7616651256499 | -122.435005811888 | (37.7616651256499, -122.435005811888) | ||
| 107936 | 107936 | 118318 | Property Tree 7 | Maytenus boaria :: Mayten 22 | 20 Norton St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | 6002015.686319999 | 2092167.12899 | 37.724806667280895 | -122.435195459751 | (37.7248066672809, -122.435195459751) | |||||
| 47263 | 47263 | 100971 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Permit Number 37341 | 6009642.5454 | 2120895.3461 | 37.8041179253888 | -122.410858257388 | (37.8041179253888, -122.410858257388) | ||
| 55605 | 55605 | 100978 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009524.0508 | 2120877.4907 | 37.8040622540071 | -122.41126705605801 | (37.8040622540071, -122.411267056058) | ||
| 57285 | 57285 | 100977 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | ||
| 147766 | 147766 | 100979 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | Permit Number 37341 | 6009507.0071 | 2120874.2443 | 37.8040523843138 | -122.411325807727 | (37.8040523843138, -122.411325807727) | ||
| 177834 | 177834 | 100976 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | ||
| 1080 | 1080 | 9610 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1388X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/01/2017 01:42:00 PM | 3 | 3X3 | 6002958.1886 | 2112049.4711 | 37.7794523489738 | -122.433357444963 | (37.7794523489738, -122.433357444963) | ||
| 2696 | 2696 | 9611 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1390X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6002925.8908 | 2112046.6002 | 37.7794426338279 | -122.43346897140499 | (37.7794426338279, -122.433468971405) | ||
| 5378 | 5378 | 9456 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.780573233977705 | -122.424788902821 | (37.7805732339777, -122.424788902821) | ||
| 5863 | 5863 | 9461 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005331.3816 | 2112388.6106 | 37.780517893039395 | -122.425171696602 | (37.7805178930394, -122.425171696602) | ||
| 6304 | 6304 | 9451 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005532.2979 | 2112418.9375 | 37.7806125113537 | -122.424478789137 | (37.7806125113537, -122.424478789137) | ||
| 7171 | 7171 | 9447 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 3 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005622.1957 | 2112431.3933 | 37.780651788182794 | -122.424168675479 | (37.7806517881828, -122.424168675479) | |||
| 7570 | 7570 | 9448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 4 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 12 | 3X3 | 6005590.2441 | 2112426.5193 | 37.78063660125729 | -122.424278864743 | (37.7806366012573, -122.424278864743) | ||
| 7740 | 7740 | 9445 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/01/1994 12:00:00 AM | 12 | 3X3 | 6005680.1419 | 2112439.5166 | 37.780677364386705 | -122.423968789396 | (37.7806773643867, -122.423968789396) | ||
| 8920 | 8920 | 9449 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 5 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | |||
| 76131 | 76131 | 9462 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 77876 | 77876 | 9463 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 78511 | 78511 | 9477 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/18/1992 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 79530 | 79530 | 9479 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 89209 | 89209 | 9466 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 89936 | 89936 | 9476 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 93591 | 93591 | 9467 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 95023 | 95023 | 9472 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 99808 | 99808 | 9475 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 102216 | 102216 | 9478 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | ||
| 107612 | 107612 | 9464 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 114087 | 114087 | 20505 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1211X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 116376 | 116376 | 9469 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 116831 | 116831 | 9473 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 125854 | 125854 | 9468 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 144830 | 144830 | 9474 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 800X Golden Gate Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.780666842627795 | -122.423843265886 | (37.7806668426278, -122.423843265886) | |||
| 46 | 46 | 18228 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 12 | 3X3 | 6003682.1522 | 2114179.2812 | 37.785341320174396 | -122.431004998109 | (37.7853413201744, -122.431004998109) | ||
| 202 | 202 | 138810 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2355 PINE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002718.089 | 2115091.954 | 37.787792613821004 | -122.434405637805 | (37.787792613821, -122.434405637805) | |||
| 212 | 212 | 138800 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2375 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6002511.9355 | 2115060.8724 | 37.7876955676952 | -122.435116665287 | (37.7876955676952, -122.435116665287) | |||
| 237 | 237 | 2654 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1988 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2005 12:00:00 AM | 12 | 3X3 | 6004003.2237 | 2114978.8425 | 37.7875549020514 | -122.429951242636 | (37.7875549020514, -122.429951242636) | ||
| 278 | 278 | 9598 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003113.217999999 | 2112071.7207 | 37.7795222347306 | -122.43282272296999 | (37.7795222347306, -122.43282272297) | |||
| 686 | 686 | 23735 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 805 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2016 12:00:00 AM | 12 | 4X4 | 6003900.7925 | 2111534.0109 | 37.778090453740504 | -122.430059798517 | (37.7780904537405, -122.430059798517) | ||
| 753 | 753 | 48 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6003376.13457 | 2107738.85817 | 37.767640169485105 | -122.43160376032499 | (37.7676401694851, -122.431603760325) | |||
| 770 | 770 | 231129 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 821 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6003305.97559 | 2107686.68734 | 37.7674929441754 | -122.431842705671 | (37.7674929441754, -122.431842705671) | |||
| 893 | 893 | 18095 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3001 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5999540.0604 | 2114647.8242 | 37.7863922432736 | -122.44536903339501 | (37.7863922432736, -122.445369033395) | |||
| 1155 | 1155 | 14734 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 895 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4x4 | 6004929.3578 | 2111921.9134 | 37.7792137381495 | -122.42652924677799 | (37.7792137381495, -122.426529246778) | |||
| 1353 | 1353 | 14712 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 845 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/1993 12:00:00 AM | 8 | 4x4 | 6005208.5684 | 2111961.5273 | 37.779338288494 | -122.42556616152099 | (37.779338288494, -122.425566161521) | ||
| 1581 | 1581 | 111 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 955 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002518.0 | 2107623.0 | 37.767273374303706 | -122.43456365047399 | (37.7672733743037, -122.434563650474) | |||
| 1818 | 1818 | 139879 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 870 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/16/2000 12:00:00 AM | 12 | Width 0ft | 6005009.3284 | 2111993.411 | 37.779414573538205 | -122.42625768702801 | (37.7794145735382, -122.426257687028) | ||
| 1897 | 1897 | 245386 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 6 | Width 0ft | 6006500.2854 | 2099391.485 | 37.7448967968639 | -122.420205198271 | (37.7448967968639, -122.420205198271) | ||
| 2124 | 2124 | 22782 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1866 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001070.0369 | 2112136.3428 | 37.7795835769795 | -122.439895576072 | (37.7795835769795, -122.439895576072) | |||
| 2458 | 2458 | 9644 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1495 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6002520.4964 | 2111934.6452 | 37.7791122249761 | -122.434863391819 | (37.7791122249761, -122.434863391819) | |||
| 2579 | 2579 | 14672 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 739 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005639.1537 | 2112019.7041 | 37.7795223479045 | -122.424080723662 | (37.7795223479045, -122.424080723662) | |||
| 2827 | 2827 | 18276 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1950 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002797.4872 | 2114109.7892 | 37.78510034529771 | -122.434060698947 | (37.7851003452977, -122.434060698947) | |||
| 3222 | 3222 | 5838 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 860 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1997 12:00:00 AM | 6 | 3X3 | 6006312.21276 | 2113211.9775099996 | 37.7828340176265 | -122.421837034768 | (37.7828340176265, -122.421837034768) | ||
| 3346 | 3346 | 139859 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 704 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005699.1313 | 2112090.0249 | 37.7797188177748 | -122.423878237045 | (37.7797188177748, -122.423878237045) | |||
| 3353 | 3353 | 139860 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 706 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2016 12:00:00 AM | 8 | Width 0ft | 6005680.9512 | 2112087.9472 | 37.7797120865642 | -122.42394098222 | (37.7797120865642, -122.42394098222) | ||
| 3501 | 3501 | 247943 | Planning Code 138.1 required 4 | Maytenus boaria :: Mayten 22 | 29 Joy St | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 2 | Permit Number 775404 | 6010304.2598 | 2098903.51059 | 37.7437705318851 | -122.407017307297 | (37.7437705318851, -122.407017307297) | |||
| 3771 | 3771 | 47 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1998 12:00:00 AM | 6 | 3X3 | 6003389.5525400005 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | ||
| 4327 | 4327 | 103839 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1552 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.2576 | 2116316.1212 | 37.791378262309706 | -122.420766896 | (37.7913782623097, -122.420766896) | ||
| 4535 | 4535 | 12416 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1660 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004502.1372 | 2114559.4680000003 | 37.786431646664205 | -122.428195201763 | (37.7864316466642, -122.428195201763) | ||
| 5150 | 5150 | 12412 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1620 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004511.4773 | 2114458.3749 | 37.786154598782396 | -122.428155680217 | (37.7861545987824, -122.428155680217) | |||
| 5265 | 5265 | 5279 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001320.5373 | 2113019.2025 | 37.7820219415228 | -122.43909228156001 | (37.7820219415228, -122.43909228156) | |||
| 5341 | 5341 | 19786 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 5438 | 5438 | 7826 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 807 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6006132.89126 | 2112941.5799 | 37.7820814577469 | -122.422438193788 | (37.7820814577469, -122.422438193788) | |||
| 5464 | 5464 | 18230 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2004 12:00:00 AM | 3 | 3X3 | 6003859.0712 | 2114201.8624 | 37.7854133456405 | -122.430394523724 | (37.7854133456405, -122.430394523724) | ||
| 5510 | 5510 | 20148 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1028 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1999 12:00:00 AM | 3 | 4X4 | 6002939.2419 | 2111824.3037 | 37.7788330206804 | -122.433406894695 | (37.7788330206804, -122.433406894695) | ||
| 5621 | 5621 | 6044 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1834 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001440.1248 | 2112530.373 | 37.780686543842705 | -122.43864352716801 | (37.7806865438427, -122.438643527168) | |||
| 5760 | 5760 | 20149 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1040 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002932.4508 | 2111847.2891 | 37.7788957475604 | -122.433432030761 | (37.7788957475604, -122.433432030761) | |||
| 5778 | 5778 | 24244 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 289X Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006236.37633 | 2113335.30136 | 37.7831683576867 | -122.42210816146499 | (37.7831683576867, -122.422108161465) | |||
| 5790 | 5790 | 18038 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2809 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000359.9496 | 2114756.9723 | 37.7867387044094 | -122.442540272299 | (37.7867387044094, -122.442540272299) | |||
| 6164 | 6164 | 5280 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001316.1378 | 2113050.3373 | 37.7821071794141 | -122.43910973392799 | (37.7821071794141, -122.439109733928) | |||
| 6207 | 6207 | 17935 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2426 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002142.0869 | 2115065.9831 | 37.787688592105205 | -122.436396634074 | (37.7876885921052, -122.436396634074) | |||
| 6320 | 6320 | 9597 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1340 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/1994 12:00:00 AM | 12 | 3X3 | 6003188.5795 | 2112083.2043 | 37.779558039769505 | -122.432562836067 | (37.7795580397695, -122.432562836067) | ||
| 6358 | 6358 | 14669 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 731 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 4x4 | 6005678.1934 | 2112026.9763 | 37.7795445196864 | -122.423946185798 | (37.7795445196864, -122.423946185798) | |||
| 6451 | 6451 | 17934 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2424 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002175.8086 | 2115067.4242 | 37.7876944650438 | -122.436280066856 | (37.7876944650438, -122.436280066856) | |||
| 6498 | 6498 | 18062 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2901 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1994 12:00:00 AM | 12 | 3X3 | 6000020.8872 | 2114713.4888 | 37.786599977163704 | -122.443710218956 | (37.7865999771637, -122.443710218956) | ||
| 6559 | 6559 | 18229 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 3X3 | 6003704.9298 | 2114183.2083 | 37.7853533936228 | -122.43092647489901 | (37.7853533936228, -122.430926474899) | ||
| 6562 | 6562 | 17937 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2430 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002084.443 | 2115054.4543 | 37.7876536614139 | -122.436595244995 | (37.7876536614139, -122.436595244995) | |||
| 6908 | 6908 | 7825 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 807 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006133.13296 | 2112953.34413 | 37.7821137730772 | -122.422438193776 | (37.7821137730772, -122.422438193776) | |||
| 7144 | 7144 | 20150 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1040 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002930.8836 | 2111873.4088 | 37.7789673768152 | -122.433439319366 | (37.7789673768152, -122.433439319366) | |||
| 7266 | 7266 | 17932 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2418 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002216.7357 | 2115077.2237 | 37.787723697261896 | -122.43613916872499 | (37.7877236972619, -122.436139168725) | |||
| 7350 | 7350 | 17974 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2519 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001636.0692 | 2114939.9757 | 37.78731384268 | -122.438138324219 | (37.78731384268, -122.438138324219) | |||
| 7511 | 7511 | 17938 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2432 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 4x4 | 6002059.6562 | 2115054.4543 | 37.7876522528246 | -122.436681002358 | (37.7876522528246, -122.436681002358) | |||
| 7565 | 7565 | 18105 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3053 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999309.1186 | 2114616.1068 | 37.7862919697055 | -122.446165748193 | (37.7862919697055, -122.446165748193) | |||
| 7687 | 7687 | 5278 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1350 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001321.891 | 2113007.3577 | 37.781989495746394 | -122.439086749209 | (37.7819894957464, -122.439086749209) | |||
| 7757 | 7757 | 18225 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1675 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 3x3 | 6004149.2891 | 2114241.9195 | 37.7855397675254 | -122.42939331414699 | (37.7855397675254, -122.429393314147) | ||
| 7760 | 7760 | 14671 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4x4 | 6005659.8218 | 2112023.5316 | 37.779534024179995 | -122.42400949606301 | (37.77953402418, -122.424009496063) | |||
| 7869 | 7869 | 18231 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1737-1795 Post St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 3X3 | 6003887.3468 | 2114207.7531 | 37.785431121654895 | -122.430297119046 | (37.7854311216549, -122.430297119046) | ||
| 8038 | 8038 | 18275 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1950 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002826.7788 | 2114117.8444 | 37.7851241251679 | -122.433959935292 | (37.7851241251679, -122.433959935292) | |||
| 8076 | 8076 | 17868 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2127 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/1992 12:00:00 AM | 12 | 3X3 | 6003572.046 | 2115203.4059 | 37.7881470684138 | -122.431459068113 | (37.7881470684138, -122.431459068113) | ||
| 8254 | 8254 | 19248 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 719 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002022.643999999 | 2111108.6569999997 | 37.7768159902052 | -122.43652652713999 | (37.7768159902052, -122.43652652714) | |||
| 8570 | 8570 | 17936 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2428 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002109.8063 | 2115059.6423 | 37.7876693476195 | -122.436507864526 | (37.7876693476195, -122.436507864526) | |||
| 8827 | 8827 | 12430 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1734 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 3 | 3X3 | 6004454.6634 | 2114845.8604 | 37.787215322181794 | -122.428379869098 | (37.7872153221818, -122.428379869098) |
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");