Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 27 | 244214 | Private 5 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.43559821674499 | (37.7730099442883, -122.435598216745) | |
| 50 | 50 | 138938 | Private 5 | Tree(s) :: 17 | 632 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779650 | 6004797.9634 | 2110922.1515 | 37.7764612085261 | -122.426912572117 | (37.7764612085261, -122.426912572117) | |
| 51 | 51 | 60867 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/1983 12:00:00 AM | Permit Number 20649 | |||||||||
| 57 | 57 | 44642 | Permitted Site 1 | Tree(s) :: 17 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 59 | 59 | 44994 | Permitted Site 1 | Tree(s) :: 17 | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 77 | 77 | 49739 | Permitted Site 1 | Tree(s) :: 17 | 145 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779552 | 6013462.1222 | 2106403.54987 | 37.764540227980206 | -122.396623740816 | (37.7645402279802, -122.396623740816) | |
| 89 | 89 | 251189 | Permitted Site 1 | Tree(s) :: 17 | 1493 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 3x3 | 6016267.45517 | 2096986.6643299998 | 37.7388391569445 | -122.38626419104999 | (37.7388391569445, -122.38626419105) | ||
| 136 | 136 | 213016 | Undocumented 2 | Tree(s) :: 17 | 120 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779661 | 5993626.83548 | 2102594.2327400004 | 37.7529569465285 | -122.4649514087 | (37.7529569465285, -122.4649514087) | |
| 169 | 169 | 251221 | Permitted Site 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | ||||||
| 172 | 172 | 48332 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 204 | 204 | 61453 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1984 12:00:00 AM | Permit Number 21392 | |||||||||
| 235 | 235 | 45975 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 245 | 245 | 251255 | Undocumented 2 | Tree(s) :: 17 | 4089x Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991686.0 | 2086822.0 | 37.7095382490701 | -122.47051450746099 | (37.7095382490701, -122.470514507461) | ||||
| 252 | 252 | 182864 | DPW Maintained 3 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | ||
| 266 | 266 | 173827 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 274 | 274 | 173825 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 276 | 276 | 173808 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
| 279 | 279 | 48153 | Permitted Site 1 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 282 | 282 | 173829 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 283 | 283 | 173821 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 287 | 287 | 173824 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 289 | 289 | 173826 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 290 | 290 | 173809 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
| 297 | 297 | 32804 | Permitted Site 1 | Tree(s) :: 17 | 1683 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779644 | 5999817.40523345 | 2110171.54968226 | 37.774117372599896 | -122.44408773423099 | (37.7741173725999, -122.444087734231) | |
| 298 | 298 | 173822 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 301 | 301 | 173819 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 302 | 302 | 187663 | Undocumented 2 | Tree(s) :: 17 | 1155 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779411 | 6015039.0 | 2109715.0 | 37.77372037595529 | -122.391401215397 | (37.7737203759553, -122.391401215397) | |
| 304 | 304 | 173811 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
| 306 | 306 | 173816 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 307 | 307 | 173828 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 308 | 308 | 46059 | Permitted Site 1 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 311 | 311 | 173810 | Undocumented 2 | Tree(s) :: 17 | 1201 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779410 | 6015204.0 | 2109228.0 | 37.772392338117704 | -122.390796408976 | (37.7723923381177, -122.390796408976) | |
| 314 | 314 | 173820 | Undocumented 2 | Tree(s) :: 17 | 1200 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779409 | 6015021.0 | 2109379.0 | 37.7727967954964 | -122.39143998666 | (37.7727967954964, -122.39143998666) | |
| 316 | 316 | 67789 | Permitted Site 1 | Tree(s) :: 17 | 7 4384 St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31429 | ||||||||
| 318 | 318 | 142205 | Permitted Site 1 | Tree(s) :: 17 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.44403063203698 | (37.774143230926, -122.444030632037) | ||
| 320 | 320 | 48259 | Permitted Site 1 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 321 | 321 | 65143 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | Permit Number 27118 | |||||||||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 434 | 434 | 136390 | Undocumented 2 | Tree(s) :: 17 | 3395 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779746 | 5998765.27001 | 2115243.09553 | 37.787982442971604 | -122.448092477507 | (37.7879824429716, -122.448092477507) | |
| 439 | 439 | 136984 | Undocumented 2 | Tree(s) :: 17 | 454 Walnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779785 | 5998641.89853 | 2115102.68231 | 37.7875898520492 | -122.448509202661 | (37.7875898520492, -122.448509202661) | |
| 444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 515 | 515 | 48129 | Permitted Site 1 | Tree(s) :: 17 | 297 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 536 | 536 | 45913 | Permitted Site 1 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 580 | 580 | 48268 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 604 | 604 | 171523 | Permitted Site 1 | Tree(s) :: 17 | 281 Harvard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779632 | 6006304.03409 | 2092571.58308 | 37.7261597980302 | -122.420399821019 | (37.7261597980302, -122.420399821019) | |
| 607 | 607 | 65964 | Permitted Site 1 | Tree(s) :: 17 | 2655 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779612 | 5989236.70778952 | 2097278.67232438 | 37.738107703581704 | -122.479744212489 | (37.7381077035817, -122.479744212489) | |
| 610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 617 | 617 | 57850 | Permitted Site 1 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16791 | ||||||||
| 632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 633 | 633 | 48204 | Permitted Site 1 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 689 | 689 | 48269 | Permitted Site 1 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 705 | 705 | 105051 | Permitted Site 1 | Tree(s) :: 17 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.769633771891606 | -122.445015457708 | (37.7696337718916, -122.445015457708) | ||
| 726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 734 | 734 | 173936 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 743 | 743 | 224663 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008964.71968 | 2105285.1997599998 | 37.761218168313704 | -122.412100053373 | (37.7612181683137, -122.412100053373) | |
| 751 | 751 | 224664 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008962.07625 | 2105304.40117 | 37.761270742678704 | -122.412110552966 | (37.7612707426787, -122.412110552966) | |
| 755 | 755 | 224665 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008961.65131 | 2105333.13094 | 37.7613496042185 | -122.412114053139 | (37.7613496042185, -122.412114053139) | |
| 771 | 771 | 224662 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008966.3106 | 2105264.00424 | 37.7611600595223 | -122.412093053058 | (37.7611600595223, -122.412093053058) | |
| 774 | 774 | 231034 | Permitted Site 1 | Tree(s) :: 17 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008943.01244 | 2104996.16235 | 37.760423319597294 | -122.412154701577 | (37.7604233195973, -122.412154701577) | |
| 788 | 788 | 173935 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 862 | 862 | 141567 | Permitted Site 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.44145768074499 | (37.7756308363396, -122.441457680745) | |
| 882 | 882 | 187661 | Undocumented 2 | Tree(s) :: 17 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779411 | 6015039.0 | 2109715.0 | 37.77372037595529 | -122.391401215397 | (37.7737203759553, -122.391401215397) | |
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 933 | 933 | 203966 | Undocumented 2 | Tree(s) :: 17 | 200 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | Permit Number 779992 | 5992562.812059999 | 2097843.65033 | 37.739851654243296 | -122.46828540055901 | (37.7398516542433, -122.468285400559) | ||
| 937 | 937 | 45898 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 944 | 944 | 211703 | Undocumented 2 | Tree(s) :: 17 | 248 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779802 | 5994526.77657 | 2088729.78807 | 37.7149404380179 | -122.460834540792 | (37.7149404380179, -122.460834540792) | |
| 952 | 952 | 48321 | Permitted Site 1 | Tree(s) :: 17 | 187 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 953 | 953 | 46022 | Permitted Site 1 | Tree(s) :: 17 | 215 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 983 | 983 | 235091 | Permitted Site 1 | Tree(s) :: 17 | 100 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009129.80831 | 2096850.9527 | 37.7380688642945 | -122.410933356597 | (37.7380688642945, -122.410933356597) | |
| 993 | 993 | 235090 | Permitted Site 1 | Tree(s) :: 17 | 100 Putnam St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779715 | 6009124.9466 | 2096834.17608 | 37.7380225267172 | -122.410948981415 | (37.7380225267172, -122.410948981415) | |
| 1010 | 1010 | 45949 | Permitted Site 1 | Tree(s) :: 17 | 146 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1015 | 1015 | 48313 | Permitted Site 1 | Tree(s) :: 17 | 179 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1032 | 1032 | 164022 | Permitted Site 1 | Tree(s) :: 17 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779959 | 5998844.0 | 2107514.0 | 37.7667648389525 | -122.447263591802 | (37.7667648389525, -122.447263591802) | |
| 1038 | 1038 | 57888 | Permitted Site 1 | Tree(s) :: 17 | 2382 Fost St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1977 12:00:00 AM | Permit Number 16841 | ||||||||
| 1039 | 1039 | 186954 | DPW Maintained 3 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.734615522028896 | -122.493572437422 | (37.7346155220289, -122.493572437422) | |||
| 1067 | 1067 | 48140 | Permitted Site 1 | Tree(s) :: 17 | 250 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1086 | 1086 | 48227 | Permitted Site 1 | Tree(s) :: 17 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 1113 | 1113 | 45845 | Permitted Site 1 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 1210 | 1210 | 44727 | Permitted Site 1 | Tree(s) :: 17 | 1234 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779706 | 5990135.3835 | 2102474.7725 | 37.752427007324 | -122.47701665532301 | (37.752427007324, -122.477016655323) | |
| 1215 | 1215 | 218931 | Permitted Site 1 | Tree(s) :: 17 | 1353 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779656 | 5994855.14791 | 2106335.8141799998 | 37.7633011159875 | -122.460974863827 | (37.7633011159875, -122.460974863827) | |
| 1225 | 1225 | 44628 | Permitted Site 1 | Tree(s) :: 17 | 156 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 1232 | 1232 | 182646 | Permitted Site 1 | Tree(s) :: 17 | 1234 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779706 | 5990115.3264 | 2102475.6639 | 37.7524282912752 | -122.47708608048 | (37.7524282912752, -122.47708608048) | |
| 1239 | 1239 | 187690 | Permitted Site 1 | Tree(s) :: 17 | 876 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779712 | 6008536.0 | 2103448.0 | 37.7561495727301 | -122.413452882223 | (37.7561495727301, -122.413452882223) | |
| 1251 | 1251 | 225915 | Permitted Site 1 | Tree(s) :: 17 | 1115 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779648 | 6010030.36922 | 2102582.89023 | 37.7538579673932 | -122.408223810779 | (37.7538579673932, -122.408223810779) | |
| 1305 | 1305 | 251497 | Undocumented 2 | Tree(s) :: 17 | 329x Warren Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5994610.0 | 2103362.0 | 37.7551216790189 | -122.461607123764 | (37.7551216790189, -122.461607123764) | ||||
| 1321 | 1321 | 131728 | Undocumented 2 | Tree(s) :: 17 | 2951 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779933 | 6003422.05081 | 2118487.47605 | 37.7971557823578 | -122.432212651716 | (37.7971557823578, -122.432212651716) | |
| 1323 | 1323 | 41265 | Permitted Site 1 | Tree(s) :: 17 | 2929 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779089 | 6002901.9749300005 | 2118724.9020700003 | 37.7977781914725 | -122.434029221987 | (37.7977781914725, -122.434029221987) | |
| 1327 | 1327 | 132224 | Undocumented 2 | Tree(s) :: 17 | 3720 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779917 | 5997037.00688 | 2115048.93067 | 37.7873503715741 | -122.454057896478 | (37.7873503715741, -122.454057896478) | |
| 1334 | 1334 | 250499 | Undocumented 2 | Tree(s) :: 17 | 540 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779924 | 5986884.24135 | 2115388.89729 | 37.7876964378791 | -122.489208879795 | (37.7876964378791, -122.489208879795) | |
| 1342 | 1342 | 187633 | Undocumented 2 | Tree(s) :: 17 | 148 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |
| 1357 | 1357 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 1360 | 1360 | 125405 | Undocumented 2 | Tree(s) :: 17 | 2500X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779167 | 6001716.65019 | 2117116.43684 | 37.7932944253528 | -122.438015491236 | (37.7932944253528, -122.438015491236) |
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");