trees

493 rows where qSpecies_id = 133

✎ View and edit SQL

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)
127094 31914 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2286 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 4   Permit Number 42223 5991731.01436 2099907.3159 37.7454698746265 -122.471311701978 (37.7454698746265, -122.471311701978) 1 8 4 29491 40
127288 206690 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 616 Los Palmos Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5996131.5818 2095962.98776 37.7348932897948 -122.45581025245 (37.7348932897948, -122.45581025245) 9 7 4 59 40
127586 206603 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5995045.25769 2100752.48094 37.7479816442318 -122.459912864313 (37.7479816442318, -122.459912864313) 1 8 4 29491 40
128090 65685 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 265 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/1990 12:00:00 AM     Permit Number 28609 5995018.52111157 2095862.640949 37.7345538192853 -122.459651200361 (37.7345538192853, -122.459651200361) 9 7 4 59 40
128208 84505 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 650 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.7755755804602 -122.410668559049 (37.7755755804602, -122.410668559049) 8 2 9 28853 34
128211 223056 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 191 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004346.64046 2097517.13802 37.7396286835145 -122.427518598925 (37.7396286835145, -122.427518598925) 2 7 5 63 7
128259 206521 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2290 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991723.00262 2099864.63418 37.7453522181485 -122.471336295754 (37.7453522181485, -122.471336295754) 1 8 4 29491 40
128619 206610 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 49 Sola Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5994851.29052 2100738.8321 37.7479330107067 -122.46058260112 (37.7479330107067, -122.46058260112) 1 8 4 29491 40
128797 206534 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 665 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5995362.10243 2093779.40423 37.7288535085691 -122.458312597175 (37.7288535085691, -122.458312597175) 9 7 4 28861 40
129133 206670 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 15 Sotelo Ave 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994011.71818 2100897.82655 37.7483212318599 -122.463497320046 (37.7483212318599, -122.463497320046) 1 8 4 29491 40
129309 206564 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2044 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993156.7665 2101574.66751 37.7501303674196 -122.466502884014 (37.7501303674196, -122.466502884014) 1 8 4 29491 12
129524 117509 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 300x HANOVER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999715 2086521 37.7091727618039 -122.442743399736 (37.7091727618039, -122.442743399736) 9 7 6 28861 5
130315 50527 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista East Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/2003 12:00:00 AM     Permit Number 47168 6001454.91140265 2108251.59060829 37.7689389222278 -122.438285751105 (37.7689389222278, -122.438285751105) 15 5 5 29492 3
130434 206512 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1023 Lawton St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5990980.22345 2104481.19226 37.7579850830548 -122.474241481884 (37.7579850830548, -122.474241481884) 1 8 4 56 12
131143 199671 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1903 Keith St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015210.0019 2093419.3228 37.7289853719934 -122.389671313679 (37.7289853719934, -122.389671313679) 10 3 8 58 1
132029 121560 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 400X Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6003675 2102779 37.7540385213778 -122.430216135756 (37.7540385213778, -122.430216135756) 2 4 5 28862 22
132095 206645 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994475.58114 2100840.87711 37.7481915783923 -122.461889176638 (37.7481915783923, -122.461889176638) 1 8 4 29491 40
132506 223049 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 45 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002666.83309 2105626.92623 37.7618010890622 -122.433906166852 (37.7618010890622, -122.433906166852) 15 4 5 28862 3
132897 61351 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 2435 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33180 5983606.72733818 2098575.39773775 37.7413394866654 -122.499305352528 (37.7413394866654, -122.499305352528) 1 8 3 29491 35
133368 247587 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 800 Tompkins Ave 8 Front Yard : Yard Tree Private 2     6     6008949.04431 2096428.80776 37.7368996080238 -122.411528533315 (37.7368996080238, -122.411528533315) 10 7 7 28859 2
133547 206684 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 647 Los Palmos Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996011.49185 2096001.54035 37.7349922529962 -122.456228229446 (37.7349922529962, -122.456228229446) 9 7 4 59 40
133810 206583 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Dorantes Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5993643.85712 2099778.24608 37.7452259461282 -122.464688076401 (37.7452259461282, -122.464688076401) 1 8 4 29491 40
133847 206553 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 352 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5994206.92878 2101186.05332 37.74912387497 -122.462843199074 (37.74912387497, -122.462843199074) 1 8 4 29491 40
133928 206594 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 135 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5995087.43611 2100841.34046 37.7482280558 -122.459773449604 (37.7482280558, -122.459773449604) 1 8 4 29491 40
134005 81908 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1601 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50503 5991112.7626616 2104504.97362674 37.7580580577361 -122.47378484454 (37.7580580577361, -122.47378484454) 1 8 4 56 12
134483 34301 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1257 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38089 6010337.06875453 2101902.38195398 37.7520066112995 -122.407115203053 (37.7520066112995, -122.407115203053) 10 4 7 28859 19
134750 206557 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 517 Laguna Honda Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5995503.23656 2100160.44134 37.7463823798599 -122.458286357642 (37.7463823798599, -122.458286357642) 1 5 4 59 40
134978 38592 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1618 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 2   Permit Number 40547 6015152.7308 2094735.8699 37.7325971695789 -122.389961235194 (37.7325971695789, -122.389961235194) 10 3 8 58 1
136667 206535 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 665 Miramar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5995362.41808 2093767.65006 37.7288212525964 -122.458310655534 (37.7288212525964, -122.458310655534) 9 7 4 28861 40
137146 65803 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 2245 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM     Permit Number 28771 5991002.61160286 2100125.98772668 37.7460281288142 -122.4738463283 (37.7460281288142, -122.4738463283) 1 8 4 29491 40
137361 206699 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   5998907.63682 2095545.72944 37.7339065275492 -122.446182491946 (37.7339065275492, -122.446182491946) 9 7 4 59 40
137454 45121 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2001 12:00:00 AM     Permit Number 43980 6001449.9 2108254.9 37.7689477239633 -122.438303322299 (37.7689477239633, -122.438303322299) 15 5 5 29492 3
137546 206604 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5995043.01031 2100739.53906 37.747945979831 -122.45991969824 (37.747945979831, -122.45991969824) 1 8 4 29491 40
137974 24556 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 416 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3   6007294.81147 2097256.19199 37.739078494466 -122.417306578558 (37.739078494466, -122.417306578558) 2 7 7 28859 2
138408 82688 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1875 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM 2 3x3 Permit Number 51093 5984404.185 2102433.03 37.7519782422196 -122.496832705614 (37.7519782422196, -122.496832705614) 1 8 3 56 35
138610 31913 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 2281 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42222 5991689.25479737 2099914.99470572 37.7454885429424 -122.471456657987 (37.7454885429424, -122.471456657987) 1 8 4 29491 40
139066 206607 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2 Sola Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994975.69537 2100714.97086 37.7478746501056 -122.460150689128 (37.7478746501056, -122.460150689128) 1 8 4 29491 40
139505 206673 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 370 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995261.57654 2095226.10502 37.7328200206111 -122.458764814062 (37.7328200206111, -122.458764814062) 9 7 4 59 40
139743 223040 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 567 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007699.61186 2096703.50741 37.7375837106174 -122.415867833228 (37.7375837106174, -122.415867833228) 2 7 7 28859 2
140400 223031 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 38 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5998471.48427 2106911.98504 37.7650905653978 -122.448508695418 (37.7650905653978, -122.448508695418) 15 5 11 29492 9
140646 206538 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 399 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5994103.27732 2101446.93652 37.7498342233673 -122.463220551898 (37.7498342233673, -122.463220551898) 1 8 4 29491 40
140870 43490 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 731 Banks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2000 12:00:00 AM     Permit Number 43170 6008504.61569086 2095547.09041526 37.7344536647683 -122.413002801242 (37.7344536647683, -122.413002801242) 10 7 7 28859 2
140979 206548 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Dorantes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993741.10567 2099827.07051 37.7453656117262 -122.464355354239 (37.7453656117262, -122.464355354239) 1 8 4 29491 40
141735 61288 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 402 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/05/1986 12:00:00 AM     Permit Number 23284 6007176.62571904 2097268.48245659 37.7391055913487 -122.417716082945 (37.7391055913487, -122.417716082945) 2 7 7 28859 2
142629 51536 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 4138 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/2005 12:00:00 AM     Permit Number 47837 6002788.00139397 2104180.95255656 37.7578376687282 -122.433383762609 (37.7578376687282, -122.433383762609) 2 4 5 28862 3
142812 24587 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 804 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/1996 12:00:00 AM 18 3X3   6008146.87115 2097150.77398 37.738836941075 -122.414353078142 (37.738836941075, -122.414353078142) 2 7 7 28859 2
143896 62940 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 355 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/05/1986 12:00:00 AM     Permit Number 23321 6006807.32064873 2097065.68374167 37.7385279621224 -122.418978594844 (37.7385279621224, -122.418978594844) 2 7 7 28859 2
144447 223037 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 203 Surrey St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6002071.56022 2096098.27883 37.7356038810064 -122.435283373351 (37.7356038810064, -122.435283373351) 2 7 5 63 7
144577 206643 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 196 Castenada Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994392.21173 2100761.61427 37.7479691427812 -122.462171715751 (37.7479691427812, -122.462171715751) 1 8 4 29491 40
144713 206616 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 198 Vasquez Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft Permit Number 779324 5994742.56026 2099334.68039 37.7440713065495 -122.460856833195 (37.7440713065495, -122.460856833195) 1 8 4 59 40
144997 69148 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 2478 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33183 5983358.82084368 2098279.8149921 37.7405133500226 -122.500140666527 (37.7405133500226, -122.500140666527) 1 8 3 29491 35
146015 68553 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 724 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/1996 12:00:00 AM     Permit Number 32442 5982311.44586787 2110822.57803578 37.7748906946614 -122.50469113477 (37.7748906946614, -122.50469113477) 11 6 2 55 26
146225 206556 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 32 Sotelo Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   5993935.86279 2101082.16601 37.7488230103837 -122.463773001819 (37.7488230103837, -122.463773001819) 1 8 4 29491 40
146470 63003 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1239 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1986 12:00:00 AM 3   Permit Number 23411 5983024.3565 2106665.5091 37.763518489811 -122.501917412441 (37.763518489811, -122.501917412441) 1 8 3 56 35
146731 223028 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 42 Rivoli St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5998401.23132 2106021.8866 37.7626425622232 -122.448687567871 (37.7626425622232, -122.448687567871) 15 5 11 29492 9
148444 206651 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994510.63767 2100971.03236 37.7485509699531 -122.461777389118 (37.7485509699531, -122.461777389118) 1 8 4 29491 40
148811 206520 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2290 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991725.72943 2099875.90905 37.7453833337792 -122.471327688331 (37.7453833337792, -122.471327688331) 1 8 4 29491 40
149638 223046 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 77 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6005471.50149 2099604.561 37.7454238329391 -122.423777694396 (37.7454238329391, -122.423777694396) 2 7 5 28859 22
149954 206654 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 45 Alton Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994247.90783 2101537.24109 37.7500905076701 -122.462726967074 (37.7500905076701, -122.462726967074) 1 8 4 29491 40
150332 31296 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 431 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/04/1995 12:00:00 AM 4   Permit Number 34940 5991578.61319 2097704.4347 37.7394125098801 -122.471678172112 (37.7394125098801, -122.471678172112) 1 8 4 29491 40
150743 206549 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 308 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5994338.43004 2100748.81738 37.7479309089808 -122.462356761175 (37.7479309089808, -122.462356761175) 1 8 4 29491 40
150864 206565 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2679 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991740.00006 2097213.72231 37.7380744742606 -122.471084432514 (37.7380744742606, -122.471084432514) 1 8 4 29491 40
151204 52741 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 409@ ALTON Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2006 12:00:00 AM     Permit Number 48790 5994026.96721275 2101530.61038788 37.7500595741159 -122.463490505234 (37.7500595741159, -122.463490505234) 1 8 4 29491 40
151607 206507 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1985 10th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   5993144.62205 2101960.97627 37.751190371338 -122.466572955586 (37.751190371338, -122.466572955586) 1 8 4 29491 12
151781 200073 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1500 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955) 10 3 8 58 1
151854 223032 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 281 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006256.18709 2096109.4549 37.7358713204894 -122.420816284439 (37.7358713204894, -122.420816284439) 2 7 7 28859 2
151946 65810 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 2290 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM     Permit Number 28778 5991729.56779327 2099841.10556299 37.7452879943861 -122.471311880679 (37.7452879943861, -122.471311880679) 1 8 4 29491 40
152214 206574 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 120 Montalvo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993698.09593 2099619.5133 37.7447932328356 -122.464489006068 (37.7447932328356, -122.464489006068) 1 8 4 29491 40
152397 78332 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/01/2009 12:00:00 AM 3 3x3 Permit Number 52305 6014106.86245 2094390.75811 37.7315915044312 -122.393552939125 (37.7315915044312, -122.393552939125) 10 3 8 58 1
152595 60133 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 214 Roanoke St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/2012 12:00:00 AM     Permit Number 768747 6003532.52706643 2096003.65082334 37.7354269125656 -122.430225504542 (37.7354269125656, -122.430225504542) 2 7 5 63 7
152874 206525 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 35 Madrone Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992946.5083 2098897.01812 37.7427660898953 -122.46703531413 (37.7427660898953, -122.46703531413) 1 8 4 59 40
152981 62937 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 324 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/05/1986 12:00:00 AM     Permit Number 23318 6006824.33458428 2097207.20889429 37.7389175168089 -122.418929803603 (37.7389175168089, -122.418929803603) 2 7 7 28859 2
153668 51360 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878962 (37.7317044268964, -122.39352878962) 10 3 8 58 1
154235 94070 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 616 Los Palmos Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2010 12:00:00 AM   2x4 Permit Number 53462 5996098 2095984 37.7349490569452 -122.455927874303 (37.7349490569452, -122.455927874303) 9 7 4 59 40
154287 41697 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1 Mizpah St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618) 2 7 5 63 7
155068 255587 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 157 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006708 2105213 37.760893044988 -122.419899978675 (37.760893044988, -122.419899978675) 2 4 7 28859 19
155079 206544 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 337 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994178.74316 2101030.22278 37.7486943803622 -122.462929360401 (37.7486943803622, -122.462929360401) 1 8 4 29491 40
155351 62920 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 578 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/05/1986 12:00:00 AM     Permit Number 23300 6007655.13385737 2096670.74814693 37.7374912602593 -122.41601929598 (37.7374912602593, -122.41601929598) 2 7 7 28859 2
155431 206656 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 45 Alton Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994277.82387 2101540.85875 37.7501021637853 -122.46262377888 (37.7501021637853, -122.46262377888) 1 8 4 29491 40
155475 206563 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2047 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993157.06576 2101533.95115 37.750018588 -122.466498890138 (37.750018588, -122.466498890138) 1 8 4 29491 12
155534 206514 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1023 Lawton St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5991006.3222 2104484.4348 37.7579954981234 -122.474151458838 (37.7579954981234, -122.474151458838) 1 8 4 56 12
156321 206611 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 49 Sola Ave 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994869.30829 2100730.97603 37.7479124764813 -122.460519727717 (37.7479124764813, -122.460519727717) 1 8 4 29491 40
156398 41696 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1 Mizpah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42148 6001073.51924875 2096662.39464483 37.7370960833617 -122.43877438618 (37.7370960833617, -122.43877438618) 2 7 5 63 7
156649 251254 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 330 09th Ave 1 unknown : Cutout Tree MTA 3       3x3   5993109 2113253 37.7821932251036 -122.467517213871 (37.7821932251036, -122.467517213871) 11 6 2 54 11
157023 206592 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Montalvo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993721.8716 2099672.65516 37.744940517497 -122.464410652624 (37.744940517497, -122.464410652624) 1 8 4 29491 40
157044 206570 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 4 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5993230.10677 2099675.67045 37.7449204374235 -122.46611129043 (37.7449204374235, -122.46611129043) 1 8 4 29491 40
157257 223043 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 4107 Ogden Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008381.78974 2096055.87054 37.7358437688638 -122.413463422917 (37.7358437688638, -122.413463422917) 10 7 7 28859 2
158105 206674 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 300 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995208.64941 2095407.77696 37.7333158051714 -122.458960944512 (37.7333158051714, -122.458960944512) 9 7 4 59 40
158137 206662 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 390 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994173.63187 2101468.04914 37.7498962460271 -122.462978796147 (37.7498962460271, -122.462978796147) 1 8 4 29491 40
158228 206541 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 375 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994147.31458 2101302.53521 37.7494402708691 -122.463057794403 (37.7494402708691, -122.463057794403) 1 8 4 29491 40
158231 190925 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 651 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011562.19337 2105343.91486 37.761524784975 -122.40312057635 (37.761524784975, -122.40312057635) 10 3 8 28856 29
159238 206571 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 51 Cortes Ave 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993219.18082 2099666.63445 37.7448949964991 -122.466148413523 (37.7448949964991, -122.466148413523) 1 8 4 29491 40
159418 51449 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 326 Bocana St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2004 12:00:00 AM     Permit Number 47765 6006818.05257651 2097195.51767411 37.7388850615796 -122.41895069494 (37.7388850615796, -122.41895069494) 2 7 7 28859 2
159595 206508 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1023 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5990927.20691 2104481.04629 37.7579816107755 -122.474424823051 (37.7579816107755, -122.474424823051) 1 8 4 56 12
160622 206650 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 7 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994518.14401 2100922.4103 37.748417898169 -122.461747907542 (37.748417898169, -122.461747907542) 1 8 4 29491 40
160913 206649 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 6 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994518.46873 2100904.00828 37.7483673895631 -122.461745450587 (37.7483673895631, -122.461745450587) 1 8 4 29491 40
160958 46178 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 36 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2001 12:00:00 AM     Permit Number 44505 5998475.49358611 2106915.81544951 37.7651013119743 -122.448495104116 (37.7651013119743, -122.448495104116) 15 5 11 29492 9
161052 206555 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 47 Sotelo Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5993893.29504 2101174.89341 37.7490751632062 -122.463926929805 (37.7490751632062, -122.463926929805) 1 8 4 29491 40
161629 206542 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 351 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994154.36407 2101104.38684 37.7488966118001 -122.46301904262 (37.7488966118001, -122.46301904262) 1 8 4 29491 40
162209 206598 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5995052.00135 2100847.98673 37.7482442669627 -122.459896462476 (37.7482442669627, -122.459896462476) 1 8 4 29491 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);