trees
84 rows where qSpecies_id = 130 sorted by qSiteInfo descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56512 | 251807 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Hangah St | 1 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
128875 | 251813 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Hangah St | 6 | Unaccepted Street : Cutout | Tree | DPW for City Agency 14 | Rec/Park | 3x3 | 6010544 | 2117119 | 37.7937995065594 | -122.407472293877 | (37.7937995065594, -122.407472293877) | 3 | 1 | 10 | 28857 | 4 | |||
39008 | 124087 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 601 Funston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5991895.64316 | 2110979.91577 | 37.7758818301467 | -122.471549154142 | (37.7758818301467, -122.471549154142) | 11 | 6 | 2 | 54 | 11 | ||||
99404 | 206494 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 951 Noriega St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5991056.22326 | 2103119.66006 | 37.7542510772321 | -122.473879314989 | (37.7542510772321, -122.473879314989) | 1 | 8 | 4 | 56 | 12 | |||
122925 | 190924 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 Coral Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012726.05143 | 2102531.38164 | 37.7538671117048 | -122.398897840273 | (37.7538671117048, -122.398897840273) | 10 | 3 | 8 | 28856 | 29 | |||
140293 | 223264 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1335 Douglass St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6001398.86959 | 2099792.98211 | 37.7457104459924 | -122.437873667259 | (37.7457104459924, -122.437873667259) | 2 | 4 | 5 | 63 | 22 | |||
24260 | 123042 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 580 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5991931.41948 | 2111519.66175 | 37.7773658954626 | -122.471464734051 | (37.7773658954626, -122.471464734051) | 11 | 6 | 2 | 54 | 11 | |||
28179 | 120835 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 39 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 7ft | 5989870.35579 | 2114909.24265 | 37.7865532901402 | -122.478842518425 | (37.7865532901402, -122.478842518425) | 11 | 6 | 1 | 55 | 33 | |||
62398 | 122928 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 11th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5992434.60301 | 2114858.52429 | 37.7865625945776 | -122.469967239784 | (37.7865625945776, -122.469967239784) | 11 | 6 | 1 | 54 | 11 | |||
84346 | 120837 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 45 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 7ft | 5989872.80375 | 2114860.19185 | 37.786418752594 | -122.478830460346 | (37.786418752594, -122.478830460346) | 11 | 6 | 1 | 55 | 33 | |||
91174 | 206493 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1473 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5991137.15941 | 2105390.24146 | 37.7604901815048 | -122.47376505163 | (37.7604901815048, -122.47376505163) | 1 | 8 | 4 | 56 | 12 | |||
95179 | 123043 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 580 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5991932.13913 | 2111507.50022 | 37.7773325448459 | -122.471461358187 | (37.7773325448459, -122.471461358187) | 11 | 6 | 2 | 54 | 11 | |||
99177 | 123372 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 785 03rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995014 | 2110353 | 37.7743403969856 | -122.460716589224 | (37.7743403969856, -122.460716589224) | 11 | 6 | 2 | 54 | 11 | |||
99490 | 121890 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 10 17th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5990533.25211 | 2114989.52313 | 37.7868121875903 | -122.476554951379 | (37.7868121875903, -122.476554951379) | 11 | 6 | 1 | 61 | 30 | |||
101276 | 120836 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 39 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 5989871.68647 | 2114884.91927 | 37.7864865822534 | -122.47883613501 | (37.7864865822534, -122.47883613501) | 11 | 6 | 1 | 55 | 33 | |||
146288 | 122922 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2 11th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5992430.88304 | 2114907.16681 | 37.7866959384714 | -122.469983652903 | (37.7866959384714, -122.469983652903) | 11 | 6 | 1 | 54 | 11 | |||
165461 | 123379 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 749 03rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995025.1706 | 2110500.76663 | 37.774746767775 | -122.460688658893 | (37.774746767775, -122.460688658893) | 11 | 6 | 2 | 54 | 11 | |||
694 | 114020 | Undocumented 4 | Crateagus spp :: Hawthorn 130 | 1 HANGAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010635 | 2117072 | 37.7936755489769 | -122.407154109442 | (37.7936755489769, -122.407154109442) | 3 | 1 | 10 | 28857 | 4 | ||||
12307 | 70157 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 146 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991828.15451 | 2114449.08877 | 37.7854033229881 | -122.472035528968 | (37.7854033229881, -122.472035528968) | 11 | 6 | 2 | 54 | 11 | |||
31588 | 68555 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 741 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 3 | Permit Number 32444 | 5982266.64241 | 2110706.56992 | 37.7745695345787 | -122.504837518756 | (37.7745695345787, -122.504837518756) | 11 | 6 | 2 | 55 | 26 | |
43216 | 41948 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 728 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 4 | Permit Number 42305 | 5993520.08573 | 2110502.66781 | 37.7746652794532 | -122.46589515055 | (37.7746652794532, -122.46589515055) | 11 | 6 | 2 | 54 | 11 | |
45662 | 206491 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1308 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990523.48348 | 2106471.84224 | 37.763424405823 | -122.475966446316 | (37.763424405823, -122.475966446316) | 1 | 8 | 3 | 56 | 12 | |||
47877 | 68460 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 223 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 3 | Permit Number 32322 | 5991489.0737 | 2113907.29073 | 37.7838960683366 | -122.473169108553 | (37.7838960683366, -122.473169108553) | 11 | 6 | 2 | 54 | 26 | |
51361 | 68697 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 150 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 4 | Permit Number 32609 | 5991831.24339 | 2114440.33096 | 37.7853794552082 | -122.472024203913 | (37.7853794552082, -122.472024203913) | 11 | 6 | 2 | 54 | 11 | |
52654 | 223267 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3875 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002646.58178 | 2103540.65002 | 37.756071527187 | -122.433827084945 | (37.756071527187, -122.433827084945) | 2 | 4 | 5 | 28862 | 22 | |||
57504 | 31205 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 33 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Permit Number 34897 | 5989870.00853 | 2114921.90814 | 37.786588045846 | -122.478844646531 | (37.786588045846, -122.478844646531) | 11 | 6 | 1 | 55 | 33 | |||
58310 | 223016 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1540 Willard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996934.6568 | 2105861.52263 | 37.7621182727717 | -122.453748313849 | (37.7621182727717, -122.453748313849) | 15 | 5 | 11 | 29492 | 12 | |||
58431 | 12802 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2050 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2001 12:00:00 AM | 3 | 4 | 5989024.74638 | 2114719.81128 | 37.7859840273988 | -122.481754204403 | (37.7859840273988, -122.481754204403) | 11 | 6 | 1 | 55 | 33 | ||
59587 | 244982 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 299 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005186.9354 | 2109717.3084 | 37.773174988238 | -122.425481241171 | (37.773174988238, -122.425481241171) | 7 | 9 | 11 | 28852 | 10 | |
59747 | 66509 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 127 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53836 | 5992705.39241 | 2114612.37193 | 37.7859023775074 | -122.469012462668 | (37.7859023775074, -122.469012462668) | 11 | 6 | 2 | 54 | 11 |
60926 | 123594 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 101 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994559.20634 | 2114824.5245 | 37.7865918262597 | -122.462614221041 | (37.7865918262597, -122.462614221041) | 11 | 6 | 1 | 54 | 11 | |||
64794 | 108930 | Undocumented 4 | Crateagus spp :: Hawthorn 130 | 12x MACONDRAY LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008549 | 2119290 | 37.7996486687041 | -122.414528895865 | (37.7996486687041, -122.414528895865) | 5 | 1 | 10 | 308 | 32 | ||||
64850 | 12644 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 937 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3 | 5992540.24269 | 2114790.98836 | 37.7863832655855 | -122.469596837448 | (37.7863832655855, -122.469596837448) | 11 | 6 | 2 | 54 | 11 | |||
66403 | 124017 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 180 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991835.10121 | 2114260.96299 | 37.7848871836085 | -122.471997779085 | (37.7848871836085, -122.471997779085) | 11 | 6 | 2 | 54 | 11 | |||
71827 | 126375 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3763 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996836.12847 | 2115302.98536 | 37.7880364175886 | -122.45477125221 | (37.7880364175886, -122.45477125221) | 11 | 6 | 1 | 54 | 31 | |||
72203 | 40614 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 214 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2013 12:00:00 AM | Permit Number 769916 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | ||
74259 | 88639 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 100x Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51601 | 6012818.3 | 2113762.9 | 37.7847114789743 | -122.399367240893 | (37.7847114789743, -122.399367240893) | 6 | 2 | 9 | 28853 | 6 | ||
76030 | 68458 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 207 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 4 | Permit Number 32320 | 5991485.949 | 2114010.1457 | 37.7841782986973 | -122.473187422478 | (37.7841782986973, -122.473187422478) | 11 | 6 | 2 | 54 | 26 | |
80177 | 120694 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 100 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5988998.58289 | 2114633.79268 | 37.785746323178 | -122.481838418766 | (37.785746323178, -122.481838418766) | 11 | 6 | 2 | 55 | 26 | |||
82864 | 206495 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 31 Belmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996809.7824 | 2106085.82289 | 37.7627269842877 | -122.45419640556 | (37.7627269842877, -122.45419640556) | 15 | 5 | 11 | 29492 | 12 | |||
92952 | 69154 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1250 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 5 | Permit Number 33189 | 5983378.6107 | 2106617.4293 | 37.763407280167 | -122.500688624126 | (37.763407280167, -122.500688624126) | 1 | 8 | 3 | 56 | 35 | |
96771 | 48846 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3892 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/07/2002 12:00:00 AM | 1 | Permit Number 46060 | 5996304.71277 | 2114947.71304 | 37.7870304386541 | -122.456584143364 | (37.7870304386541, -122.456584143364) | 11 | 6 | 1 | 54 | 31 | |
96923 | 223018 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1540 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996937.97613 | 2105844.11799 | 37.7620706743516 | -122.453735576762 | (37.7620706743516, -122.453735576762) | 15 | 5 | 11 | 29492 | 12 | |||
97592 | 120323 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 762 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5988852.82501 | 2110137.4866 | 37.7733922487356 | -122.482013193201 | (37.7733922487356, -122.482013193201) | 11 | 6 | 2 | 55 | 26 | |||
97967 | 32542 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 91 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 6 | Permit Number 37040 | 5995849.28681 | 2113912.80222 | 37.7841626930639 | -122.458084878555 | (37.7841626930639, -122.458084878555) | 11 | 6 | 1 | 54 | 31 | |
100488 | 123595 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 101 04th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994560.26086 | 2114807.68068 | 37.786545638433 | -122.462609350398 | (37.786545638433, -122.462609350398) | 11 | 6 | 1 | 54 | 11 | |||
101291 | 81264 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50558 | 5992068.99896372 | 2086785.98935609 | 37.7094615111417 | -122.469188190402 | (37.7094615111417, -122.469188190402) | 9 | 8 | 4 | 64 | 24 | ||
101535 | 43756 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 158 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43392 | 5990560.29942 | 2114339.89487 | 37.7850300587842 | -122.4764139024 | (37.7850300587842, -122.4764139024) | 11 | 6 | 2 | 54 | 26 | |
102154 | 40617 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 298X Laussat St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2013 12:00:00 AM | Permit Number 769916 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | |||
103373 | 12643 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 937 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3 | 5992519.98081 | 2114788.22111 | 37.7863744964197 | -122.46966673625 | (37.7863744964197, -122.46966673625) | 11 | 6 | 2 | 54 | 11 | |||
105654 | 206492 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1473 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991136.32606 | 2105407.76116 | 37.7605382376799 | -122.47376921189 | (37.7605382376799, -122.47376921189) | 1 | 8 | 4 | 56 | 12 | |||
110894 | 126374 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3757 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996853.6734 | 2115303.27784 | 37.7880382270258 | -122.454710571336 | (37.7880382270258, -122.454710571336) | 11 | 6 | 1 | 54 | 31 | |||
114349 | 223266 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3881 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002605.58084 | 2103542.10269 | 37.7560731891449 | -122.433968983607 | (37.7560731891449, -122.433968983607) | 2 | 4 | 5 | 28862 | 22 | |||
116877 | 12818 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2141 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2000 12:00:00 AM | 16 | 3X3 | 5988750.18226 | 2114650.45145 | 37.7857776147233 | -122.482699025485 | (37.7857776147233, -122.482699025485) | 11 | 6 | 2 | 55 | 26 | ||
125762 | 206496 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 15 Belmont Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5996727.68548 | 2106141.74886 | 37.7628758346688 | -122.454484388265 | (37.7628758346688, -122.454484388265) | 15 | 5 | 11 | 29492 | 12 | |||
127534 | 45574 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3566 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51158 | 5997787.4874 | 2115153.06832 | 37.7876793093869 | -122.451468917382 | (37.7876793093869, -122.451468917382) | 11 | 6 | 1 | 54 | 31 | |
128166 | 88641 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 100x Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51601 | 6012818.3 | 2113762.9 | 37.7847114789743 | -122.399367240893 | (37.7847114789743, -122.399367240893) | 6 | 2 | 9 | 28853 | 6 | ||
128937 | 123593 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 101 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994558.95519 | 2114839.38898 | 37.786632625622 | -122.462616168612 | (37.786632625622, -122.462616168612) | 11 | 6 | 1 | 54 | 11 | |||
131077 | 41939 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 642 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767709 | 5994427.38588 | 2111124.12171 | 37.7764239238408 | -122.4628017345 | (37.7764239238408, -122.4628017345) | 11 | 6 | 2 | 54 | 11 |
131812 | 223017 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1540 Willard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996935.82836 | 2105853.49719 | 37.7620963041191 | -122.453743682342 | (37.7620963041191, -122.453743682342) | 15 | 5 | 11 | 29492 | 12 | |||
132412 | 123224 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 768 09th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993218.23533 | 2110273.3876 | 37.7740183200914 | -122.466922630996 | (37.7740183200914, -122.466922630996) | 11 | 6 | 2 | 54 | 11 | |||
132715 | 88640 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 100x Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51601 | 6012818.3 | 2113762.9 | 37.7847114789743 | -122.399367240893 | (37.7847114789743, -122.399367240893) | 6 | 2 | 9 | 28853 | 6 | ||
137226 | 126372 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3892 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5996279.83819 | 2114944.52745 | 37.787020263712 | -122.456669972856 | (37.787020263712, -122.456669972856) | 11 | 6 | 1 | 54 | 31 | |||
138901 | 68459 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 219 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 4 | Permit Number 32321 | 5991488.68576 | 2113942.6915 | 37.7839932465936 | -122.473173033293 | (37.7839932465936, -122.473173033293) | 11 | 6 | 2 | 54 | 26 | |
138985 | 32835 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 4070 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/2016 12:00:00 AM | 3 | Permit Number 778362 | 6003433.50304197 | 2100708.71141844 | 37.7483403143389 | -122.430903548765 | (37.7483403143389, -122.430903548765) | 2 | 4 | 5 | 28862 | 22 | |
143726 | 43757 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 166 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 5 | Permit Number 43393 | 5990560.46951 | 2114298.77525 | 37.7849171656536 | -122.476410309146 | (37.7849171656536, -122.476410309146) | 11 | 6 | 2 | 54 | 26 | |
145767 | 123225 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 768 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993217.94284 | 2110263.63635 | 37.7739915288904 | -122.466922933716 | (37.7739915288904, -122.466922933716) | 11 | 6 | 2 | 54 | 11 | |||
146394 | 88638 | Permitted Site 7 | Crateagus spp :: Hawthorn 130 | 100x Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51601 | 6012818.3 | 2113762.9 | 37.7847114789743 | -122.399367240893 | (37.7847114789743, -122.399367240893) | 6 | 2 | 9 | 28853 | 6 | |||
149668 | 43799 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 222 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 3 | Permit Number 43429 | 5988714.48726 | 2113826.97195 | 37.7835144962914 | -122.482762149176 | (37.7835144962914, -122.482762149176) | 11 | 6 | 2 | 55 | 26 | |
152797 | 123436 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 736 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5995067.20225 | 2110564.18838 | 37.7749233252865 | -122.460547860539 | (37.7749233252865, -122.460547860539) | 11 | 6 | 2 | 54 | 11 | |||
156132 | 68662 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 272 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 4 | Permit Number 32569 | 5993715.18604 | 2113695.6961 | 37.7834437274924 | -122.465452268537 | (37.7834437274924, -122.465452268537) | 11 | 6 | 2 | 54 | 11 | |
158953 | 223265 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3881 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002589.4167 | 2103539.41006 | 37.7560648784957 | -122.434024692088 | (37.7560648784957, -122.434024692088) | 2 | 4 | 5 | 28862 | 22 | |||
161151 | 223019 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1540 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996941.36479 | 2105830.04553 | 37.7620322292239 | -122.453722840535 | (37.7620322292239, -122.453722840535) | 15 | 5 | 11 | 29492 | 12 | |||
162089 | 43796 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 166 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 5 | Permit Number 43426 | 5988700.72724 | 2114234.65523 | 37.7846330787147 | -122.482839640553 | (37.7846330787147, -122.482839640553) | 11 | 6 | 2 | 55 | 26 | |
163257 | 223015 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1540 Willard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996933.82001 | 2105869.54107 | 37.7621402413964 | -122.453751787019 | (37.7621402413964, -122.453751787019) | 15 | 5 | 11 | 29492 | 12 | |||
170908 | 190923 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1402 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013389.64029 | 2105706.32437 | 37.762621766291 | -122.396825553151 | (37.762621766291, -122.396825553151) | 14 | 3 | 8 | 28856 | 29 | |||
172974 | 69227 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 508 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 5 | Permit Number 33279 | 6005277.2347 | 2111332.9871 | 37.7776163505901 | -122.42528387691 | (37.7776163505901, -122.42528387691) | 7 | 9 | 11 | 28852 | 10 | |
178854 | 114031 | Undocumented 4 | Crateagus spp :: Hawthorn 130 | 1 HANGAH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010635 | 2117072 | 37.7936755489769 | -122.407154109442 | (37.7936755489769, -122.407154109442) | 3 | 1 | 10 | 28857 | 4 | ||||
180692 | 51346 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 559 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/2004 12:00:00 AM | 3 | Permit Number 47693 | 5989994.83721 | 2111550.94046 | 37.7773395563497 | -122.478166218166 | (37.7773395563497, -122.478166218166) | 11 | 6 | 2 | 55 | 26 | |
183378 | 123319 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 642 05th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994427.99762 | 2111142.77405 | 37.776475173427 | -122.462800971807 | (37.776475173427, -122.462800971807) | 11 | 6 | 2 | 54 | 11 | |||
185090 | 43676 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 616 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 5 | Permit Number 43319 | 5995350.82711 | 2111325.81395 | 37.7770308605171 | -122.459621923854 | (37.7770308605171, -122.459621923854) | 11 | 6 | 2 | 54 | 11 | |
186320 | 126373 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 3749 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996893.50413 | 2115309.03645 | 37.7880563231774 | -122.454573181 | (37.7880563231774, -122.454573181) | 11 | 6 | 1 | 54 | 31 | |||
190442 | 12801 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 2050 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2001 12:00:00 AM | 3 | 4 | 5989040.29385 | 2114718.07128 | 37.7859801539539 | -122.481700287531 | (37.7859801539539, -122.481700287531) | 11 | 6 | 1 | 55 | 33 | ||
86001 | 190922 | DPW Maintained 1 | Crateagus spp :: Hawthorn 130 | 1301 Minnesota St | 24 | Front Yard : Yard | Tree | Private 2 | 4 | 6015379.17915 | 2102426.70391 | 37.7537271672848 | -122.389715318802 | (37.7537271672848, -122.389715318802) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );