trees
563 rows where qSpecies_id = 52 sorted by DBH descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115522 | 24058 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 151453 | 111293 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 1 | Median : Cutout | Tree | DPW 1 | 30 | 6005565 | 2097823 | 37.7405373480538 | -122.423327767767 | (37.7405373480538, -122.423327767767) | 2 | 7 | 7 | 28859 | 2 | ||||
| 153115 | 199401 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 18 | Median : Yard | Tree | DPW 1 | 30 | 6016684.16305 | 2095970.28806 | 37.7360714484387 | -122.384752612468 | (37.7360714484387, -122.384752612468) | 10 | 3 | 8 | 58 | 1 | ||||
| 160685 | 14900 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 170 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6016995.24275 | 2098361.00599 | 37.7426530781013 | -122.383843483695 | (37.7426530781013, -122.383843483695) | 10 | 3 | 8 | 58 | 1 | |||
| 173951 | 224205 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 30 | 6005328.89296 | 2097313.98871 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | 2 | 7 | 5 | 28859 | 2 | ||||
| 185417 | 10770 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1120X Hudson Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.7325250651963 | -122.380424102302 | (37.7325250651963, -122.380424102302) | 10 | 3 | 8 | 58 | 1 | |||
| 10734 | 20046 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY52 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 10 | |||||||||||||
| 19966 | 4328 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 816 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2000 12:00:00 AM | 3 | 3X3 | 6001892.96711 | 2095861.16752 | 37.7349426843331 | -122.435883876812 | (37.7349426843331, -122.435883876812) | 2 | 7 | 5 | 63 | 7 | ||
| 29824 | 60301 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 158 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2015 12:00:00 AM | 3 | Permit Number 775317 | 6004878.91046715 | 2099326.15693939 | 37.744625928835 | -122.425806967542 | (37.744625928835, -122.425806967542) | 2 | 7 | 5 | 63 | 22 | ||
| 37416 | 24066 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 48855 | 6103 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 5 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 55652 | 107385 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2518X Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:45:00 AM | 3 | 3x3 | 6002277 | 2097180 | 37.738585702214 | -122.434650415337 | (37.738585702214, -122.434650415337) | 2 | 7 | 5 | 63 | 7 | ||
| 83538 | 6101 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 84713 | 116639 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2100 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 6011723.51737 | 2104681.28704 | 37.7597143642338 | -122.402516023304 | (37.7597143642338, -122.402516023304) | 10 | 3 | 8 | 28856 | 29 | ||
| 87041 | 11320 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1216X Ingalls St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/22/1999 12:00:00 AM | 3 | 3X3 | 6017561.7867095 | 2093983.7658262 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | 10 | 3 | 8 | 58 | 1 | ||
| 111489 | 252877 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1400 Baker St | 2 | Front Yard : Yard | Tree | Private 2 | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779185 | 6000422 | 2113928 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | 15 | 6 | 11 | 29490 | 13 | |
| 149269 | 187038 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | 1 | 8 | 3 | 29491 | 35 | |||
| 152575 | 6105 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 157768 | 115772 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1204 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775363 | 6015358.9 | 2090410.1 | 37.7207308974409 | -122.388946547811 | (37.7207308974409, -122.388946547811) | 10 | 3 | 8 | 58 | 1 | ||
| 173225 | 1855 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2500 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 6 | 6010837.5147418 | 2086759.4488697 | 37.7104552954566 | -122.404318844881 | (37.7104552954566, -122.404318844881) | 9 | 7 | 8 | 309 | 39 | |||
| 12925 | 122943 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 300 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
| 29305 | 187037 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2501 Sunset Blvd | 56 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 0ft | 5984959.5362 | 2097794.0341 | 37.7392733453171 | -122.494570293909 | (37.7392733453171, -122.494570293909) | 1 | 8 | 3 | 29491 | 35 | |||
| 137795 | 176310 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500x Mansell St | 8 | Median : Cutout | Tree | DPW 1 | 29 | Width 0ft | 6010469.51848 | 2090335.25755 | 37.7202531668397 | -122.405842444672 | (37.7202531668397, -122.405842444672) | 10 | 7 | 8 | 309 | 28 | |||
| 3737 | 51577 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | 11 | 6 | 2 | 55 | 26 | ||
| 21497 | 106463 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 3 | Median : Cutout | Tree | DPW 1 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 134558 | 176305 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 300x Mansell St | 3 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6010925.66518 | 2090483.18833 | 37.7206848540134 | -122.404276094583 | (37.7206848540134, -122.404276094583) | 10 | 7 | 7 | 309 | 28 | |||
| 151085 | 106464 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 5 | Median : Cutout | Tree | DPW 1 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 62995 | 199408 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 5 Cashmere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6017196.63462 | 2095827.84715 | 37.7357086637323 | -122.382970863038 | (37.7357086637323, -122.382970863038) | 10 | 3 | 8 | 58 | 1 | |||
| 110737 | 199410 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 822 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6015932.24155 | 2096672.73443 | 37.7379586091972 | -122.387401320018 | (37.7379586091972, -122.387401320018) | 10 | 3 | 8 | 58 | 1 | |||
| 138784 | 199409 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 822 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6015943.97928 | 2096692.65499 | 37.738013957089 | -122.387362125771 | (37.738013957089, -122.387362125771) | 10 | 3 | 8 | 58 | 1 | |||
| 170148 | 176331 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 700x Mansell St | 36 | Median : Cutout | Tree | DPW 1 | 27 | Width 0ft | 6009160.31915 | 2089943.19891 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | 9 | 3 | 8 | 309 | 18 | |||
| 36101 | 106466 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 6 | Median : Cutout | Tree | DPW 1 | 26 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 103774 | 106579 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 3 | Median : Yard | Tree | DPW 1 | 26 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 153238 | 224215 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | 2 | 7 | 5 | 28859 | 7 | ||||
| 184937 | 61435 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.443874903825 | (37.7589393153031, -122.443874903825) | 2 | 4 | 5 | 28862 | 3 | |
| 185356 | 199402 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 20 | Median : Yard | Tree | DPW 1 | 26 | 6016663.61896 | 2095979.59061 | 37.7360958551344 | -122.384824290234 | (37.7360958551344, -122.384824290234) | 10 | 3 | 8 | 58 | 1 | ||||
| 27402 | 106587 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 8 | Median : Yard | Tree | DPW 1 | 25 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 63002 | 199405 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Cashmere St | 4 | Median : Yard | Tree | DPW 1 | 25 | 6016273.90453 | 2096214.73214 | 37.736719944173 | -122.386188091409 | (37.736719944173, -122.386188091409) | 10 | 3 | 8 | 58 | 1 | ||||
| 119646 | 106585 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 6 | Median : Yard | Tree | DPW 1 | 25 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 128798 | 99751 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 500x Clipper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 1046 Diamond St | 6001860.7 | 2100931.8 | 37.7488636216299 | -122.436358217698 | (37.7488636216299, -122.436358217698) | 2 | 4 | 5 | 28862 | 22 | ||
| 165498 | 75663 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.7695031998873 | -122.429523817606 | (37.7695031998873, -122.429523817606) | 7 | 9 | 5 | 29492 | 10 | |||
| 176103 | 26776 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 800X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 179282 | 224214 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 25 | 6005180.62218 | 2097351.71746 | 37.7392216116736 | -122.424623281961 | (37.7392216116736, -122.424623281961) | 2 | 7 | 5 | 28859 | 7 | ||||
| 183690 | 63265 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | 15 | 5 | 11 | 29490 | 41 | |
| 163 | 17253 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 15 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017345.102761 | 2094248.0837329 | 37.7313791485056 | -122.382347671583 | (37.7313791485056, -122.382347671583) | 10 | 3 | 8 | 58 | 1 | |||
| 3552 | 19877 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY33 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 25ST | |||||||||||||
| 4099 | 19572 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 9166 | 19571 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 16816 | 19567 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 STAIRWAY1 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 30090 | 11422 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 803X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6016040.90005 | 2096755.86498 | 37.738192886184 | -122.38703142706 | (37.738192886184, -122.38703142706) | 10 | 3 | 8 | 58 | 1 | |||
| 51469 | 12490 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 56199 | 224207 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 64 | Front Yard : Yard | Tree | Private 2 | 24 | Width 8ft | 6005337.33065 | 2097353.93167 | 37.7392365404433 | -122.42408161129 | (37.7392365404433, -122.42408161129) | 2 | 7 | 5 | 28859 | 2 | |||
| 61285 | 106578 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 2 | Median : Yard | Tree | DPW 1 | 24 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 69573 | 109852 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 3250x 22nd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
| 70237 | 24064 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 80444 | 12496 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 81190 | 11969 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 960X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6015772.64696 | 2096469.87167 | 37.7373927489725 | -122.387938970322 | (37.7373927489725, -122.387938970322) | 10 | 3 | 8 | 58 | 1 | |||
| 84267 | 176318 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 600x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6009900.75619 | 2090162.07565 | 37.71974582058 | -122.40779627129 | (37.71974582058, -122.40779627129) | 9 | 7 | 8 | 309 | 18 | |||
| 94210 | 176309 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 300x Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6010760.4946 | 2090426.07331 | 37.720518796898 | -122.404843021812 | (37.720518796898, -122.404843021812) | 10 | 7 | 7 | 309 | 28 | |||
| 97104 | 17274 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 60 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017079.314769 | 2094437.156895 | 37.7318836214292 | -122.383279715267 | (37.7318836214292, -122.383279715267) | 10 | 3 | 8 | 58 | 1 | |||
| 99234 | 176299 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 10x Mansell St | 7 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 6011728.48955 | 2090724.05613 | 37.7213910565415 | -122.40151788377 | (37.7213910565415, -122.40151788377) | 10 | 7 | 8 | 309 | 28 | |||
| 99638 | 17273 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 53 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017144.20686 | 2094317.06632 | 37.7315574623644 | -122.383047012358 | (37.7315574623644, -122.383047012358) | 10 | 3 | 8 | 58 | 1 | |||
| 114508 | 17282 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 85 Osceola Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6016960.7843 | 2094470.78287 | 37.7319694006113 | -122.38369184425 | (37.7319694006113, -122.38369184425) | 10 | 3 | 8 | 58 | 1 | |||
| 118053 | 12488 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 307 Lake Merced Blvd | 33 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 90M | 5985224.7663097 | 2094165.6248747 | 37.7293262181041 | -122.49338600271 | (37.7293262181041, -122.49338600271) | 1 | 8 | 4 | 64 | 14 | |||
| 124032 | 24062 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 130862 | 24059 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 140238 | 6100 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
| 141466 | 224206 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 59 | Front Yard : Yard | Tree | Private 2 | 24 | 6005333.6743 | 2097319.76234 | 37.7391425127264 | -122.424091823995 | (37.7391425127264, -122.424091823995) | 2 | 7 | 5 | 28859 | 2 | ||||
| 153721 | 17255 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 17 Osceola Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017331.5843984 | 2094252.3198967 | 37.7313900334691 | -122.382394702172 | (37.7313900334691, -122.382394702172) | 10 | 3 | 8 | 58 | 1 | |||
| 153948 | 104993 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 669X NOE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6003139 | 2104447 | 37.7585880783392 | -122.432188863302 | (37.7585880783392, -122.432188863302) | 2 | 4 | 5 | 28862 | 3 | |||
| 165943 | 24065 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 168410 | 17278 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 75 Osceola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6016964.0762842 | 2094462.847211 | 37.731947792828 | -122.383679910748 | (37.731947792828, -122.383679910748) | 10 | 3 | 8 | 58 | 1 | |||
| 175807 | 11270 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1176X Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/1990 12:00:00 AM | 24 | 3X3 | 6017716.362196 | 2093961.1645628 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | 10 | 3 | 8 | 58 | 1 | ||
| 178181 | 109851 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 3250x 22ND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
| 180018 | 24063 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 21X Whitfield Ct | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3X3 | 6017547.7495644 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | 10 | 3 | 8 | 58 | 1 | |||
| 190393 | 105665 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 317X DORADO TER | 2 | unknown : Yard | Tree | Private 2 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
| 31265 | 176308 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 300x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010842.73462 | 2090461.59096 | 37.7206209176161 | -122.404561241708 | (37.7206209176161, -122.404561241708) | 10 | 7 | 7 | 309 | 28 | |||
| 42151 | 176303 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 200x Mansell St | 16 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6011115.33526 | 2090539.97459 | 37.7208513742667 | -122.403624453898 | (37.7208513742667, -122.403624453898) | 10 | 7 | 7 | 309 | 28 | |||
| 98318 | 113498 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 200x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 23 | 3x3 | 6011210.15679 | 2090562.2005 | 37.7209176983622 | -122.403298245537 | (37.7209176983622, -122.403298245537) | 10 | 7 | 7 | 309 | 28 | |||
| 139874 | 97392 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 | |
| 154498 | 97394 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 907 Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2011 12:00:00 AM | 23 | 4x4 | Permit Number 768003 | 6001936 | 2101462 | 37.7503237031932 | -122.436135767062 | (37.7503237031932, -122.436135767062) | 2 | 4 | 5 | 28862 | 22 | |
| 159523 | 218793 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 10ft | 5998053.08406 | 2095010.86684 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | 9 | 7 | 4 | 59 | 40 | |||
| 172701 | 176298 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 10x Mansell St | 6 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6011748.91192 | 2090731.58234 | 37.7214128614948 | -122.401447817564 | (37.7214128614948, -122.401447817564) | 10 | 7 | 8 | 309 | 28 | |||
| 2604 | 224449 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1201 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 22 | 6004503.55801 | 2096138.79869 | 37.7358529500558 | -122.426877907491 | (37.7358529500558, -122.426877907491) | 2 | 7 | 5 | 28861 | 2 | ||||
| 88183 | 224451 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 56 | Front Yard : Yard | Tree | Private 2 | 22 | 6003260.74151 | 2095484.49376 | 37.7339860276158 | -122.431128125086 | (37.7339860276158, -122.431128125086) | 2 | 7 | 5 | 63 | 7 | ||||
| 91041 | 106583 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 5 | Median : Yard | Tree | DPW 1 | 22 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 91209 | 199399 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 14 | Median : Yard | Tree | DPW 1 | 22 | 6016725.29246 | 2095937.31293 | 37.7359831799735 | -122.38460811387 | (37.7359831799735, -122.38460811387) | 10 | 3 | 8 | 58 | 1 | ||||
| 95300 | 176297 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 10x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6011769.33402 | 2090739.1089 | 37.7214346673524 | -122.401377752274 | (37.7214346673524, -122.401377752274) | 10 | 7 | 8 | 309 | 28 | |||
| 104779 | 224208 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6005339.07699 | 2097371.10972 | 37.7392838060945 | -122.424076794516 | (37.7392838060945, -122.424076794516) | 2 | 7 | 5 | 28859 | 2 | |||
| 121468 | 106584 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 5 | Median : Yard | Tree | DPW 1 | 22 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 125954 | 105666 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 317X DORADO TER | 3 | unknown : Yard | Tree | Private 2 | 22 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | 9 | 8 | 4 | 28861 | 40 | ||||
| 138456 | 176300 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 10x Mansell St | 8 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6011702.06583 | 2090731.87272 | 37.7214110448664 | -122.401609772869 | (37.7214110448664, -122.401609772869) | 10 | 3 | 8 | 309 | 28 | |||
| 144698 | 199406 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Cashmere St | 6 | Median : Yard | Tree | DPW 1 | 22 | 6016219.39095 | 2096203.76694 | 37.7366868185504 | -122.386375806006 | (37.7366868185504, -122.386375806006) | 10 | 3 | 8 | 58 | 1 | ||||
| 44136 | 224450 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 21 | 6003275.39086 | 2095494.74346 | 37.7340150010873 | -122.431078209119 | (37.7340150010873, -122.431078209119) | 2 | 7 | 5 | 63 | 7 | ||||
| 183936 | 224217 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 115 | Front Yard : Yard | Tree | Private 2 | 21 | 6005000.71693 | 2096893.74168 | 37.7379539516063 | -122.4252127345 | (37.7379539516063, -122.4252127345) | 2 | 7 | 5 | 63 | 7 | ||||
| 194035 | 122180 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.473055677376 | (37.784578471021, -122.473055677376) | 11 | 6 | 2 | 54 | 26 | |||
| 106932 | 20988 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2002X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 200 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 8705 | 224209 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | 2 | 7 | 5 | 28859 | 2 | ||||
| 36545 | 176317 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 600x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6009952.88344 | 2090194.234 | 37.7198370388417 | -122.407618351232 | (37.7198370388417, -122.407618351232) | 10 | 3 | 8 | 309 | 18 | |||
| 63332 | 95379 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );