Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70435 | 70435 | 187490 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 750 Velasco Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6006575.2964699995 | 2086657.1322 | 37.709935258482 | -122.419042759324 | (37.709935258482, -122.419042759324) | ||||
| 183829 | 183829 | 218974 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5995324.88397 | 2091369.23318 | 37.7222336187729 | -122.458266889107 | (37.7222336187729, -122.458266889107) | |||
| 109753 | 109753 | 985 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1628 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001654.0889800005 | 2092682.1975 | 37.7262003881553 | -122.436482304747 | (37.7262003881553, -122.436482304747) | |||
| 91370 | 91370 | 51032 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 78 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47507 | 6004848.23489 | 2092967.4640400002 | 37.7271646546122 | -122.425460601145 | (37.7271646546122, -122.425460601145) | ||
| 32277 | 32277 | 218975 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 25 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993599.79076 | 2092994.2198700001 | 37.726596156286504 | -122.464347997761 | (37.7265961562865, -122.464347997761) | |||
| 57897 | 57897 | 51033 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 76 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 4 | Permit Number 47508 | 6004871.9247 | 2093005.4504099998 | 37.7272702952631 | -122.42538140772 | (37.7272702952631, -122.42538140772) | ||
| 164652 | 164652 | 192352 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1040 Palou Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6017850.25276 | 2093091.0077 | 37.728229933050706 | -122.380520862443 | (37.7282299330507, -122.380520862443) | |||
| 97990 | 97990 | 11657 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 172999 | 172999 | 83898 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 661 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50511 | 6001665.34461 | 2093208.93849 | 37.7276473387373 | -122.436481078764 | (37.7276473387373, -122.436481078764) | |
| 49592 | 49592 | 11636 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 93732 | 93732 | 11634 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 172557 | 172557 | 218973 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 550 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5997760.19795 | 2094413.18303 | 37.7307312291661 | -122.450067916609 | (37.7307312291661, -122.450067916609) | |||
| 179390 | 179390 | 218976 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 208 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000663.81639 | 2094977.92785 | 37.73244761315671 | -122.440070159711 | (37.7324476131567, -122.440070159711) | |||
| 187664 | 187664 | 218966 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 255 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992657.85366 | 2095112.0231700002 | 37.7323567798226 | -122.467758171218 | (37.7323567798226, -122.467758171218) | |||
| 36227 | 36227 | 225787 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 46 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004400.603180001 | 2095343.96322 | 37.7336646890731 | -122.42717726484 | (37.7336646890731, -122.42717726484) | |||
| 116506 | 116506 | 116066 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 40 MALTA DR | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 5999623.0 | 2096071.0 | 37.7353896244756 | -122.44374699604401 | (37.7353896244756, -122.443746996044) | |||||
| 70126 | 70126 | 192356 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | |||
| 34313 | 34313 | 192355 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.39623367064199 | (37.7375943028269, -122.396233670642) | |||
| 156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
| 14443 | 14443 | 25984 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013408.21183 | 2096665.5323700001 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) | |||
| 79400 | 79400 | 41689 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | |||
| 13842 | 13842 | 25983 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | |||
| 84899 | 84899 | 92547 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.42109327168501 | (37.740071660795, -122.421093271685) | |||
| 163347 | 163347 | 218971 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 736 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997513.55349 | 2097982.45512 | 37.7405174763054 | -122.451177906656 | (37.7405174763054, -122.451177906656) | |||
| 145428 | 145428 | 33475 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 194X COLERIDGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/1996 12:00:00 AM | 40 | Permit Number 37572 | 6006432.0 | 2098629.0 | 37.742799336995795 | -122.420387207052 | (37.7427993369958, -122.420387207052) | ||
| 84512 | 84512 | 33479 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 94836 | 94836 | 33480 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 112329 | 112329 | 33476 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 118261 | 118261 | 33474 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 141574 | 141574 | 33477 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 143673 | 143673 | 33478 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 52799 | 52799 | 192306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3600 03rd St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6015896.02327 | 2098855.55467 | 37.74395018136929 | -122.38767879773701 | (37.7439501813693, -122.387678797737) | |||
| 54476 | 54476 | 218970 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 85 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997504.5128 | 2099195.16066 | 37.7438467530404 | -122.45129660546499 | (37.7438467530404, -122.451296605465) | |||
| 90352 | 90352 | 107514 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 76 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x10 | 5993384.0 | 2099214.0 | 37.7436616846124 | -122.4655456274 | (37.7436616846124, -122.4655456274) | |||
| 177456 | 177456 | 225383 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 464 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002919.07295 | 2099218.44031 | 37.744219217150395 | -122.432576000288 | (37.7442192171504, -122.432576000288) | |||
| 2265 | 2265 | 252991 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005528.0 | 2099293.0 | 37.7445715466522 | -122.423560184697 | (37.7445715466522, -122.423560184697) | ||||
| 87227 | 87227 | 64914 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.362986099 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | |
| 46622 | 46622 | 248136 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 226 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6010037.88024 | 2099520.31318 | 37.745449227116204 | -122.407981876971 | (37.7454492271162, -122.407981876971) | |||
| 130861 | 130861 | 225380 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3200 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008095.36431 | 2100612.74929 | 37.7483398640139 | -122.41477610753401 | (37.7483398640139, -122.414776107534) | |||
| 76795 | 76795 | 225788 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4436 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001105.5651 | 2101159.8137 | 37.7494467567732 | -122.43898580666 | (37.7494467567732, -122.43898580666) | |||
| 158058 | 158058 | 225799 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3965 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004086.71679 | 2101282.70984 | 37.7499533700549 | -122.428685663533 | (37.7499533700549, -122.428685663533) | |||
| 23985 | 23985 | 192353 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1500 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6015367.9403099995 | 2101545.1725 | 37.7513060448498 | -122.38969261993 | (37.7513060448498, -122.38969261993) | |||
| 57020 | 57020 | 218969 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993603.1998 | 2101661.03992 | 37.750393275225704 | -122.46496537605499 | (37.7503932752257, -122.464965376055) | |||
| 188474 | 188474 | 218968 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 150 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5993617.45125 | 2101661.58733 | 37.7503955999976 | -122.464916133678 | (37.7503955999976, -122.464916133678) | |||
| 150960 | 150960 | 218967 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 140 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5993644.45362 | 2101662.07824 | 37.7503985047832 | -122.46482279396099 | (37.7503985047832, -122.464822793961) | |||
| 30174 | 30174 | 225388 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 306 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6004766.979119999 | 2101818.89406 | 37.751464083609996 | -122.426371452475 | (37.75146408361, -122.426371452475) | |||
| 25338 | 25338 | 225387 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | |||
| 53360 | 53360 | 225386 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6004769.89273 | 2101857.00053 | 37.751568879815395 | -122.42636408974501 | (37.7515688798154, -122.426364089745) | |||
| 176581 | 176581 | 225385 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004766.71932 | 2101872.10114 | 37.7516101631948 | -122.42637613885701 | (37.7516101631948, -122.426376138857) | |||
| 124107 | 124107 | 225384 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004767.459419999 | 2101889.24161 | 37.7516572687753 | -122.426374799776 | (37.7516572687753, -122.426374799776) | |||
| 47218 | 47218 | 192303 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011758.176530001 | 2102347.8311400004 | 37.753309143502605 | -122.402232092032 | (37.7533091435026, -122.402232092032) | |||
| 69720 | 69720 | 192302 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011784.47888 | 2102348.07827 | 37.753311290205296 | -122.402141149916 | (37.7533112902053, -122.402141149916) | |||
| 175214 | 175214 | 192301 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011807.32161 | 2102351.9134 | 37.753323095606106 | -122.402062424168 | (37.7533230956061, -122.402062424168) | |||
| 131706 | 131706 | 192300 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011831.68624 | 2102353.37218 | 37.7533284609567 | -122.401978268278 | (37.7533284609567, -122.401978268278) | |||
| 23787 | 23787 | 192299 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.1113599995 | 2102354.12957 | 37.7533316805221 | -122.401907686797 | (37.7533316805221, -122.401907686797) | |||
| 152668 | 152668 | 192298 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2200 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011908.73866 | 2102359.4276900003 | 37.7533493881837 | -122.40171222904699 | (37.7533493881837, -122.401712229047) | |||
| 152796 | 152796 | 225789 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 409 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997048.20072 | 2102795.35511 | 37.753705857856204 | -122.453134258532 | (37.7537058578562, -122.453134258532) | |||
| 140993 | 140993 | 56058 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49940 | 6009112.81160157 | 2103362.97509043 | 37.7559484836074 | -122.41145205807301 | (37.7559484836074, -122.411452058073) | ||
| 175184 | 175184 | 225800 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 839 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6003765.43327 | 2103426.88271 | 37.755822575974705 | -122.429949607592 | (37.7558225759747, -122.429949607592) | |||
| 184629 | 184629 | 225785 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 96 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005776.35688 | 2103464.45432 | 37.7560394169139 | -122.422997844584 | (37.7560394169139, -122.422997844584) | |||
| 43682 | 43682 | 225786 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 94 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005786.7967300005 | 2103464.50998 | 37.7560401588409 | -122.422961744009 | (37.7560401588409, -122.422961744009) | |||
| 134591 | 134591 | 225784 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 98 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005770.92499 | 2103464.5515400004 | 37.756039377343505 | -122.423016636805 | (37.7560393773435, -122.423016636805) | |||
| 57413 | 57413 | 225818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 98 Hill St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005774.11943 | 2103465.5032 | 37.7560421706386 | -122.423005656989 | (37.7560421706386, -122.423005656989) | |||
| 187202 | 187202 | 225803 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 378 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001778.51091 | 2103657.66309 | 37.7563435190568 | -122.43683753583099 | (37.7563435190568, -122.436837535831) | |||
| 181842 | 181842 | 225802 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 372 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001775.08554 | 2103686.11524 | 37.75642144712079 | -122.436851418666 | (37.7564214471208, -122.436851418666) | |||
| 168265 | 168265 | 225805 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 367 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001818.89494 | 2103707.75244 | 37.7564833474558 | -122.436701459403 | (37.7564833474558, -122.436701459403) | |||
| 55974 | 55974 | 225806 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 363 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001815.68909 | 2103737.4020700003 | 37.7565645760008 | -122.43671466866002 | (37.7565645760008, -122.43671466866) | |||
| 4450 | 4450 | 225795 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008004.64414 | 2103879.4657900003 | 37.7573044302625 | -122.415321039155 | (37.7573044302625, -122.415321039155) | |||
| 4518 | 4518 | 225796 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008035.828509999 | 2103884.08468 | 37.7573188652869 | -122.415213517995 | (37.7573188652869, -122.415213517995) | |||
| 4515 | 4515 | 225797 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008067.53952 | 2103885.7722400003 | 37.75732528104621 | -122.41510396797301 | (37.7573252810462, -122.415103967973) | |||
| 4521 | 4521 | 225798 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008119.80842 | 2103888.79141 | 37.757336508198705 | -122.414923414683 | (37.7573365081987, -122.414923414683) | |||
| 59057 | 59057 | 225804 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4433 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001581.80688 | 2104063.4307 | 37.7574464772949 | -122.437546862602 | (37.7574464772949, -122.437546862602) | |||
| 165124 | 165124 | 225801 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 4201 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001928.34635 | 2105251.90853 | 37.7607294461137 | -122.43643345245 | (37.7607294461137, -122.43643345245) | |||
| 55477 | 55477 | 225792 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007807.819130001 | 2105426.09185 | 37.761540045560295 | -122.416111269835 | (37.7615400455603, -122.416111269835) | |||
| 58336 | 58336 | 225382 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3614 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005452.14403 | 2105496.18029 | 37.761599759639104 | -122.424263576509 | (37.7615997596391, -122.424263576509) | |||
| 95274 | 95274 | 225793 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007803.17898 | 2105505.53039 | 37.761757904533205 | -122.416132944404 | (37.7617579045332, -122.416132944404) | |||
| 76249 | 76249 | 225794 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3291 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007798.59434 | 2105543.95905 | 37.761863162968105 | -122.416151522586 | (37.7618631629681, -122.416151522586) | |||
| 183667 | 183667 | 225780 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007669.1739300005 | 2105574.3226 | 37.76193925642529 | -122.41660128882401 | (37.7619392564253, -122.416601288824) | |||
| 149426 | 149426 | 225781 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007691.06747 | 2105574.75784 | 37.7619416827748 | -122.416525598274 | (37.7619416827748, -122.416525598274) | |||
| 174186 | 174186 | 225782 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3271 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007716.52666 | 2105576.00343 | 37.761946534627 | -122.416437632899 | (37.761946534627, -122.416437632899) | |||
| 32326 | 32326 | 225783 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3251 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007765.10393 | 2105579.72042 | 37.7619594722828 | -122.416269885947 | (37.7619594722828, -122.416269885947) | |||
| 69464 | 69464 | 218977 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 254 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 5996588.22406 | 2105623.7456099996 | 37.761445530401 | -122.45492930356701 | (37.761445530401, -122.454929303567) | |||
| 170242 | 170242 | 192294 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010701.8989 | 2105624.20056 | 37.7622463056326 | -122.40611574324 | (37.7622463056326, -122.40611574324) | |||
| 25212 | 25212 | 192295 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010700.612380001 | 2105651.26498 | 37.7623205464704 | -122.406122099663 | (37.7623205464704, -122.406122099663) | |||
| 188952 | 188952 | 192296 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.762396094938104 | -122.406134800806 | (37.7623960949381, -122.406134800806) | |||
| 69712 | 69712 | 192297 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6010694.42792 | 2105749.21353 | 37.7625891451824 | -122.406150390541 | (37.7625891451824, -122.406150390541) | |||
| 134588 | 134588 | 192304 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009910.49486 | 2105936.61453 | 37.7630598260768 | -122.40887496583001 | (37.7630598260768, -122.40887496583) | |||
| 33563 | 33563 | 192305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009925.06485 | 2105936.96188 | 37.763061595931894 | -122.40882459747 | (37.7630615959319, -122.40882459747) | |||
| 151890 | 151890 | 192390 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 233 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6014050.42421 | 2105956.49266 | 37.763345430981396 | -122.394557641045 | (37.7633454309814, -122.394557641045) | |||
| 168395 | 168395 | 225816 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 220 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000887.34044 | 2106474.16774 | 37.7640262618211 | -122.440121464252 | (37.7640262618211, -122.440121464252) | |||
| 107280 | 107280 | 56260 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 238 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | Permit Number 12386 | 5997570.92464879 | 2106477.05534424 | 37.763844826719705 | -122.451592119849 | (37.7638448267197, -122.451592119849) | |||
| 151215 | 151215 | 225817 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 220 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000861.2218 | 2106493.57318 | 37.764078057384296 | -122.440213192391 | (37.7640780573843, -122.440213192391) | |||
| 50532 | 50532 | 225778 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 924 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5998777.438569999 | 2106776.2154 | 37.7647352648411 | -122.447440705541 | (37.7647352648411, -122.447440705541) | |||
| 75021 | 75021 | 225791 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 920 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999226.76064 | 2106974.09226 | 37.765304251518 | -122.44590085663799 | (37.765304251518, -122.445900856638) | |||
| 53654 | 53654 | 225790 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 920 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999222.99784 | 2106999.85397 | 37.765374771852706 | -122.445915724224 | (37.7653747718527, -122.445915724224) | |||
| 33903 | 33903 | 225779 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1559 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999770.51083 | 2107118.5981099997 | 37.765732061717294 | -122.44403054288901 | (37.7657320617173, -122.444030542889) | |||
| 180692 | 180692 | 225809 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002900.20105 | 2107141.3628 | 37.765972605181204 | -122.433207255136 | (37.7659726051812, -122.433207255136) | |||
| 40849 | 40849 | 225810 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6002901.372830001 | 2107162.40051 | 37.766030436082794 | -122.433204705528 | (37.7660304360828, -122.433204705528) | |||
| 42776 | 42776 | 225811 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002903.222130001 | 2107175.55757 | 37.766066667072 | -122.43319924936701 | (37.766066667072, -122.433199249367) | |||
| 40148 | 40148 | 225812 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6002912.30789 | 2107203.01713 | 37.7661425797454 | -122.43316978576999 | (37.7661425797454, -122.43316978577) |
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");