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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32935 | 32935 | 196267 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013259.78096 | 2090144.7382099999 | 37.719885690359604 | -122.396184017281 | (37.7198856903596, -122.396184017281) | ||||
| 75207 | 75207 | 212634 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 343 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992192.8402 | 2090144.9525 | 37.7186915678454 | -122.46900446519301 | (37.7186915678454, -122.469004465193) | |||
| 132021 | 132021 | 196266 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013242.639359999 | 2090155.46784 | 37.71991419797 | -122.39624402185 | (37.71991419797, -122.39624402185) | ||||
| 159455 | 159455 | 82979 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1175 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52488 | 6014632.4876 | 2090162.3488 | 37.72001033006671 | -122.391440240364 | (37.7200103300667, -122.391440240364) | |
| 174870 | 174870 | 196265 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013225.87785 | 2090169.90622 | 37.7199529101853 | -122.39630297241999 | (37.7199529101853, -122.39630297242) | ||||
| 135040 | 135040 | 196264 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1121 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013209.07716 | 2090182.42282 | 37.7199863433675 | -122.39636192385599 | (37.7199863433675, -122.396361923856) | ||||
| 133928 | 133928 | 65226 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 524 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53097 | 6002680.19388 | 2090186.8701 | 37.7194070306774 | -122.432756942099 | (37.7194070306774, -122.432756942099) | |
| 52281 | 52281 | 178707 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 607 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6001240.954969999 | 2090204.3189700001 | 37.7193732098917 | -122.437733096898 | (37.7193732098917, -122.437733096898) | |||
| 33004 | 33004 | 37858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 566St. Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 7 | Permit Number 40145 | 6001842.58186 | 2090205.4937 | 37.719410626184796 | -122.43565358376699 | (37.7194106261848, -122.435653583767) | |
| 25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
| 161789 | 161789 | 178715 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 640 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002171.56513 | 2090220.05137 | 37.719469279056604 | -122.43451745222201 | (37.7194692790566, -122.434517452222) | |||
| 64790 | 64790 | 65520 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | Permit Number 28407 | 6001857.077269999 | 2090228.1127 | 37.7194735562312 | -122.435605095905 | (37.7194735562312, -122.435605095905) | |
| 94349 | 94349 | 68004 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 359 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1994 12:00:00 AM | Permit Number 31729 | 5992445.98112632 | 2090228.1613758998 | 37.718934662037505 | -122.468135516498 | (37.7189346620375, -122.468135516498) | ||
| 46317 | 46317 | 212648 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 359 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992453.38509 | 2090231.05356 | 37.7189430308699 | -122.468110134397 | (37.7189430308699, -122.468110134397) | |||
| 74408 | 74408 | 83942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6015103.3012 | 2090231.7832 | 37.72022710350421 | -122.389817632552 | (37.7202271035042, -122.389817632552) | ||
| 62179 | 62179 | 212613 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 637 Mount Vernon Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997495.03052 | 2090233.55986 | 37.71923979005629 | -122.45068340811899 | (37.7192397900563, -122.450683408119) | |||
| 143586 | 143586 | 48582 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 366 Stratford Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | Permit Number 45896 | 5991035.37424613 | 2090234.08230991 | 37.7188693517925 | -122.473011814307 | (37.7188693517925, -122.473011814307) | ||
| 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) | |||
| 85828 | 85828 | 67978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 55 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1993 12:00:00 AM | Permit Number 31702 | 5996187.33843084 | 2090254.51404047 | 37.719222385048795 | -122.455205091912 | (37.7192223850488, -122.455205091912) | ||
| 66594 | 66594 | 178716 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 551 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6001935.516559999 | 2090267.4815 | 37.719586109087295 | -122.435336775094 | (37.7195861090873, -122.435336775094) | |||
| 99514 | 99514 | 45346 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 374 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44174 | 5992499.3558781 | 2090326.06927027 | 37.719206575715496 | -122.46795814020001 | (37.7192065757155, -122.4679581402) | ||
| 134316 | 134316 | 212646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 375 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992454.85135 | 2090337.04535 | 37.7192341432212 | -122.46811277210101 | (37.7192341432212, -122.468112772101) | |||
| 149348 | 149348 | 212647 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 374 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992487.75131 | 2090340.9136 | 37.719246664489 | -122.467999331607 | (37.719246664489, -122.467999331607) | |||
| 61088 | 61088 | 100349 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 551 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769104 | 6002969.9885599995 | 2090393.63163 | 37.7199911835241 | -122.431769984714 | (37.7199911835241, -122.431769984714) | |
| 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) | |||
| 47908 | 47908 | 178717 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004584.21016 | 2090425.13837 | 37.7201690658377 | -122.426192413645 | (37.7201690658377, -122.426192413645) | |||
| 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) | |||
| 98339 | 98339 | 35842 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 545 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | Permit Number 39069 | 6003002.28967479 | 2090438.03848066 | 37.720114945873206 | -122.43166149970301 | (37.7201149458732, -122.431661499703) | ||
| 188042 | 188042 | 178718 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004594.54509 | 2090439.6067599999 | 37.72020937703 | -122.42615771873001 | (37.72020937703, -122.42615771873) | |||
| 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) | |||
| 176751 | 176751 | 78312 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 546 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6002946.84027 | 2090441.1993599997 | 37.720120481761704 | -122.431853395021 | (37.7201204817617, -122.431853395021) | ||
| 67704 | 67704 | 178719 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004605.151740001 | 2090454.0925 | 37.7202497512089 | -122.426122085766 | (37.7202497512089, -122.426122085766) | |||
| 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) | |||
| 115956 | 115956 | 212670 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 215 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993431.79105 | 2090458.25949 | 37.719623340138504 | -122.46474468602501 | (37.7196233401385, -122.464744686025) | |||
| 78524 | 78524 | 47338 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 80317 | 80317 | 47339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 92211 | 92211 | 47340 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 109019 | 109019 | 45315 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 609 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48950 | 5992447.6424105 | 2090467.99586353 | 37.7195932851189 | -122.468147211188 | (37.7195932851189, -122.468147211188) | ||
| 123992 | 123992 | 47341 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 615 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45268 | 5992432.680183999 | 2090468.17220354 | 37.7195929051759 | -122.468198942558 | (37.7195929051759, -122.468198942558) | ||
| 79559 | 79559 | 47344 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.46838862425899 | (37.7195915118568, -122.468388624259) | ||
| 141094 | 141094 | 47343 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.46838862425899 | (37.7195915118568, -122.468388624259) | ||
| 94113 | 94113 | 48565 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 285 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | Permit Number 45880 | 5994715.98123116 | 2090468.92851584 | 37.7197265891744 | -122.460306507178 | (37.7197265891744, -122.460306507178) | |||
| 36396 | 36396 | 178720 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Prague St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004614.94019 | 2090469.4276599998 | 37.7202924114547 | -122.42608934145001 | (37.7202924114547, -122.42608934145) | |||
| 71316 | 71316 | 212671 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 615 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992392.42852 | 2090471.1623 | 37.719598790441296 | -122.468338294185 | (37.7195987904413, -122.468338294185) | |||
| 186947 | 186947 | 212672 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 609 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992414.13264 | 2090471.45088 | 37.719600836394704 | -122.468263292533 | (37.7196008363947, -122.468263292533) | |||
| 179000 | 179000 | 212675 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992291.80794 | 2090471.78917 | 37.7195946994221 | -122.468686145643 | (37.7195946994221, -122.468686145643) | |||
| 168203 | 168203 | 212669 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 131 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993624.744659999 | 2090472.09024 | 37.7196724386082 | -122.46407872367399 | (37.7196724386082, -122.464078723674) | |||
| 26547 | 26547 | 212674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 641 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992267.89136 | 2090473.0375 | 37.719596745362395 | -122.46876890666 | (37.7195967453624, -122.46876890666) | |||
| 178411 | 178411 | 71321 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 336 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6004246.979590001 | 2090473.3975400003 | 37.7202825081141 | -122.42736154309799 | (37.7202825081141, -122.427361543098) | ||
| 158396 | 158396 | 37841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1119 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 5 | Permit Number 40135 | 6004769.12053 | 2090484.0078 | 37.72034115831121 | -122.42555742754499 | (37.7203411583112, -122.425557427545) | |
| 164887 | 164887 | 37842 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1119 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 6 | Permit Number 40135 | 6004757.56597 | 2090489.6511 | 37.7203560007008 | -122.425597769339 | (37.7203560007008, -122.425597769339) | |
| 36830 | 36830 | 32000 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | Permit Number 35398 | 6004681.79036 | 2090489.9843099997 | 37.7203526336359 | -122.42585972476299 | (37.7203526336359, -122.425859724763) | |
| 124678 | 124678 | 47332 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 131 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45263 | 5993704.23092481 | 2090493.94065656 | 37.7197370153769 | -122.463805555403 | (37.7197370153769, -122.463805555403) | ||
| 176732 | 176732 | 31999 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 7 | Permit Number 35398 | 6004667.05838 | 2090499.06627 | 37.72037673816379 | -122.42591129458201 | (37.7203767381638, -122.425911294582) | |
| 157684 | 157684 | 212673 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 632 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992300.25819 | 2090517.80546 | 37.7197215370933 | -122.468660282939 | (37.7197215370933, -122.468660282939) | |||
| 78563 | 78563 | 47357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | |||
| 112566 | 112566 | 47358 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | |||
| 117379 | 117379 | 47359 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45281 | 5992189.97123037 | 2090518.77996357 | 37.7197178411259 | -122.469041573173 | (37.7197178411259, -122.469041573173) | |||
| 128660 | 128660 | 45314 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 608 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2001 12:00:00 AM | Permit Number 44151 | 5992448.25522328 | 2090519.99225245 | 37.7197360899317 | -122.468148873343 | (37.7197360899317, -122.468148873343) | ||
| 116141 | 116141 | 47342 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 636 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45269 | 5992378.43149497 | 2090520.81517255 | 37.719734316666205 | -122.46839028687799 | (37.7197343166662, -122.468390286878) | ||
| 32900 | 32900 | 78278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1129 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 6000344.02965 | 2090524.15486 | 37.720200365833996 | -122.440856356949 | (37.720200365834, -122.440856356949) | ||
| 128465 | 128465 | 47336 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 142 Garfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.719838715813104 | -122.463971702484 | (37.7198387158131, -122.463971702484) | |||
| 144083 | 144083 | 47335 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 142 Garfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45265 | 5993656.96278859 | 2090531.97182441 | 37.719838715813104 | -122.463971702484 | (37.7198387158131, -122.463971702484) | |||
| 152789 | 152789 | 212606 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 515 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995228.79596 | 2090547.89361 | 37.719972894006 | -122.45853961392599 | (37.719972894006, -122.458539613926) | |||
| 160505 | 160505 | 212638 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992196.84729 | 2090552.9971900003 | 37.7198121905699 | -122.469020294172 | (37.7198121905699, -122.469020294172) | |||
| 56482 | 56482 | 212662 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 718 Head St | 6 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993530.84896 | 2090554.84493 | 37.7198942509911 | -122.464409290177 | (37.7198942509911, -122.464409290177) | |||
| 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) | |||
| 11987 | 11987 | 50020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1208 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 4 | 2.5x4 | Permit Number 46754 | 6009698.1958800005 | 2090561.7050599998 | 37.7208317780481 | -122.408524628629 | (37.7208317780481, -122.408524628629) |
| 32448 | 32448 | 212637 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992197.26293 | 2090572.74875 | 37.719866447546394 | -122.469020294145 | (37.7198664475464, -122.469020294145) | |||
| 127835 | 127835 | 114387 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 417x ARBALLO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5988152.0 | 2090574.0 | 37.7196353223366 | -122.483003277928 | (37.7196353223366, -122.483003277928) | ||||
| 146599 | 146599 | 212604 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 530 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995172.762180001 | 2090588.2454400002 | 37.7200804700298 | -122.45873622190202 | (37.7200804700298, -122.458736221902) | |||
| 132515 | 132515 | 212605 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 530 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995145.78464 | 2090589.6378400002 | 37.7200827425981 | -122.45882957424 | (37.7200827425981, -122.45882957424) | |||
| 58888 | 58888 | 212636 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 401 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992198.0920400005 | 2090594.0117 | 37.7199248783202 | -122.46901897484301 | (37.7199248783202, -122.469018974843) | |||
| 166901 | 166901 | 212663 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 718 Head St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993531.69255 | 2090595.02777 | 37.7200046319988 | -122.464409290166 | (37.7200046319988, -122.464409290166) | |||
| 60207 | 60207 | 178722 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 490 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002144.3074900005 | 2090601.92472 | 37.720516270689394 | -122.434638963227 | (37.7205162706894, -122.434638963227) | |||
| 116971 | 116971 | 84788 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 499x Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176.0 | 2090606.0 | 37.720529259637296 | -122.43452970370501 | (37.7205292596373, -122.434529703705) | |||
| 128030 | 128030 | 84790 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 499x Lisbon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2007 12:00:00 AM | Permit No. 49321 | 6002176.0 | 2090606.0 | 37.720529259637296 | -122.43452970370501 | (37.7205292596373, -122.434529703705) | |||
| 82402 | 82402 | 114388 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 361x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 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) | |||
| 148735 | 148735 | 178743 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 700 Olmstead St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009613.92782 | 2090628.1142099998 | 37.7210094040501 | -122.408820601789 | (37.7210094040501, -122.408820601789) | |||
| 27845 | 27845 | 178723 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 490 Lisbon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002163.165469999 | 2090632.2574 | 37.7206006280059 | -122.434575945046 | (37.7206006280059, -122.434575945046) | |||
| 116335 | 116335 | 60984 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20795 | 5994770.81866401 | 2090632.92031204 | 37.7201800257747 | -122.460128829497 | (37.7201800257747, -122.460128829497) | ||
| 100868 | 100868 | 53390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 307 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20783 | 5994718.82728479 | 2090633.86714187 | 37.7201796349623 | -122.46030861360599 | (37.7201796349623, -122.460308613606) | ||
| 149484 | 149484 | 178742 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 700 Olmstead St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009641.40534 | 2090636.01143 | 37.7210326272248 | -122.408726176566 | (37.7210326272248, -122.408726176566) | |||
| 166426 | 166426 | 178741 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 700 Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009654.11399 | 2090640.0955400001 | 37.7210445531435 | -122.408682534289 | (37.7210445531435, -122.408682534289) | |||
| 100188 | 100188 | 60983 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 310 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20794 | 5994771.28000526 | 2090658.25302484 | 37.720249609888896 | -122.460129069137 | (37.7202496098889, -122.460129069137) | ||
| 47754 | 47754 | 78568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | ||
| 126118 | 126118 | 60982 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 314 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20793 | 5994771.74134651 | 2090683.58573763 | 37.72031919400229 | -122.46012930877701 | (37.7203191940023, -122.460129308777) | ||
| 140885 | 140885 | 60975 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 315 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20782 | 5994719.74996729 | 2090684.53256746 | 37.7203188031892 | -122.46030909322201 | (37.7203188031892, -122.460309093222) | ||
| 52000 | 52000 | 212591 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1014 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995061.42461 | 2090686.5438599999 | 37.7203439740723 | -122.459128189622 | (37.7203439740723, -122.459128189622) | |||
| 177871 | 177871 | 78222 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) | ||
| 146478 | 146478 | 78307 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 207 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6001954.57351 | 2090695.0819299999 | 37.720761286472204 | -122.43530147220899 | (37.7207612864722, -122.435301472209) | ||
| 184268 | 184268 | 212595 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 325 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994724.84778 | 2090734.30474 | 37.720455758920394 | -122.460295076173 | (37.7204557589204, -122.460295076173) | |||
| 89538 | 89538 | 60974 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 325 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | 8 | Permit Number 20780 | 5994720.90332042 | 2090747.86434945 | 37.7204927634685 | -122.460309692745 | (37.7204927634685, -122.460309692745) | |
| 115057 | 115057 | 45347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 435 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44175 | 5992452.7081998 | 2090752.04438922 | 37.72037350571971 | -122.468150352563 | (37.7203735057197, -122.468150352563) | ||
| 96428 | 96428 | 117621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 105246 | 105246 | 117625 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 116417 | 116417 | 117623 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
| 82545 | 82545 | 60981 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 326 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1983 12:00:00 AM | Permit Number 20791 | 5994773.12537038 | 2090759.58388194 | 37.720527946354295 | -122.460130027699 | (37.7205279463543, -122.460130027699) | ||
| 116201 | 116201 | 178711 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 500 London St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001558.807569999 | 2090766.2679299999 | 37.7209342638804 | -122.436674603871 | (37.7209342638804, -122.436674603871) |
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");