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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60847 | 60847 | 183475 | Undocumented 2 | :: 54 | 2543 24th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988910.1133 | 2097942.5592 | 37.739911585859296 | -122.480921992881 | (37.7399115858593, -122.480921992881) | |||
| 55794 | 55794 | 183502 | Undocumented 2 | :: 54 | 2535 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987043.8814 | 2097999.1529 | 37.739958320304495 | -122.48737871628 | (37.7399583203045, -122.48737871628) | |||
| 68931 | 68931 | 183511 | Undocumented 2 | :: 54 | 2546 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988332.8152 | 2097971.981 | 37.7399587963622 | -122.482920180681 | (37.7399587963622, -122.482920180681) | |||
| 92619 | 92619 | 115024 | Permitted Site 1 | :: 54 | 2500 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2016 12:00:00 AM | 5983385.7 | 2098079.0 | 37.739963544351504 | -122.500032889381 | (37.7399635443515, -122.500032889381) | ||||
| 33310 | 33310 | 185231 | Undocumented 2 | :: 54 | 2526 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986157.8975 | 2098028.4291 | 37.7399869968702 | -122.49044419216101 | (37.7399869968702, -122.490444192161) | |||
| 169031 | 169031 | 183501 | Undocumented 2 | :: 54 | 2534 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987089.5609 | 2098009.5749 | 37.739989600163 | -122.48722154286001 | (37.739989600163, -122.48722154286) | |||
| 24683 | 24683 | 183508 | Undocumented 2 | :: 54 | 2547 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988598.1694 | 2097978.5588 | 37.7399922937625 | -122.482003188533 | (37.7399922937625, -122.482003188533) | |||
| 59328 | 59328 | 183210 | Undocumented 2 | :: 54 | 2494 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981807.3053 | 2098133.0426 | 37.740019170203205 | -122.50549423487499 | (37.7400191702032, -122.505494234875) | |||
| 52308 | 52308 | 183503 | Undocumented 2 | :: 54 | 2542 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988332.5337 | 2097995.0598 | 37.7400221483249 | -122.482922844986 | (37.7400221483249, -122.482922844986) | |||
| 149131 | 149131 | 183493 | Undocumented 2 | :: 54 | 2531 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987043.6597 | 2098023.3231 | 37.74002467234929 | -122.48738125777099 | (37.7400246723493, -122.487381257771) | |||
| 151796 | 151796 | 183504 | Undocumented 2 | :: 54 | 2550 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989576.1036 | 2097983.595 | 37.7400629496831 | -122.478622301865 | (37.7400629496831, -122.478622301865) | |||
| 115628 | 115628 | 185224 | Undocumented 2 | :: 54 | 2518 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986156.3055 | 2098078.3097 | 37.7401238627179 | -122.490453365241 | (37.7401238627179, -122.490453365241) | |||
| 178952 | 178952 | 183207 | Undocumented 2 | :: 54 | 2487 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981762.9721 | 2098176.699 | 37.7401364295663 | -122.505650753582 | (37.7401364295663, -122.505650753582) | |||
| 61251 | 61251 | 185223 | Undocumented 2 | :: 54 | 2515 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985800.5083 | 2098093.5658 | 37.7401449642117 | -122.491684672602 | (37.7401449642117, -122.491684672602) | |||
| 34742 | 34742 | 183206 | Undocumented 2 | :: 54 | 2486 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981807.3053 | 2098184.1443 | 37.7401594813682 | -122.50549802177 | (37.7401594813682, -122.50549802177) | |||
| 41897 | 41897 | 183464 | Undocumented 2 | :: 54 | 2531 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988282.4359 | 2098065.1404 | 37.7402116561415 | -122.48310119578899 | (37.7402116561415, -122.483101195789) | |||
| 31770 | 31770 | 183463 | Undocumented 2 | :: 54 | 2530 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988329.4378 | 2098069.925 | 37.740227528416796 | -122.482939034698 | (37.7402275284168, -122.482939034698) | |||
| 67072 | 67072 | 183201 | Undocumented 2 | :: 54 | 3850 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984019.7512 | 2098181.555 | 37.7402823237858 | -122.497848207912 | (37.7402823237858, -122.497848207912) | |||
| 135723 | 135723 | 185139 | Undocumented 2 | :: 54 | 2500 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986153.1217 | 2098167.9887 | 37.7403699113811 | -122.490470969264 | (37.7403699113811, -122.490470969264) | |||
| 54627 | 54627 | 36527 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
| 123158 | 123158 | 36526 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
| 143390 | 143390 | 36528 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
| 181680 | 181680 | 183460 | Undocumented 2 | :: 54 | 2531 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989523.5075 | 2098113.9575 | 37.740417837399505 | -122.478813687602 | (37.7404178373995, -122.478813687602) | |||
| 114741 | 114741 | 104860 | Permitted Site 1 | :: 54 | 283 Randall St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | ||||||
| 24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
| 164879 | 164879 | 183455 | Undocumented 2 | :: 54 | 2519 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988280.4658 | 2098156.3296 | 37.74046192314 | -122.483114689708 | (37.74046192314, -122.483114689708) | |||
| 155392 | 155392 | 183456 | Undocumented 2 | :: 54 | 2527 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989523.0923 | 2098140.5318 | 37.7404907794226 | -122.47881706628999 | (37.7404907794226, -122.47881706629) | |||
| 158169 | 158169 | 183195 | Undocumented 2 | :: 54 | 2467 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981757.2189 | 2098306.9914 | 37.740493837912396 | -122.505680301686 | (37.7404938379124, -122.505680301686) | |||
| 183851 | 183851 | 183451 | Undocumented 2 | :: 54 | 2515 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988280.1843 | 2098179.6898 | 37.7405260477437 | -122.48311737481701 | (37.7405260477437, -122.483117374817) | |||
| 65156 | 65156 | 181787 | Undocumented 2 | :: 54 | 2915 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986983.636 | 2098224.4165 | 37.740573320949004 | -122.487603561386 | (37.740573320949, -122.487603561386) | |||
| 59144 | 59144 | 183447 | Undocumented 2 | :: 54 | 2515 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988900.4073 | 2098186.5563 | 37.7405809740853 | -122.480973412109 | (37.7405809740853, -122.480973412109) | |||
| 54458 | 54458 | 182004 | Undocumented 2 | :: 54 | 3220 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986004.751 | 2098249.2905 | 37.7405844772428 | -122.49098995064101 | (37.7405844772428, -122.490989950641) | |||
| 56203 | 56203 | 183446 | Undocumented 2 | :: 54 | 2511 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988279.6214 | 2098205.3016 | 37.7405963382743 | -122.483121197886 | (37.7405963382743, -122.483121197886) | |||
| 51111 | 51111 | 181786 | Undocumented 2 | :: 54 | 2825 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987226.2844 | 2098233.5539 | 37.7406125590653 | -122.486765258584 | (37.7406125590653, -122.486765258584) | |||
| 32375 | 32375 | 183437 | Undocumented 2 | :: 54 | 2509 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988899.1764 | 2098219.7887 | 37.7406721500335 | -122.480980100642 | (37.7406721500335, -122.480980100642) | |||
| 151733 | 151733 | 181988 | Undocumented 2 | :: 54 | 2838 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987152.1701 | 2098289.7319 | 37.740762487887004 | -122.487025638785 | (37.740762487887, -122.487025638785) | |||
| 27770 | 27770 | 181987 | Undocumented 2 | :: 54 | 2832 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987195.8265 | 2098292.1009 | 37.7407715379119 | -122.486874867312 | (37.7407715379119, -122.486874867312) | |||
| 64771 | 64771 | 181984 | Undocumented 2 | :: 54 | 2820 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987242.8671 | 2098293.4545 | 37.7407779970161 | -122.486712320121 | (37.7407779970161, -122.486712320121) | |||
| 34729 | 34729 | 182011 | Undocumented 2 | :: 54 | 2483 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985479.3511 | 2098339.1415 | 37.7408004743688 | -122.49281317123501 | (37.7408004743688, -122.492813171235) | |||
| 40078 | 40078 | 182086 | Undocumented 2 | :: 54 | 2425 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988468.6309 | 2098276.195 | 37.7408019901024 | -122.482472876934 | (37.7408019901024, -122.482472876934) | |||
| 147904 | 147904 | 183186 | Undocumented 2 | :: 54 | 2446 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.1527 | 2098421.378 | 37.740810262110294 | -122.505550705456 | (37.7408102621103, -122.505550705456) | |||
| 182304 | 182304 | 181975 | Undocumented 2 | :: 54 | 2708 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987607.3474 | 2098305.6377 | 37.7408326905399 | -122.485452994275 | (37.7408326905399, -122.485452994275) | |||
| 110336 | 110336 | 52107 | Permitted Site 1 | :: 54 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | ||
| 88172 | 88172 | 33514 | Permitted Site 1 | :: 54 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37614 | 6006108.24130768 | 2097930.15080676 | 37.7408622046731 | -122.421457054715 | (37.7408622046731, -122.421457054715) | ||
| 68216 | 68216 | 182001 | Undocumented 2 | :: 54 | 2479 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985789.8531 | 2098361.3081 | 37.740879490197294 | -122.491741218454 | (37.7408794901973, -122.491741218454) | |||
| 54106 | 54106 | 182574 | Undocumented 2 | :: 54 | 2243 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989005.4575 | 2098295.1152 | 37.740885154470504 | -122.480618138278 | (37.7408851544705, -122.480618138278) | |||
| 130888 | 130888 | 182125 | Undocumented 2 | :: 54 | 2550 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988051.6952 | 2098318.4978 | 37.7408938790713 | -122.483917567452 | (37.7408938790713, -122.483917567452) | |||
| 42074 | 42074 | 182122 | Undocumented 2 | :: 54 | 2532 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988111.9343 | 2098322.8972 | 37.7409094653527 | -122.48370960803801 | (37.7409094653527, -122.483709608038) | |||
| 150619 | 150619 | 182121 | Undocumented 2 | :: 54 | 2516 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988187.7408 | 2098326.2815 | 37.7409231701359 | -122.48344774848302 | (37.7409231701359, -122.483447748483) | |||
| 163349 | 163349 | 182000 | Undocumented 2 | :: 54 | 2494 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987388.7269 | 2098344.5562 | 37.7409268110097 | -122.486211748852 | (37.7409268110097, -122.486211748852) | |||
| 33564 | 33564 | 182573 | Undocumented 2 | :: 54 | 2185 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989329.4471 | 2098306.2746 | 37.740934619914796 | -122.479498731562 | (37.7409346199148, -122.479498731562) | |||
| 136488 | 136488 | 182995 | Undocumented 2 | :: 54 | 2115 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989428.2356 | 2098309.2017 | 37.740948394722096 | -122.479157375315 | (37.7409483947221, -122.479157375315) | |||
| 157391 | 157391 | 245377 | Undocumented 2 | :: 54 | 3484 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005669.5792 | 2097980.5479 | 37.7409758407669 | -122.42297736783001 | (37.7409758407669, -122.42297736783) | |||
| 179192 | 179192 | 182994 | Undocumented 2 | :: 54 | 2085 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989637.5208 | 2098316.5193 | 37.7409806392129 | -122.478434287218 | (37.7409806392129, -122.478434287218) | |||
| 24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
| 26723 | 26723 | 183174 | Undocumented 2 | :: 54 | 2400 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984903.1916 | 2098438.8046 | 37.7410404135541 | -122.494812631239 | (37.7410404135541, -122.494812631239) | |||
| 24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
| 166639 | 166639 | 182565 | Undocumented 2 | :: 54 | 2150 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989287.7364 | 2098362.6206 | 37.7410869084631 | -122.479647071884 | (37.7410869084631, -122.479647071884) | |||
| 50452 | 50452 | 182564 | Undocumented 2 | :: 54 | 2122 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989402.8067 | 2098365.7306 | 37.741102131537396 | -122.479249432397 | (37.7411021315374, -122.479249432397) | |||
| 147090 | 147090 | 181972 | Undocumented 2 | :: 54 | 2474 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986764.6771 | 2098431.8691 | 37.7411301577029 | -122.488375868808 | (37.7411301577029, -122.488375868808) | |||
| 152529 | 152529 | 181973 | Undocumented 2 | :: 54 | 2479 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987341.0094 | 2098425.1006 | 37.7411451833908 | -122.486382648143 | (37.7411451833908, -122.486382648143) | |||
| 162894 | 162894 | 181968 | Undocumented 2 | :: 54 | 2470 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987383.6506 | 2098459.9581 | 37.7412433782525 | -122.486237770448 | (37.7412433782525, -122.486237770448) | |||
| 132820 | 132820 | 181960 | Undocumented 2 | :: 54 | 2455 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985784.4384 | 2098510.2137 | 37.7412880286271 | -122.491770899478 | (37.7412880286271, -122.491770899478) | |||
| 152865 | 152865 | 181963 | Undocumented 2 | :: 54 | 2463 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986716.6212 | 2098499.215 | 37.741312267621005 | -122.48854697515101 | (37.741312267621, -122.488546975151) | |||
| 23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
| 131841 | 131841 | 183169 | Undocumented 2 | :: 54 | 2446 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985207.9224 | 2098551.7909 | 37.741368476378 | -122.49376732249901 | (37.741368476378, -122.493767322499) | |||
| 175087 | 175087 | 181959 | Undocumented 2 | :: 54 | 2463 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987337.2868 | 2098513.0903 | 37.7413865628432 | -122.48640197789301 | (37.7413865628432, -122.486401977893) | |||
| 63109 | 63109 | 181952 | Undocumented 2 | :: 54 | 2451 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985784.0999 | 2098546.4248 | 37.7413874348207 | -122.49177473498699 | (37.7413874348207, -122.491774734987) | |||
| 68823 | 68823 | 181958 | Undocumented 2 | :: 54 | 2462 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987382.2969 | 2098516.8129 | 37.7413994075961 | -122.486246623862 | (37.7413994075961, -122.486246623862) | |||
| 178220 | 178220 | 199651 | Undocumented 2 | :: 54 | 0 | 37 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.37930996579901 | (37.7414476037323, -122.379309965799) | |||
| 131273 | 131273 | 181946 | Undocumented 2 | :: 54 | 2442 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985518.9465 | 2098587.8815 | 37.7414857629711 | -122.492694582596 | (37.7414857629711, -122.492694582596) | |||
| 168190 | 168190 | 183164 | Undocumented 2 | :: 54 | 2410 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982410.373 | 2098682.978 | 37.7415646129837 | -122.50344982148899 | (37.7415646129837, -122.503449821489) | |||
| 31188 | 31188 | 181929 | Undocumented 2 | :: 54 | 2427 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985466.1527 | 2098683.3165 | 37.7417447146597 | -122.492884150676 | (37.7417447146597, -122.492884150676) | |||
| 62791 | 62791 | 181931 | Undocumented 2 | :: 54 | 2434 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986447.2375 | 2098665.0417 | 37.741751860864206 | -122.48949058733601 | (37.7417518608642, -122.489490587336) | |||
| 148991 | 148991 | 182578 | Undocumented 2 | :: 54 | 2451 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988885.5665 | 2098636.2758 | 37.7418149236633 | -122.481057645938 | (37.7418149236633, -122.481057645938) | |||
| 19176 | 19176 | 36500 | Permitted Site 1 | :: 54 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39380 | 6007942.28499887 | 2098248.55652594 | 37.741839715130894 | -122.41513812883001 | (37.7418397151309, -122.41513812883) | ||
| 78333 | 78333 | 38003 | Permitted Site 1 | :: 54 | 2478 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2002 12:00:00 AM | Permit Number 40215 | 5992069.67302471 | 2098579.11634993 | 37.74184256230679 | -122.47004399101499 | (37.7418425623068, -122.470043991015) | ||
| 93962 | 93962 | 115298 | Permitted Site 1 | :: 54 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | |||||
| 133138 | 133138 | 183009 | Undocumented 2 | :: 54 | 2457 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989817.7183 | 2098630.996 | 37.741854570392604 | -122.477834220439 | (37.7418545703926, -122.477834220439) | |||
| 66833 | 66833 | 182577 | Undocumented 2 | :: 54 | 2450 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988930.5766 | 2098660.9806 | 37.7418853730059 | -122.480903825947 | (37.7418853730059, -122.480903825947) | |||
| 112494 | 112494 | 119244 | Undocumented 2 | :: 54 | 311 30th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2016 12:00:00 AM | 3 | 3x3 | 6004402.0 | 2098353.0 | 37.7419269008751 | -122.42738671849101 | (37.7419269008751, -122.427386718491) | |||
| 161363 | 161363 | 181966 | Undocumented 2 | :: 54 | 2426 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987066.2109 | 2098726.6344 | 37.7419570938864 | -122.48735493353 | (37.7419570938864, -122.48735493353) | |||
| 167644 | 167644 | 183008 | Undocumented 2 | :: 54 | 2450 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989860.5266 | 2098686.6102 | 37.7420097569425 | -122.477690269186 | (37.7420097569425, -122.477690269186) | |||
| 32428 | 32428 | 182575 | Undocumented 2 | :: 54 | 2444 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989239.9887 | 2098703.075 | 37.742018933713105 | -122.479837071242 | (37.7420189337131, -122.479837071242) | |||
| 183469 | 183469 | 181965 | Undocumented 2 | :: 54 | 2423 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987019.5087 | 2098756.0771 | 37.7420352120933 | -122.48751857494499 | (37.7420352120933, -122.487518574945) | |||
| 154166 | 154166 | 182576 | Undocumented 2 | :: 54 | 2443 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989193.1556 | 2098714.7832 | 37.742048360443604 | -122.47999985995001 | (37.7420483604436, -122.47999985995) | |||
| 179549 | 179549 | 183170 | Undocumented 2 | :: 54 | 2382 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981781.9237 | 2098892.7996 | 37.74210375914 | -122.505638298262 | (37.74210375914, -122.505638298262) | |||
| 62214 | 62214 | 183006 | Undocumented 2 | :: 54 | 2438 21st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989859.0631 | 2098748.8104 | 37.7421804576164 | -122.477699875038 | (37.7421804576164, -122.477699875038) | |||
| 46223 | 46223 | 181942 | Undocumented 2 | :: 54 | 2398 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985816.5038 | 2098939.4172 | 37.7424683803993 | -122.49169161796499 | (37.7424683803993, -122.491691617965) | |||
| 184350 | 184350 | 181778 | Undocumented 2 | :: 54 | 1519 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988463.5546 | 2098954.3923 | 37.74266384664261 | -122.482540111805 | (37.7426638466426, -122.482540111805) | |||
| 88816 | 88816 | 115002 | Undocumented 2 | :: 54 | 46 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993155.2 | 2098864.2 | 37.742688023212295 | -122.46631133896999 | (37.7426880232123, -122.46631133897) | |||||
| 9914 | 9914 | 173708 | DPW Maintained 3 | :: 54 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001214.0 | 2098705.0 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | ||||
| 77582 | 77582 | 37456 | Permitted Site 1 | :: 54 | 442 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.743020676259704 | -122.40723276795299 | (37.7430206762597, -122.407232767953) | ||
| 120864 | 120864 | 37457 | Permitted Site 1 | :: 54 | 442 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.743020676259704 | -122.40723276795299 | (37.7430206762597, -122.407232767953) | ||
| 70247 | 70247 | 181895 | Undocumented 2 | :: 54 | 2366 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986431.1624 | 2099136.6325 | 37.743045784789096 | -122.489580839702 | (37.7430457847891, -122.489580839702) | |||
| 31404 | 31404 | 181902 | Undocumented 2 | :: 54 | 2370 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986740.6492 | 2099140.1859 | 37.7430736050662 | -122.488510993633 | (37.7430736050662, -122.488510993633) | |||
| 169536 | 169536 | 182098 | Undocumented 2 | :: 54 | 2388 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989538.5514 | 2099099.4061 | 37.7431244964895 | -122.478833728629 | (37.7431244964895, -122.478833728629) | |||
| 187250 | 187250 | 181883 | Undocumented 2 | :: 54 | 2362 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986739.9723 | 2099172.336 | 37.7431618411675 | -122.48851569655001 | (37.7431618411675, -122.48851569655) | |||
| 76988 | 76988 | 181907 | Undocumented 2 | :: 54 | 2342 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985186.447000001 | 2099253.0496 | 37.7432926871864 | -122.493893242957 | (37.7432926871864, -122.493893242957) | |||
| 41041 | 41041 | 181871 | Undocumented 2 | :: 54 | 2362 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987360.2995 | 2099206.855 | 37.74329279819221 | -122.486373331241 | (37.7432927981922, -122.486373331241) |
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");