Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 175992 | 175992 | 220408 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1340 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009370.35107 | 2108002.56697 | 37.7687021860891 | -122.41088906857901 | (37.7687021860891, -122.410889068579) | |||
| 147976 | 147976 | 203424 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994267.45762 | 2096626.89262 | 37.7366090478713 | -122.462303269505 | (37.7366090478713, -122.462303269505) | |||
| 155871 | 155871 | 203426 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994229.44749 | 2096660.50029 | 37.7366991374492 | -122.462437122787 | (37.7366991374492, -122.462437122787) | |||
| 184899 | 184899 | 203425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 135 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994247.20035 | 2096642.9024 | 37.7366518402943 | -122.46237446791099 | (37.7366518402943, -122.462374467911) | |||
| 138380 | 138380 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | ||
| 74041 | 74041 | 82635 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1363 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52502 | 6016495.7737 | 2093658.9613 | 37.7297145851124 | -122.385242953388 | (37.7297145851124, -122.385242953388) | |
| 23350 | 23350 | 14857 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 3 | 3x3 | 6002635.4903 | 2111607.9304 | 37.7782216761893 | -122.43444221569099 | (37.7782216761893, -122.434442215691) | ||
| 113872 | 113872 | 14858 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3x3 | 6002643.52073 | 2111588.23646 | 37.778168057391206 | -122.434413027102 | (37.7781680573912, -122.434413027102) | ||
| 131057 | 131057 | 53151 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.38631399173599 | (37.7293905172533, -122.386313991736) | ||
| 145230 | 145230 | 53153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.729432620466596 | -122.386379154297 | (37.7294326204666, -122.386379154297) | ||
| 25016 | 25016 | 220501 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 14 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.49952 | 2108178.20652 | 37.768832473561794 | -122.432491682542 | (37.7688324735618, -122.432491682542) | |||
| 55726 | 55726 | 138253 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001241.1774 | 2113349.5021 | 37.7829243439965 | -122.43939051347701 | (37.7829243439965, -122.439390513477) | |||
| 62661 | 62661 | 138250 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001232.3784 | 2113393.497 | 37.7830446420036 | -122.43942410896601 | (37.7830446420036, -122.439424108966) | |||
| 70980 | 70980 | 138254 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001237.1163 | 2113367.4385 | 37.7829733616541 | -122.43940584928998 | (37.7829733616541, -122.43940584929) | |||
| 136539 | 136539 | 138255 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001249.9763 | 2113252.3751 | 37.7826581587929 | -122.439353108733 | (37.7826581587929, -122.439353108733) | |||
| 137409 | 137409 | 138251 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001249.9763 | 2113269.973 | 37.782706478132894 | -122.43935437054701 | (37.7827064781329, -122.439354370547) | |||
| 162225 | 162225 | 138252 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001247.9458 | 2113288.2478 | 37.7827565405151 | -122.439362705553 | (37.7827565405151, -122.439362705553) | |||
| 33159 | 33159 | 220430 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009429.13636 | 2107984.68576 | 37.7686563845084 | -122.410684471035 | (37.7686563845084, -122.410684471035) | |||
| 162816 | 162816 | 220428 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009431.86283 | 2107936.52181 | 37.7685242902996 | -122.410671638589 | (37.7685242902996, -122.410671638589) | |||
| 175529 | 175529 | 220429 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009431.37889 | 2107954.66245 | 37.7685740731712 | -122.41067459375499 | (37.7685740731712, -122.410674593755) | |||
| 77682 | 77682 | 87446 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1419X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6002388.02378 | 2093708.6990200002 | 37.729060607112395 | -122.434018479663 | (37.7290606071124, -122.434018479663) | ||
| 165085 | 165085 | 189090 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1433 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016367.14346 | 2097329.17086 | 37.7397851277689 | -122.385943380483 | (37.7397851277689, -122.385943380483) | |||
| 167597 | 167597 | 189091 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1433 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6016333.586630001 | 2097354.23847 | 37.739852101202004 | -122.38606115391 | (37.739852101202, -122.38606115391) | |||
| 35576 | 35576 | 175135 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 144 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000350.62933 | 2092307.6786599997 | 37.7250978911274 | -122.440961425642 | (37.7250978911274, -122.440961425642) | |||
| 145286 | 145286 | 22539 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1441X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2006 12:00:00 AM | 3 | 3X6 | 6002335.8535400005 | 2093628.68187 | 37.728837937275 | -122.43419311802099 | (37.728837937275, -122.434193118021) | ||
| 61423 | 61423 | 189092 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1442 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016181.26551 | 2097468.2132900003 | 37.7401566215255 | -122.386595766675 | (37.7401566215255, -122.386595766675) | |||
| 30101 | 30101 | 189093 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016095.6448 | 2097530.53643 | 37.74032300780279 | -122.38689615645399 | (37.7403230078028, -122.386896156454) | |||
| 45699 | 45699 | 189101 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015952.01721 | 2097639.0008900003 | 37.7406128754775 | -122.387400332559 | (37.7406128754775, -122.387400332559) | |||
| 54872 | 54872 | 189096 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016030.46802 | 2097581.7763799997 | 37.74046009325421 | -122.38712508694599 | (37.7404600932542, -122.387125086946) | |||
| 136065 | 136065 | 189095 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016045.1574 | 2097570.04683 | 37.740428699728795 | -122.387073478453 | (37.7404286997288, -122.387073478453) | |||
| 147347 | 147347 | 189098 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016001.03551 | 2097602.56889 | 37.7405155553478 | -122.387228303953 | (37.7405155553478, -122.387228303953) | |||
| 150977 | 150977 | 189099 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6015984.41779 | 2097613.57521 | 37.740544856170295 | -122.387286529648 | (37.7405448561703, -122.387286529648) | |||
| 154121 | 154121 | 189097 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6016014.59263 | 2097591.62431 | 37.7404862545337 | -122.387180665066 | (37.7404862545337, -122.387180665066) | |||
| 162619 | 162619 | 189094 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016058.30905 | 2097557.96705 | 37.7403962593718 | -122.387027162495 | (37.7403962593718, -122.387027162495) | |||
| 182191 | 182191 | 189100 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6015967.06592 | 2097626.12065 | 37.7405783424142 | -122.38734740115801 | (37.7405783424142, -122.387347401158) | |||
| 187187 | 187187 | 175134 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1447 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002380.17476 | 2093694.6098 | 37.72902147586029 | -122.434044607568 | (37.7290214758603, -122.434044607568) | |||
| 50072 | 50072 | 187910 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 145 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013716.26626 | 2115794.0259700003 | 37.7903384868766 | -122.396402968917 | (37.7903384868766, -122.396402968917) | |||
| 151901 | 151901 | 187909 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 145 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013732.28694 | 2115779.57523 | 37.7902997000163 | -122.39634652479602 | (37.7902997000163, -122.396346524796) | |||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 130360 | 130360 | 203420 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993455.07316 | 2097218.01136 | 37.7381853004145 | -122.465154930655 | (37.7381853004145, -122.465154930655) | |||
| 79340 | 79340 | 8240 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 85434 | 85434 | 8222 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 86646 | 86646 | 8246 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 87619 | 87619 | 8233 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2008 12:00:00 AM | 4 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 90665 | 90665 | 8236 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 94543 | 94543 | 8241 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 100234 | 100234 | 8245 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 101619 | 101619 | 8243 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 104454 | 104454 | 8231 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 2 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 105020 | 105020 | 8224 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 113610 | 113610 | 8237 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 115022 | 115022 | 8239 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 116842 | 116842 | 8244 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 140469 | 140469 | 8242 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1500X Galvez Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 76376 | 76376 | 220427 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1501 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009439.69021 | 2107723.53455 | 37.76793991532671 | -122.410629521551 | (37.7679399153267, -122.410629521551) | |||
| 173970 | 173970 | 220426 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1501 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009442.98316 | 2107699.97849 | 37.767875420442294 | -122.410616467889 | (37.7678754204423, -122.410616467889) | |||
| 46703 | 46703 | 220409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1504 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009386.52953 | 2107743.37871 | 37.7679914221935 | -122.410814800755 | (37.7679914221935, -122.410814800755) | |||
| 62793 | 62793 | 220411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1504 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009388.71104 | 2107693.51126 | 37.7678546200096 | -122.410803732829 | (37.7678546200096, -122.410803732829) | |||
| 184227 | 184227 | 220410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1504 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009388.45377 | 2107723.64208 | 37.7679373378588 | -122.410806750933 | (37.7679373378588, -122.410806750933) | |||
| 123779 | 123779 | 8251 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1515 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2014 12:00:00 AM | 3 | 3x3 | 6016234.0 | 2097322.0 | 37.7397580688138 | -122.38640323868799 | (37.7397580688138, -122.386403238688) | ||
| 129060 | 129060 | 8249 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1515 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016234.0 | 2097322.0 | 37.7397580688138 | -122.38640323868799 | (37.7397580688138, -122.386403238688) | ||
| 32741 | 32741 | 220423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009450.02537 | 2107605.87811 | 37.7676174373262 | -122.41058546376699 | (37.7676174373262, -122.410585463767) | |||
| 169424 | 169424 | 220424 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009448.223730001 | 2107633.16245 | 37.7676922528232 | -122.41059362239099 | (37.7676922528232, -122.410593622391) | |||
| 188605 | 188605 | 220425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009445.91202 | 2107658.57784 | 37.767761908016205 | -122.41060341331399 | (37.7677619080162, -122.410603413314) | |||
| 93822 | 93822 | 8255 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1525 GALVEZ AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 07:01:00 AM | 3 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 40227 | 40227 | 203406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994466.0383 | 2096440.3744299999 | 37.736108347605295 | -122.461603176966 | (37.7361083476053, -122.461603176966) | |||
| 71761 | 71761 | 203405 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.736187599465204 | -122.46172343251101 | (37.7361875994652, -122.461723432511) | |||
| 159278 | 159278 | 203404 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994396.0657 | 2096501.5652400001 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | |||
| 167748 | 167748 | 203403 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779896995 | -122.461902813967 | (37.736316779897, -122.461902813967) | |||
| 14738 | 14738 | 8260 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015944.99866 | 2097559.42208 | 37.74039397959 | -122.38741905015301 | (37.74039397959, -122.387419050153) | ||
| 15125 | 15125 | 8266 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 3 | 3x3 | 6016120.90063 | 2097426.65215 | 37.740039161084496 | -122.38680158822599 | (37.7400391610845, -122.386801588226) | ||
| 15549 | 15549 | 8265 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 4 | 3x3 | 6016061.13265 | 2097468.88208 | 37.7401518065476 | -122.387011187809 | (37.7401518065476, -122.387011187809) | ||
| 15672 | 15672 | 8261 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015960.32543 | 2097546.41144 | 37.7403591038818 | -122.387365148376 | (37.7403591038818, -122.387365148376) | ||
| 15760 | 15760 | 8264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6016042.026869999 | 2097486.66692 | 37.74019958213879 | -122.38707848858401 | (37.7401995821388, -122.387078488584) | ||
| 14677 | 14677 | 52149 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1566 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48340 | 6015439.23849 | 2096619.2496 | 37.737784433906995 | -122.389102155646 | (37.737784433907, -122.389102155646) |
| 27763 | 27763 | 187876 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015130.16483 | 2100787.65085 | 37.749212862006296 | -122.39046195666701 | (37.7492128620063, -122.390461956667) | |||
| 33887 | 33887 | 187873 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015126.80958 | 2100859.52415 | 37.7494100248665 | -122.390478580644 | (37.7494100248665, -122.390478580644) | |||
| 42234 | 42234 | 187869 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6015103.96021 | 2100930.78351 | 37.749604420516896 | -122.390562573713 | (37.7496044205169, -122.390562573713) | |||
| 44777 | 44777 | 187875 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015128.62493 | 2100811.61735 | 37.7492785835592 | -122.390468956103 | (37.7492785835592, -122.390468956103) | |||
| 46106 | 46106 | 187868 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6015107.19877 | 2100940.7961 | 37.749632092648795 | -122.390552074121 | (37.7496320926488, -122.390552074121) | |||
| 55799 | 55799 | 187878 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 14 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015135.58598 | 2100692.8078900003 | 37.7489527438721 | -122.39043658410401 | (37.7489527438721, -122.390436584104) | |||
| 59265 | 59265 | 187867 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015121.61936 | 2100940.75662 | 37.74963278423721 | -122.390502204035 | (37.7496327842372, -122.390502204035) | |||
| 65808 | 65808 | 187874 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015128.5311900005 | 2100832.02716 | 37.749334619411705 | -122.390470706171 | (37.7493346194117, -122.390470706171) | |||
| 71615 | 71615 | 187880 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 16 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015140.70101 | 2100612.12131 | 37.7487314791912 | -122.39041325927099 | (37.7487314791912, -122.390413259271) | |||
| 73657 | 73657 | 187884 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 21 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015147.0673400005 | 2100472.1184400003 | 37.7483474138047 | -122.390381463732 | (37.7483474138047, -122.390381463732) | |||
| 73751 | 73751 | 187877 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015133.83892 | 2100719.04605 | 37.749024691439296 | -122.39044445856399 | (37.7490246914393, -122.390444458564) | |||
| 73989 | 73989 | 187879 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 15 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015136.98664 | 2100642.09831 | 37.74881358370121 | -122.390428197897 | (37.7488135837012, -122.390428197897) | |||
| 147150 | 147150 | 187882 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 18 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015144.03762 | 2100560.1109700003 | 37.74858885479 | -122.390398087715 | (37.74858885479, -122.390398087715) | |||
| 148176 | 148176 | 187885 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 23 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015152.389769999 | 2100397.43257 | 37.748142637288 | -122.390357841268 | (37.748142637288, -122.390357841268) | |||
| 156616 | 156616 | 187883 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 20 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015144.844880001 | 2100499.87807 | 37.748423512649495 | -122.390391088302 | (37.7484235126495, -122.390391088302) | |||
| 159444 | 159444 | 187870 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015123.316980001 | 2100924.59748 | 37.74958850880971 | -122.390495204594 | (37.7495885088097, -122.390495204594) | |||
| 171631 | 171631 | 187872 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015125.026930001 | 2100883.99929 | 37.7494771295685 | -122.390486455093 | (37.7494771295685, -122.390486455093) | |||
| 174445 | 174445 | 187881 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 17 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015141.96127 | 2100582.57644 | 37.748650425082005 | -122.39040683722601 | (37.748650425082, -122.390406837226) | |||
| 178281 | 178281 | 187871 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015124.4326599995 | 2100904.6710900003 | 37.7495338570216 | -122.39048995434601 | (37.7495338570216, -122.390489954346) | |||
| 183183 | 183183 | 187866 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015120.62012 | 2100986.30773 | 37.7497578025782 | -122.390508841934 | (37.7497578025782, -122.390508841934) | |||
| 26724 | 26724 | 220414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009485.691930001 | 2106956.65454 | 37.76583681834921 | -122.410416250032 | (37.7658368183492, -122.410416250032) | |||
| 41500 | 41500 | 220419 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009469.46402 | 2107213.1866900004 | 37.76654028692471 | -122.41049049535299 | (37.7665402869247, -122.410490495353) | |||
| 56914 | 56914 | 220415 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009485.58878 | 2106996.6595099997 | 37.7659466570249 | -122.410419431833 | (37.7659466570249, -122.410419431833) | |||
| 77000 | 77000 | 220420 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009463.61799 | 2107301.1800599997 | 37.766781568731 | -122.410516930005 | (37.766781568731, -122.410516930005) | |||
| 136152 | 136152 | 220418 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009481.19591 | 2107096.90885 | 37.7662216724125 | -122.410441705317 | (37.7662216724125, -122.410441705317) |
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");