Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168893 | 168893 | 41226 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 155 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 8 | Permit Number 41932 | 6001878.60529 | 2121714.18401 | 37.805927839759896 | -122.437784566908 | (37.8059278397599, -122.437784566908) | |
| 61737 | 61737 | 106161 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 827 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770049 | 6006757.57528 | 2121490.3236599998 | 37.8055893943007 | -122.42088419136499 | (37.8055893943007, -122.420884191365) | |
| 176628 | 176628 | 41234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3743 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 5 | Permit Number 41939 | 6002518.8447 | 2121486.57255 | 37.805339263172606 | -122.435552627664 | (37.8053392631726, -122.435552627664) | |
| 40934 | 40934 | 142736 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 15 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009218.8197 | 2121322.4003 | 37.805266741303 | -122.412354799662 | (37.805266741303, -122.412354799662) | |||
| 133655 | 133655 | 112372 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 15 Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009194.601 | 2121319.3086 | 37.805256893193494 | -122.412438393162 | (37.8052568931935, -122.412438393162) | |||
| 137394 | 137394 | 142655 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 VANDEWATER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009102.8791 | 2121306.4263 | 37.8052163739487 | -122.412754898161 | (37.8052163739487, -122.412754898161) | |||
| 51491 | 51491 | 118370 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 2x2 | 6009076.084 | 2121302.8193 | 37.8052049660579 | -122.41284737107901 | (37.8052049660579, -122.412847371079) | |||
| 50875 | 50875 | 118368 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6009048.7736 | 2121299.2122 | 37.8051935288948 | -122.412941627226 | (37.8051935288948, -122.412941627226) | |||
| 54813 | 54813 | 143215 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 215 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010264.7976 | 2121285.9953 | 37.805225422298996 | -122.408732475128 | (37.805225422299, -122.408732475128) | |||
| 105255 | 105255 | 98564 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301X Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 112530 | 112530 | 98567 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301X Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 123219 | 123219 | 98563 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 138890 | 138890 | 98565 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301X Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |||
| 160416 | 160416 | 142656 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 382 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009478.0111 | 2121215.2198 | 37.8049869916815 | -122.411450254798 | (37.8049869916815, -122.411450254798) | |||
| 69906 | 69906 | 142657 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 392 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009464.6135 | 2121214.7045 | 37.8049848253291 | -122.411496582459 | (37.8049848253291, -122.411496582459) | |||
| 154475 | 154475 | 142658 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 396 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009447.6089 | 2121213.6739 | 37.8049810417497 | -122.411555356166 | (37.8049810417497, -122.411555356166) | |||
| 134214 | 134214 | 142744 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 410 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009308.9956 | 2121195.6387 | 37.804923745513 | -122.41203376959 | (37.804923745513, -122.41203376959) | |||
| 4622 | 4622 | 142543 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009503.7886 | 2121178.1337 | 37.8048866083098 | -122.411358426924 | (37.8048866083098, -122.411358426924) | |||
| 4558 | 4558 | 142520 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 7 | Width 0ft | 6009467.3323 | 2121175.1455 | 37.8048763586912 | -122.411484377145 | (37.8048763586912, -122.411484377145) | |||
| 4611 | 4611 | 142519 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | Width 0ft | 6009452.9889 | 2121171.5596 | 37.804865708173104 | -122.411533760714 | (37.8048657081731, -122.411533760714) | |||
| 4605 | 4605 | 142542 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 301 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | Width 0ft | 6009433.8643 | 2121170.962 | 37.8048629945672 | -122.411599901453 | (37.8048629945672, -122.411599901453) | |||
| 128967 | 128967 | 142540 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2100 POWELL ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009421.7884 | 2121061.7254 | 37.8045623807522 | -122.411633968656 | (37.8045623807522, -122.411633968656) | |||
| 32276 | 32276 | 31868 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3633 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41912 | 5999648.6988 | 2121058.91348 | 37.804001595372604 | -122.445454333359 | (37.8040015953726, -122.445454333359) | |
| 97910 | 97910 | 100983 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
| 107842 | 107842 | 100984 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
| 145388 | 145388 | 100987 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |||
| 169417 | 169417 | 249809 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010708.4562800005 | 2121025.2354099997 | 37.804534279087704 | -122.407178739215 | (37.8045342790877, -122.407178739215) | |||
| 53839 | 53839 | 249807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | |||
| 52205 | 52205 | 249810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.804517058874396 | -122.407221117962 | (37.8045170588744, -122.407221117962) | |||
| 156801 | 156801 | 249808 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 0ft | 6010714.23144 | 2121016.75548 | 37.80451131849129 | -122.40715815553101 | (37.8045113184913, -122.407158155531) | |||
| 64989 | 64989 | 142537 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2100 POWELL ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009436.3973 | 2120993.5505 | 37.8043760089549 | -122.411578593269 | (37.8043760089549, -122.411578593269) | |||
| 32782 | 32782 | 142536 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2100 POWELL ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009440.4553 | 2120971.6371 | 37.8043160678486 | -122.411563000977 | (37.8043160678486, -122.411563000977) | |||
| 58041 | 58041 | 135851 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 787 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007518.53532 | 2120901.3436 | 37.804015067204105 | -122.41820899156299 | (37.8040150672041, -122.418208991563) | |||
| 60338 | 60338 | 135850 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2456 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6007513.5376 | 2120862.81684 | 37.803909001168606 | -122.418223553398 | (37.8039090011686, -122.418223553398) | |||
| 67124 | 67124 | 135849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2456 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007515.30382 | 2120841.49853 | 37.8038505659037 | -122.418215928918 | (37.8038505659037, -122.418215928918) | |||
| 98671 | 98671 | 50376 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1620 Montgomery St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 112875 | 112875 | 50379 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1620 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 144023 | 144023 | 50380 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1620 Montgomery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 183700 | 183700 | 68974 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32964 | 5999680.68438 | 2120824.08507 | 37.803358645751295 | -122.44532675102501 | (37.8033586457513, -122.445326751025) | |
| 161924 | 161924 | 142610 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2424 JONES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008008.0914 | 2120777.2854 | 37.803701978308894 | -122.416506051836 | (37.8037019783089, -122.416506051836) | |||
| 168673 | 168673 | 135848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2434 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007523.24086 | 2120777.2700900002 | 37.80367465761871 | -122.418183905875 | (37.8036746576187, -122.418183905875) | |||
| 181487 | 181487 | 135847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2434 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6007523.40269 | 2120763.6636799998 | 37.8036373069691 | -122.41818238061501 | (37.8036373069691, -122.418182380615) | |||
| 70624 | 70624 | 135855 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 220 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011218.6149 | 2120762.89652 | 37.8038424981016 | -122.405394792746 | (37.8038424981016, -122.405394792746) | |||
| 172038 | 172038 | 135857 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 220 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011195.52799 | 2120759.07991 | 37.803830727779896 | -122.405474417834 | (37.8038307277799, -122.405474417834) | |||
| 46464 | 46464 | 135859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 220 Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011176.6986 | 2120755.37641 | 37.8038195060395 | -122.405539317394 | (37.8038195060395, -122.405539317394) | |||
| 167843 | 167843 | 135854 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 220 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011219.52919 | 2120749.38326 | 37.8038054451262 | -122.405390676534 | (37.8038054451262, -122.405390676534) | |||
| 29291 | 29291 | 135856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 220 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011197.01398 | 2120748.14382 | 37.803800783049 | -122.405468504785 | (37.803800783049, -122.405468504785) | |||
| 172610 | 172610 | 135846 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2430 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007526.597999999 | 2120747.58183 | 37.803593330130894 | -122.41817018222 | (37.8035933301309, -122.41817018222) | |||
| 33770 | 33770 | 135858 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 220 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011178.53707 | 2120744.3558400003 | 37.8037893490595 | -122.405532178584 | (37.8037893490595, -122.405532178584) | |||
| 155997 | 155997 | 135845 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2430 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007529.20491 | 2120735.0222099996 | 37.8035589913248 | -122.418160269894 | (37.8035589913248, -122.418160269894) | |||
| 60551 | 60551 | 53178 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2420 REVISED Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2006 12:00:00 AM | 5 | Permit Number 49096 | 6007531.88349 | 2120715.221 | 37.8035047729776 | -122.418149595852 | (37.8035047729776, -122.418149595852) | ||
| 169655 | 169655 | 41205 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3525 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41911 | 5999706.5792 | 2120652.81241 | 37.802889855249504 | -122.445224820077 | (37.8028898552495, -122.445224820077) | |
| 154200 | 154200 | 143244 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1913 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009926.8482 | 2120632.4472 | 37.80341200747171 | -122.409855833569 | (37.8034120074717, -122.409855833569) | |||
| 147000 | 147000 | 81692 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1756-1758 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52334 | 6002382.95834 | 2120580.66995 | 37.80284417507671 | -122.43595801776002 | (37.8028441750767, -122.43595801776) | |
| 157147 | 157147 | 69527 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2209 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1997 12:00:00 AM | 6 | Permit Number 37887 | 6000084.88337 | 2120557.1111 | 37.8026486714458 | -122.44390881695699 | (37.8026486714458, -122.443908816957) | ||
| 157654 | 157654 | 65833 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2217 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1990 12:00:00 AM | 6 | Permit Number 28823 | 6000063.66175 | 2120554.12794 | 37.8026392699554 | -122.44398203975099 | (37.8026392699554, -122.443982039751) | ||
| 155001 | 155001 | 65968 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 990 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 4 | Permit Number 28992 | 6007125.46509 | 2120550.16631 | 37.8030286907859 | -122.419544310327 | (37.8030286907859, -122.419544310327) | ||
| 49725 | 49725 | 65835 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2223 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1990 12:00:00 AM | 4 | Permit Number 28825 | 6000036.0569400005 | 2120549.43371 | 37.802624806145 | -122.44407722848301 | (37.802624806145, -122.444077228483) | ||
| 68543 | 68543 | 48595 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2820 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 7 | Permit Number 45905 | 6006103.679280001 | 2120512.11503 | 37.802866605061 | -122.42307752091499 | (37.802866605061, -122.423077520915) | |
| 131807 | 131807 | 249873 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 26 | Width 0ft | 6011670.78297 | 2120474.23594 | 37.8030751776447 | -122.403809705266 | (37.8030751776447, -122.403809705266) | |||
| 31893 | 31893 | 79837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 6 | 6006109.456119999 | 2120466.37489 | 37.80274134031279 | -122.42305427704599 | (37.8027413403128, -122.423054277046) | ||
| 171246 | 171246 | 249875 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | Width 0ft | 6011656.00691 | 2120465.5569700003 | 37.803050521838706 | -122.40386022737499 | (37.8030505218387, -122.403860227375) | |||
| 81488 | 81488 | 13074 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 91375 | 91375 | 13073 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 32953 | 32953 | 143252 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 661 LOMBARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009254.6269 | 2120447.319 | 37.802865995827396 | -122.412168998949 | (37.8028659958274, -122.412168998949) | |||
| 128628 | 128628 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 16 | 1150 Lombard St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.42057600387301 | (37.8027004912885, -122.420576003873) | ||
| 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) | |||
| 31620 | 31620 | 143251 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 661 LOMBARD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009160.7844 | 2120435.4058 | 37.8028280191875 | -122.41249290083599 | (37.8028280191875, -122.412492900836) | |||
| 51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
| 37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
| 71454 | 71454 | 249847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 289 Greenwich St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6011426.79495 | 2120392.20909 | 37.8028363185975 | -122.40464825831002 | (37.8028363185975, -122.40464825831) | |||
| 30620 | 30620 | 121688 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6008462.12689 | 2120388.3747 | 37.802659650390794 | -122.414907290765 | (37.8026596503908, -122.414907290765) | ||||
| 155614 | 155614 | 121689 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008443.301530001 | 2120385.2075400003 | 37.8026498963393 | -122.414972211914 | (37.8026498963393, -122.414972211914) | ||||
| 63079 | 63079 | 249835 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011233.03828 | 2120380.52255 | 37.8027933993566 | -122.40531793578 | (37.8027933993566, -122.40531793578) | |||
| 35676 | 35676 | 249834 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 6011234.1519 | 2120371.9476900003 | 37.8027699171526 | -122.40531347785401 | (37.8027699171526, -122.405313477854) | |||
| 30309 | 30309 | 249829 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011201.84726 | 2120367.04696 | 37.802754654775704 | -122.405424923615 | (37.8027546547757, -122.405424923615) | |||
| 39263 | 39263 | 249833 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 333 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011234.89731 | 2120366.37397 | 37.8027546547576 | -122.40531050560101 | (37.8027546547576, -122.405310505601) | |||
| 154980 | 154980 | 143084 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 463 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010663.1497 | 2120298.4418 | 37.802536147352704 | -122.407284261185 | (37.8025361473527, -122.407284261185) | |||
| 117381 | 117381 | 116893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 176 ALHAMBRA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001452.0 | 2120263.0 | 37.8019190076456 | -122.43915682267799 | (37.8019190076456, -122.439156822678) | ||||
| 173495 | 173495 | 249974 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Napier Ln | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011652.50252 | 2120258.9240099997 | 37.802482962378704 | -122.403857805517 | (37.8024829623787, -122.403857805517) | |||
| 41984 | 41984 | 135853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Filbert St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | 6012286.0131 | 2120198.4327700003 | 37.8023522396158 | -122.40166127704799 | (37.8023522396158, -122.401661277048) | ||||
| 54014 | 54014 | 135817 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1083 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6007203.659469999 | 2120166.57987 | 37.8019798636266 | -122.419246489941 | (37.8019798636266, -122.419246489941) | |||
| 39787 | 39787 | 135818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1071 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6007217.26018 | 2120160.1793299997 | 37.801963055314495 | -122.419198970666 | (37.8019630553145, -122.419198970666) | |||
| 68322 | 68322 | 142615 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 GREENWICH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009481.4553 | 2120134.1797 | 37.802018917842105 | -122.411361918128 | (37.8020189178421, -122.411361918128) | |||
| 51205 | 51205 | 142614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009469.9119 | 2120131.871 | 37.8020119312896 | -122.41140170073099 | (37.8020119312896, -122.411401700731) | |||
| 169591 | 169591 | 142613 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009456.5216 | 2120130.9476 | 37.802008644823204 | -122.41144797242701 | (37.8020086448232, -122.411447972427) | |||
| 156784 | 156784 | 71423 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 12 | 6009442.6696 | 2120129.5624 | 37.8020040644534 | -122.411495809181 | (37.8020040644534, -122.411495809181) | ||
| 188163 | 188163 | 135837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2333 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007565.4054 | 2120114.29452 | 37.801856667323705 | -122.417990966211 | (37.8018566673237, -122.417990966211) | |||
| 159690 | 159690 | 249982 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 224 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011639.74764 | 2120113.25639 | 37.8020822820333 | -122.403891687471 | (37.8020822820333, -122.403891687471) | |||
| 150527 | 150527 | 142616 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1867 POWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009512.0452 | 2120108.7843 | 37.801950904005 | -122.411254267134 | (37.801950904005, -122.411254267134) | |||
| 27269 | 27269 | 250005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 232 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011493.8796 | 2120090.77159 | 37.802012393927 | -122.404394879735 | (37.802012393927, -122.404394879735) | |||
| 159363 | 159363 | 249970 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011737.037830001 | 2120086.51138 | 37.802014281606205 | -122.403553132272 | (37.8020142816062, -122.403553132272) | |||
| 28833 | 28833 | 249969 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 213 Filbert St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 28 | Width 0ft | 6011730.79134 | 2120085.86253 | 37.802012151107704 | -122.403574702535 | (37.8020121511077, -122.403574702535) | |||
| 182162 | 182162 | 249963 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 271 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011592.60874 | 2120072.38059 | 37.8019674134157 | -122.404051933175 | (37.8019674134157, -122.404051933175) | |||
| 184115 | 184115 | 249937 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 339 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011248.56733 | 2120031.66705 | 37.8018363956996 | -122.405239616532 | (37.8018363956996, -122.405239616532) | |||
| 76837 | 76837 | 249945 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 325 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6011292.48387 | 2120026.50548 | 37.8018246784261 | -122.40508728037399 | (37.8018246784261, -122.405087280374) | |||
| 116481 | 116481 | 249933 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011225.47356 | 2120026.31802 | 37.801820417444 | -122.405319155254 | (37.801820417444, -122.405319155254) | |||
| 58002 | 58002 | 249931 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 345 Filbert St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 6011214.74621 | 2120016.06231 | 37.801791658008106 | -122.405355554416 | (37.8017916580081, -122.405355554416) | |||
| 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) | ||||
| 136520 | 136520 | 142628 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1922 MASON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009103.5255 | 2119888.7677 | 37.801323873537896 | -122.41265238046002 | (37.8013238735379, -122.41265238046) |
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");