Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120993 | 120993 | 94368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 81316 | 81316 | 94369 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 899@ Fulton 27th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/21/2010 12:00:00 AM | Permit Number 53639 | 5987555.1 | 2109884.3 | 37.77262150846121 | -122.48648355682501 | (37.7726215084612, -122.486483556825) | |||
| 114681 | 114681 | 119273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 3x3 | 5993437.0 | 2093200.0 | 37.727151793263296 | -122.464925693193 | (37.7271517932633, -122.464925693193) | |||
| 50433 | 50433 | 123122 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 624 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5992573.24713 | 2111201.55414 | 37.7765295670124 | -122.46922130393601 | (37.7765295670124, -122.469221303936) | |||
| 24246 | 24246 | 123150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 530 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5992860.06337 | 2111844.7190400003 | 37.778312093174 | -122.468275933095 | (37.778312093174, -122.468275933095) | |||
| 38115 | 38115 | 123151 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 506 10th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5992855.02904 | 2111985.99608 | 37.7786997108705 | -122.46830362906 | (37.7786997108705, -122.46830362906) | |||
| 74862 | 74862 | 123152 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 506 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992856.05195 | 2111969.64084 | 37.7786548628959 | -122.46829890029899 | (37.7786548628959, -122.468298900299) | |||
| 188524 | 188524 | 123164 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 567 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5992805.53108 | 2111610.19032 | 37.7776649910865 | -122.46844751130399 | (37.7776649910865, -122.468447511304) | ||||
| 161259 | 161259 | 123188 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 583 09th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993119.2006 | 2111506.41718 | 37.7773981711119 | -122.467354883251 | (37.7773981711119, -122.467354883251) | |||
| 178841 | 178841 | 123381 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 741 03rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5995015.450230001 | 2110521.81461 | 37.7748040007041 | -122.46072380906 | (37.7748040007041, -122.46072380906) | ||||
| 175997 | 175997 | 124045 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 723 12th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5992223.98611 | 2110507.73124 | 37.77460432927921 | -122.470378946663 | (37.7746043292792, -122.470378946663) | |||
| 171239 | 171239 | 124046 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 723 12th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5992224.36446 | 2110496.07608 | 37.7745723492368 | -122.470376788909 | (37.7745723492368, -122.470376788909) | |||
| 137921 | 137921 | 124228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5996619.11206 | 2111349.85847 | 37.7771697285711 | -122.45523629563499 | (37.7771697285711, -122.455236295635) | |||
| 132194 | 132194 | 124229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5996620.976869999 | 2111333.86588 | 37.7771259241055 | -122.45522868869499 | (37.7771259241055, -122.455228688695) | |||
| 75053 | 75053 | 124628 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 739 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5996019.75868 | 2113776.29204 | 37.7837976659747 | -122.457485230667 | (37.7837976659747, -122.457485230667) | |||
| 166240 | 166240 | 124629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 749 Euclid Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5995991.233580001 | 2113774.73723 | 37.7837917583619 | -122.457583803683 | (37.7837917583619, -122.457583803683) | |||
| 183601 | 183601 | 124630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 749 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5995936.92789 | 2113773.7221 | 37.7837858514667 | -122.457771606363 | (37.7837858514667, -122.457771606363) | |||
| 46419 | 46419 | 135703 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 69 Masonic Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998890.10615 | 2113926.10029 | 37.7843734546089 | -122.447565730187 | (37.7843734546089, -122.447565730187) | |||
| 67798 | 67798 | 135704 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 69 Masonic Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998891.86362 | 2113914.5712099997 | 37.784341899203504 | -122.44755881979601 | (37.7843418992035, -122.447558819796) | |||
| 149537 | 149537 | 135705 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 71 Collins St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998103.88222 | 2114203.23453 | 37.7850894291786 | -122.450305763004 | (37.7850894291786, -122.450305763004) | ||||
| 55698 | 55698 | 135724 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999982.20185 | 2115576.5673700003 | 37.7889675594589 | -122.443906093806 | (37.7889675594589, -122.443906093806) | |||
| 167904 | 167904 | 135725 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5999979.44045 | 2115594.83954 | 37.789017572549604 | -122.443916961204 | (37.7890175725496, -122.443916961204) | |||
| 28471 | 28471 | 135727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3170 Sacramento St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5999594.80396 | 2115410.0134799997 | 37.7884881407547 | -122.44523445452299 | (37.7884881407547, -122.445234454523) | |||
| 180479 | 180479 | 135740 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1900 Lyon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5999505.99761 | 2115475.33585 | 37.7886624293634 | -122.44554640865101 | (37.7886624293634, -122.445546408651) | |||
| 153991 | 153991 | 135757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2646 Broderick St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000168.56183 | 2117716.69184 | 37.794854408249 | -122.44341510174601 | (37.794854408249, -122.443415101746) | |||
| 76763 | 76763 | 135798 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Phoenix Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 6008602.032930001 | 2117913.0115900002 | 37.795870778879 | -122.41424790421001 | (37.795870778879, -122.41424790421) | |||
| 70955 | 70955 | 135799 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Phoenix Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6008603.37941 | 2117901.29377 | 37.7958386802699 | -122.41424241565399 | (37.7958386802699, -122.414242415654) | |||
| 178508 | 178508 | 135800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 16 Phoenix Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6008612.60281 | 2117902.3687 | 37.7958421498461 | -122.414210576953 | (37.7958421498461, -122.414210576953) | |||
| 44735 | 44735 | 135801 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.795872947126206 | -122.414217164494 | (37.7958729471262, -122.414217164494) | |||
| 185177 | 185177 | 135806 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Aladdin Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6008809.714930001 | 2119549.2222700003 | 37.8003750720026 | -122.41364506887399 | (37.8003750720026, -122.413645068874) | |||
| 72395 | 72395 | 135807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1311 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6005955.98541 | 2119974.55098 | 37.8013822560451 | -122.42355037726101 | (37.8013822560451, -122.423550377261) | ||||
| 43904 | 43904 | 135809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1154 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6006309.30935 | 2120436.0273599997 | 37.8026692893277 | -122.422360524716 | (37.8026692893277, -122.422360524716) | |||
| 42317 | 42317 | 135828 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008658.00325 | 2119030.21476 | 37.798941486106294 | -122.414133314422 | (37.7989414861063, -122.414133314422) | |||
| 51638 | 51638 | 135831 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008642.5114400005 | 2119028.50949 | 37.7989359337052 | -122.41418680068199 | (37.7989359337052, -122.414186800682) | |||
| 155763 | 155763 | 135834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008624.12392 | 2119028.66096 | 37.7989353167715 | -122.414250438519 | (37.7989353167715, -122.414250438519) | |||
| 57508 | 57508 | 135835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008609.072240001 | 2119027.30535 | 37.7989307491201 | -122.41430242651899 | (37.7989307491201, -122.414302426519) | |||
| 62925 | 62925 | 135836 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Green St | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6008591.776769999 | 2119025.88036 | 37.7989258649019 | -122.41436217388001 | (37.7989258649019, -122.41436217388) | |||
| 177395 | 177395 | 135852 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 13 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008609.879 | 2119160.01046 | 37.7992951697024 | -122.414309029333 | (37.7992951697024, -122.414309029333) | ||||
| 2593 | 2593 | 155952 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 35 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/20/2017 12:00:00 AM | 3 | 5993448.18795 | 2093194.64055 | 37.7271377226027 | -122.464886627823 | (37.7271377226027, -122.464886627823) | |||
| 68434 | 68434 | 178697 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 170 Lawrence Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 5996822.297619999 | 2087264.10807 | 37.7110478340594 | -122.452794569318 | (37.7110478340594, -122.452794569318) | |||
| 70802 | 70802 | 178698 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Sala Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 1ft | 5999028.57689 | 2088233.4510700002 | 37.713835610093795 | -122.445238812629 | (37.7138356100938, -122.445238812629) | |||
| 179163 | 179163 | 178699 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Sala Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5999039.32435 | 2088222.2943799999 | 37.7138055898272 | -122.44520086393 | (37.7138055898272, -122.44520086393) | |||
| 153489 | 153489 | 178740 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1127 Bowdoin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6009628.53589 | 2090952.70997 | 37.7219014946373 | -122.408792994404 | (37.7219014946373, -122.408792994404) | |||
| 38990 | 38990 | 178757 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 475 Country Club Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5984730.24902 | 2094611.5938900001 | 37.7305217923373 | -122.49512844142099 | (37.7305217923373, -122.495128441421) | |||
| 50366 | 50366 | 178762 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 239 Cotter St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6001593.80864 | 2093905.46248 | 37.7295557693705 | -122.436778218343 | (37.7295557693705, -122.436778218343) | |||
| 68549 | 68549 | 178781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 243 Ottawa Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5998332.41388 | 2089291.4265700001 | 37.7167008060656 | -122.447721115953 | (37.7167008060656, -122.447721115953) | |||
| 51919 | 51919 | 178799 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008025.38045 | 2091906.1751599999 | 37.7244295815351 | -122.41440214334601 | (37.7244295815351, -122.414402143346) | |||
| 36378 | 36378 | 178800 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Princeton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6008027.45015 | 2091896.60863 | 37.7244034301488 | -122.41439431206699 | (37.7244034301488, -122.414394312067) | |||
| 149238 | 149238 | 178802 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 428 Amherst St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6007745.17316 | 2091797.3034299999 | 37.7241148979791 | -122.415363080637 | (37.7241148979791, -122.415363080637) | |||
| 29740 | 29740 | 178803 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 428 Amherst St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6007743.472490001 | 2091796.14538 | 37.7241116226352 | -122.415368877669 | (37.7241116226352, -122.415368877669) | |||
| 60094 | 60094 | 178818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Ina Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6004783.72135 | 2091297.0719 | 37.722574479812 | -122.42556479298099 | (37.722574479812, -122.425564792981) | ||||
| 23463 | 23463 | 185056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 82 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5988580.6885 | 2096305.5585 | 37.735397653561 | -122.481941107831 | (37.735397653561, -122.481941107831) | |||
| 184237 | 184237 | 185131 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2665 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5985814.4377 | 2097199.1641 | 37.737689989794895 | -122.49157069147199 | (37.7376899897949, -122.491570691472) | |||
| 166560 | 166560 | 196112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1701 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6012182.78746 | 2105583.5511 | 37.762217410431205 | -122.40099102131398 | (37.7622174104312, -122.400991021314) | ||||
| 182302 | 182302 | 196117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 790 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012097.66316 | 2104740.4210900003 | 37.7598976137124 | -122.401226185965 | (37.7598976137124, -122.401226185965) | ||||
| 167126 | 167126 | 196128 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2098 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6011883.81228 | 2104698.03976 | 37.7597693110244 | -122.401962817046 | (37.7597693110244, -122.401962817046) | |||
| 26282 | 26282 | 196130 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 582 Rhode Island St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6011755.76075 | 2105663.76681 | 37.7624138349597 | -122.402473594197 | (37.7624138349597, -122.402473594197) | ||||
| 174884 | 174884 | 196137 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6013055.93777 | 2103788.3405299997 | 37.757336823850295 | -122.397845173025 | (37.7573368238503, -122.397845173025) | ||||
| 32300 | 32300 | 196138 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 801 Arkansas St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6013054.7193 | 2103811.53724 | 37.757400449098604 | -122.39785101412 | (37.7574004490986, -122.39785101412) | ||||
| 170977 | 170977 | 196272 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018667.18531 | 2093699.9533900002 | 37.7299470266284 | -122.377738907749 | (37.7299470266284, -122.377738907749) | |||
| 132578 | 132578 | 196273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6018678.54669 | 2093695.28939 | 37.729934846200294 | -122.377699306103 | (37.7299348462003, -122.377699306103) | |||
| 153801 | 153801 | 196274 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018690.35337 | 2093691.67274 | 37.7299255661145 | -122.377658237655 | (37.7299255661145, -122.377658237655) | |||
| 152139 | 152139 | 196275 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 89 Kiska Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6018699.22943 | 2093690.01585 | 37.729921505667 | -122.37762743678101 | (37.729921505667, -122.377627436781) | |||
| 161733 | 161733 | 196296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 383 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012973.423830001 | 2105290.2988400003 | 37.7614562764103 | -122.398235915848 | (37.7614562764103, -122.398235915848) | |||
| 154458 | 154458 | 196297 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1501 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6013586.24242 | 2103799.53475 | 37.7573970793204 | -122.396011941921 | (37.7573970793204, -122.396011941921) | ||||
| 62690 | 62690 | 201971 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013754.580159999 | 2092201.85922 | 37.7255616517262 | -122.394617632995 | (37.7255616517262, -122.394617632995) | ||||
| 153153 | 153153 | 201973 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013730.31809 | 2092219.82075 | 37.725609621562796 | -122.39470276281999 | (37.7256096215628, -122.39470276282) | ||||
| 71405 | 71405 | 201975 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6013711.44714 | 2092234.27571 | 37.7256482627537 | -122.39476901048401 | (37.7256482627537, -122.394769010484) | ||||
| 51057 | 51057 | 201978 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1651 Carroll Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013680.98178 | 2092258.06513 | 37.7257118897673 | -122.39487599293301 | (37.7257118897673, -122.394875992933) | ||||
| 186399 | 186399 | 202168 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Kalmanovitz St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6013157.76295 | 2093232.82928 | 37.728359287049706 | -122.396753038148 | (37.7283592870497, -122.396753038148) | |||
| 32155 | 32155 | 202169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Kalmanovitz St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 1ft | 6013155.46174 | 2093221.3423900001 | 37.7283276183124 | -122.396760188629 | (37.7283276183124, -122.396760188629) | |||
| 132832 | 132832 | 212341 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 136 Lawton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5993819.430480001 | 2104642.8186 | 37.7585929384414 | -122.46443411237101 | (37.7585929384414, -122.464434112371) | |||
| 33220 | 33220 | 212458 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 768 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5994909.71426 | 2093167.9276299998 | 37.7271485351522 | -122.45983224818501 | (37.7271485351522, -122.459832248185) | |||
| 180998 | 180998 | 212581 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 698 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5996847.55389 | 2094438.3899599998 | 37.7307481750846 | -122.45322487153601 | (37.7307481750846, -122.453224871536) | |||
| 148881 | 148881 | 212582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 698 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5996839.75246 | 2094438.5528099998 | 37.7307481750864 | -122.453251853909 | (37.7307481750864, -122.453251853909) | |||
| 36555 | 36555 | 212583 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 769 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5997015.86824 | 2094973.70242 | 37.7322276605726 | -122.452681605484 | (37.7322276605726, -122.452681605484) | |||
| 44903 | 44903 | 212585 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 154 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999046.49545 | 2093810.2028700002 | 37.729149108537506 | -122.445577658299 | (37.7291491085375, -122.445577658299) | ||||
| 187487 | 187487 | 212586 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 201 Judson Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5998722.40615 | 2093468.5206900002 | 37.728192421422 | -122.44667348310301 | (37.728192421422, -122.446673483103) | |||
| 30957 | 30957 | 212587 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 147 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5998729.2739699995 | 2093442.0374900002 | 37.7281200970646 | -122.446647836227 | (37.7281200970646, -122.446647836227) | |||
| 183049 | 183049 | 212618 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 158 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991450.23786 | 2090240.56685 | 37.7189111669923 | -122.471578280835 | (37.7189111669923, -122.471578280835) | |||
| 146415 | 146415 | 212619 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 123 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991404.11082 | 2090016.7036 | 37.718293824675996 | -122.47172141691799 | (37.718293824676, -122.471721416918) | |||
| 64919 | 64919 | 212620 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 119 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5991404.09674 | 2089992.6496299999 | 37.7182277775561 | -122.47171971359501 | (37.7182277775561, -122.471719713595) | |||
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 116437 | 116437 | 212623 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 222 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5991708.59487 | 2090008.3257099998 | 37.71828843323971 | -122.470668344073 | (37.7182884332397, -122.470668344073) | |||
| 73618 | 73618 | 212624 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 226 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991707.41959 | 2090046.15057 | 37.7183922230931 | -122.47067516002599 | (37.7183922230931, -122.470675160026) | |||
| 61941 | 61941 | 212626 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 315 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5991670.9458800005 | 2090561.38472 | 37.719804820616005 | -122.470838744014 | (37.719804820616, -122.470838744014) | |||
| 155017 | 155017 | 212627 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 377 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5991677.283869999 | 2091026.128 | 37.721081258087395 | -122.470850671749 | (37.7210812580874, -122.470850671749) | |||
| 61432 | 61432 | 212628 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5991678.72226 | 2091078.63283 | 37.7212255066273 | -122.47084952238998 | (37.7212255066273, -122.47084952239) | |||
| 46660 | 46660 | 212631 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 162 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5992215.360309999 | 2088948.17723 | 37.7154068147365 | -122.46883958169201 | (37.7154068147365, -122.468839581692) | |||
| 178332 | 178332 | 212633 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 338 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992228.533869999 | 2090118.36082 | 37.7186206158303 | -122.468879153643 | (37.7186206158303, -122.468879153643) | |||
| 152826 | 152826 | 212642 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 425 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5992451.79258 | 2090627.05443 | 37.7200302608812 | -122.468144430039 | (37.7200302608812, -122.468144430039) | |||
| 172442 | 172442 | 212643 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992448.21335 | 2090456.8872900002 | 37.7195628166546 | -122.468144430025 | (37.7195628166546, -122.468144430025) | |||
| 30249 | 30249 | 212644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992447.09906 | 2090440.19057 | 37.7195169071729 | -122.46814706775 | (37.7195169071729, -122.46814706775) | |||
| 167551 | 167551 | 212645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 385 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992447.955709999 | 2090426.4922099998 | 37.7194793442858 | -122.46814311071199 | (37.7194793442858, -122.468143110712) | |||
| 137960 | 137960 | 212652 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 313 Vernon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5992443.32484 | 2089879.75405 | 37.717977866774 | -122.468119367735 | (37.717977866774, -122.468119367735) | |||
| 31098 | 31098 | 212655 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 494 Victoria St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993275.23376 | 2090421.34929 | 37.7195129663325 | -122.46528316408998 | (37.7195129663325, -122.46528316409) | |||
| 147741 | 147741 | 212657 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 343 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993218.2804 | 2089467.7966 | 37.716891456045396 | -122.46541079769301 | (37.7168914560454, -122.465410797693) | ||||
| 164489 | 164489 | 212658 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993218.6994199995 | 2089441.88827 | 37.716820342171296 | -122.46540746837799 | (37.7168203421713, -122.465407468378) | ||||
| 28486 | 28486 | 212659 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 335 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5993217.881709999 | 2089418.2439299999 | 37.7167553733424 | -122.465408578168 | (37.7167553733424, -122.465408578168) | ||||
| 41211 | 41211 | 212664 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 752 Head St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5993542.32801 | 2090823.31232 | 37.7206320593021 | -122.464389093183 | (37.7206320593021, -122.464389093183) |
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");