Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | ||
| 39146 | 39146 | 199868 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016299.0692 | 2093761.868 | 37.729986262675396 | -122.385930158914 | (37.7299862626754, -122.385930158914) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) |
| 130108 | 130108 | 199670 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1907 Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015203.4065 | 2093411.0787 | 37.7289623696233 | -122.389693539093 | (37.7289623696233, -122.389693539093) | |||
| 30483 | 30483 | 187888 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015216.20725 | 2100273.8122 | 37.747806741405 | -122.390128525805 | (37.747806741405, -122.390128525805) | |||
| 149677 | 149677 | 187890 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015208.72001 | 2100389.3363099997 | 37.7481235311712 | -122.39016248603001 | (37.7481235311712, -122.39016248603) | |||
| 133115 | 133115 | 187891 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015208.193580001 | 2100413.69272 | 37.7481903795776 | -122.390166007757 | (37.7481903795776, -122.390166007757) | |||
| 124105 | 124105 | 187892 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015206.13934 | 2100438.08 | 37.74825722800529 | -122.39017481481501 | (37.7482572280053, -122.390174814815) | |||
| 157299 | 157299 | 187889 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015203.04299 | 2100298.1861 | 37.747872936885706 | -122.390175750107 | (37.7478729368857, -122.390175750107) | |||
| 149627 | 149627 | 187893 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015205.088280001 | 2100461.68616 | 37.7483219872815 | -122.390180098326 | (37.7483219872815, -122.390180098326) | |||
| 60719 | 60719 | 187894 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015203.0238 | 2100485.5663 | 37.748387442638396 | -122.390188905397 | (37.7483874426384, -122.390188905397) | |||
| 67284 | 67284 | 187895 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015201.97274 | 2100509.17213 | 37.7484522010065 | -122.39019418890601 | (37.7484522010065, -122.390194188906) | |||
| 59063 | 59063 | 187896 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015200.4277800005 | 2100533.54912 | 37.748519049422704 | -122.390201234205 | (37.7485190494227, -122.390201234205) | |||
| 129642 | 129642 | 187897 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 6ft | 6015199.38185 | 2100557.40869 | 37.7485845047902 | -122.39020651771999 | (37.7485845047902, -122.39020651772) | |||
| 14125 | 14125 | 27452 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015192.769090001 | 2100696.5145099997 | 37.7489660934285 | -122.390239101956 | (37.7489660934285, -122.390239101956) | |||
| 14698 | 14698 | 27453 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015188.65813 | 2100719.92865 | 37.7490301557222 | -122.390254953405 | (37.7490301557222, -122.390254953405) | |||
| 15322 | 15322 | 27454 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015187.13368 | 2100745.31925 | 37.7490997884263 | -122.390261998696 | (37.7490997884263, -122.390261998696) | |||
| 15617 | 15617 | 27455 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015186.58653 | 2100768.66108 | 37.7491638498456 | -122.390265521335 | (37.7491638498456, -122.390265521335) | |||
| 132208 | 132208 | 187887 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015168.3741 | 2100272.0996 | 37.7477993858291 | -122.39029381222299 | (37.7477993858291, -122.390293812223) | |||
| 186986 | 186986 | 187899 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6015181.09261 | 2100903.60273 | 37.7495340665546 | -122.39029394621201 | (37.7495340665546, -122.390293946212) | |||
| 159899 | 159899 | 187898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 7 | : 4 | Tree 1 | Private 1 | 7 | Width 6ft | 6015180.25331 | 2100882.371 | 37.749475722127 | -122.390295365361 | (37.749475722127, -122.390295365361) | |||
| 66367 | 66367 | 187886 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1798 Indiana St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015167.00373 | 2100296.44162 | 37.7478661479108 | -122.39030025137698 | (37.7478661479108, -122.390300251377) | |||
| 14664 | 14664 | 27459 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6X6 | 6015175.2959199995 | 2101002.60795 | 37.749805592554104 | -122.39032090789 | (37.7498055925541, -122.39032090789) | |||
| 178826 | 178826 | 187900 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 6ft | 6015174.133909999 | 2101026.33165 | 37.749870668392504 | -122.390326583523 | (37.7498706683925, -122.390326583523) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 39657 | 39657 | 187951 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015307.966030001 | 2115072.7119299998 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | ||||
| 58733 | 58733 | 187950 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015285.41791 | 2115092.62187 | 37.788499786972295 | -122.390924726221 | (37.7884997869723, -122.390924726221) | ||||
| 30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
| 84171 | 84171 | 107155 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 88825 | 88825 | 107152 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | In front of Gap Inc. | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | |||
| 99988 | 99988 | 107153 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 107872 | 107872 | 107156 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 112179 | 112179 | 107154 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 37847 | 37847 | 187948 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6015252.9594 | 2115128.97629 | 37.788597806797796 | -122.391039570534 | (37.7885978067978, -122.391039570534) | ||||
| 183883 | 183883 | 187930 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6015248.50297 | 2115743.86859 | 37.790285912521 | -122.391097985077 | (37.790285912521, -122.391097985077) | |||
| 25823 | 25823 | 187931 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | |||
| 163804 | 163804 | 187932 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015226.56568 | 2115767.0795400003 | 37.790348427077106 | -122.39117551026101 | (37.7903484270771, -122.391175510261) | |||
| 176021 | 176021 | 187933 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015208.90661 | 2115787.01653 | 37.7904021894671 | -122.391238004144 | (37.7904021894671, -122.391238004144) | |||
| 176685 | 176685 | 187934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | |||
| 73430 | 73430 | 81717 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 5 | 6014951.75745 | 2104011.46368 | 37.758054868645395 | -122.391304224825 | (37.7580548686454, -122.391304224825) | ||
| 61836 | 61836 | 81719 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014948.610719999 | 2104053.54358 | 37.7581702363807 | -122.391318049186 | (37.7581702363807, -122.391318049186) | ||
| 187818 | 187818 | 81723 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014945.424980001 | 2104137.64024 | 37.7584009709475 | -122.39133494566201 | (37.7584009709475, -122.391334945662) | ||
| 179748 | 179748 | 81721 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 3 | 6014944.54926 | 2104094.31483 | 37.7582819600733 | -122.39133494567301 | (37.7582819600733, -122.391334945673) | ||
| 70381 | 70381 | 187935 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6015174.64356 | 2115822.5435099998 | 37.790497836842796 | -122.391359037593 | (37.7904978368428, -122.391359037593) | |||
| 158483 | 158483 | 187947 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015161.72984 | 2115222.99296 | 37.7888508922136 | -122.391361788631 | (37.7888508922136, -122.391361788631) |
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");