493 rows where qSpecies_id = 133 sorted by SiteOrder descending

View and edit SQL

These facets timed out: PlotSize

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)
6774 249677 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2400 Baker St 9 Front Yard : Yard Tree Private 2     9     5999741.70445 2117184.69909 37.7933693451834 -122.444853823654 (37.7933693451834, -122.444853823654) 13 9 1 57 27
101700 247588 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 800 Tompkins Ave 9 Front Yard : Yard Tree Private 2     6     6008943.01163 2096440.06729 37.7369301858647 -122.411550186315 (37.7369301858647, -122.411550186315) 10 7 7 28859 2
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
70530 206606 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 7 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5995035.92285 2100721.97488 37.747897345392 -122.459942934033 (37.747897345392, -122.459942934033) 1 8 4 29491 40
78140 53145 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1498@ KEITH Underwood Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49074 6015150.01654287 2093336.52012549 37.7287546860169 -122.389872907792 (37.7287546860169, -122.389872907792) 10 3 8 58 1
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
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
8606 190946 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 40 Bluxome St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6013405.51497 2110852.0091 37.7767515500726 -122.397131477343 (37.7767515500726, -122.397131477343) 6 2 9 28856 34
96906 206702 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   5998869.22619 2095565.73707 37.7339592701108 -122.446316727449 (37.7339592701108, -122.446316727449) 9 7 4 59 40
117905 206513 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1023 Lawton St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5990992.34085 2104483.78156 37.757992894562 -122.47419976413 (37.757992894562, -122.47419976413) 1 8 4 56 12
126897 45118 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista Ave East 6 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
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
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
164367 206605 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5995038.86988 2100730.57279 37.7479211225827 -122.459933366148 (37.7479211225827, -122.459933366148) 1 8 4 29491 40
28527 206648 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 5 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994513.85188 2100887.12446 37.748320765087 -122.461760191398 (37.748320765087, -122.461760191398) 1 8 4 29491 40
40425 115540 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
84636 82952 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
94644 45119 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista Ave East 5 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
108186 206701 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   5998876.80466 2095558.49789 37.7339398258586 -122.446290005877 (37.7339398258586, -122.446290005877) 9 7 4 59 40
114669 206502 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 245 Lawton St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5993453.26762 2104570.92091 37.7583744121607 -122.465695235269 (37.7583744121607, -122.465695235269) 1 8 4 56 12
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
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
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
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
162377 121664 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
167985 206518 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1019 Lawton St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5991072.98938 2104484.60902 37.7579998382313 -122.473920910448 (37.7579998382313, -122.473920910448) 1 8 4 56 12
194061 206612 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 49 Sola Ave 5 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5994889.66342 2100721.49656 37.7478876192364 -122.460448654307 (37.7478876192364, -122.460448654307) 1 8 4 29491 40
19807 200076 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1500 Van Dyke Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6014887.9102 2093187.7857 37.7283317520978 -122.390768643797 (37.7283317520978, -122.390768643797) 10 3 8 58 1
28142 121663 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
32357 126382 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1001 Vallejo St 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 4ft   6008670.39988 2118624.74661 37.7978288673746 -122.414061717575 (37.7978288673746, -122.414061717575) 5 1 10 308 21
34205 45120 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista Ave East 4 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
44899 51539 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 4138 20th St 4 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
45592 206647 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5994503.49405 2100867.53113 37.748266370491 -122.461794587759 (37.748266370491, -122.461794587759) 1 8 4 29491 40
48224 206660 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 41 Alton Ave 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994227.71262 2101539.78712 37.7500963352778 -122.462796987411 (37.7500963352778, -122.462796987411) 1 8 4 29491 40
52704 94078 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 629 Los Palmos Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2010 12:00:00 AM   2x4 Permit Number 53465 5996116 2095941 37.734832022473 -122.455862534884 (37.734832022473, -122.455862534884) 9 7 4 59 40
52801 206552 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 308 Pacheco St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 6ft   5994313.1172 2100803.87721 37.7480806317257 -122.462448284279 (37.7480806317257, -122.462448284279) 1 8 4 29491 40
55106 102412 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 55X Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2           6000310.8 2109142 37.7713186232103 -122.442307075209 (37.7713186232103, -122.442307075209) 15 5 11 29492 9
63353 206511 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1023 Lawton St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5990966.24876 2104480.85465 37.7579833464788 -122.474289787164 (37.7579833464788, -122.474289787164) 1 8 4 56 12
72234 43002 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 205X Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42873 6005609.30796774 2109736.9244771 37.7732527046739 -122.424021592666 (37.7732527046739, -122.424021592666) 7 9 11 28852 10
73036 206517 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1019 Lawton St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5991060.29058 2104484.56084 37.7579989703891 -122.473964824336 (37.7579989703891, -122.473964824336) 1 8 4 56 12
74334 244873 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 49 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000342.3248 2109115.5777 37.7712478709156 -122.442196132801 (37.7712478709156, -122.442196132801) 15 5 11 29492 9
75364 115539 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
95037 206600 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Magellan Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5995054.43703 2100813.29817 37.7481491609747 -122.459885527604 (37.7481491609747, -122.459885527604) 1 8 4 29491 40
111783 206669 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 15 Sotelo Ave 4 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994007.62455 2100906.4247 37.7483446043367 -122.463512099503 (37.7483446043367, -122.463512099503) 1 8 4 29491 40
112891 82953 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
114209 206572 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 51 Cortes Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993215.16949 2099646.04946 37.7448382439064 -122.466160788211 (37.7448382439064, -122.466160788211) 1 8 4 29491 40
114457 206501 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 245 Lawton St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5993462.44278 2104571.82213 37.7583774159051 -122.465663569242 (37.7583774159051, -122.465663569242) 1 8 4 56 12
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
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
165991 206681 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 657 Los Palmos Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995960.60425 2096012.63655 37.735019799206 -122.456404966934 (37.735019799206, -122.456404966934) 9 7 4 59 40
180598 206700 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   5998900.28229 2095547.61505 37.7339112849776 -122.446208054284 (37.7339112849776, -122.446208054284) 9 7 4 59 40
1063 32734 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 808 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37117 5995081.95862964 2089664.82981262 37.7175397705127 -122.458983271916 (37.7175397705127, -122.458983271916) 9 8 6 28861 24
19680 206561 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 355 Yerba Buena Ave 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5995302.34368 2095238.16689 37.732855482695 -122.458624745542 (37.732855482695, -122.458624745542) 9 7 4 59 40
22339 206516 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1019 Lawton St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5991047.26108 2104483.88717 37.7579963659448 -122.474009836278 (37.7579963659448, -122.474009836278) 1 8 4 56 12
27348 206661 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 390 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994161.93741 2101486.33597 37.7499457833913 -122.463020562465 (37.7499457833913, -122.463020562465) 1 8 4 29491 40
32203 206500 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 245 Lawton St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5993474.54652 2104572.66216 37.7583804205467 -122.465621770525 (37.7583804205467, -122.465621770525) 1 8 4 56 12
35026 206591 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Montalvo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993709.62503 2099698.37793 37.7450104397813 -122.464454865994 (37.7450104397813, -122.464454865994) 1 8 4 29491 40
37635 206573 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 51 Cortes Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993216.90415 2099626.41246 37.7447844257663 -122.466153363383 (37.7447844257663, -122.466153363383) 1 8 4 29491 40
40920 206659 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 41 Alton Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5994198.61036 2101541.1054 37.750098278721 -122.462897719553 (37.750098278721, -122.462897719553) 1 8 4 29491 40
42334 206608 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2 Sola Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5994960.81371 2100721.5804 37.7478919422595 -122.460202627649 (37.7478919422595, -122.460202627649) 1 8 4 29491 40
43073 206510 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1023 Lawton St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5990951.63934 2104480.53076 37.7579816107816 -122.474340288587 (37.7579816107816, -122.474340288587) 1 8 4 56 12
47801 206671 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 370 Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995266.43425 2095204.88442 37.732762033223 -122.458746484089 (37.732762033223, -122.458746484089) 9 7 4 59 40
48275 41698 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1 Mizpah St 3 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
49032 206680 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 657 Los Palmos Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995948.68471 2096013.62894 37.7350218397753 -122.456446248507 (37.7350218397753, -122.456446248507) 9 7 4 59 40
52088 126383 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1116 Greenwich St 3 Front Yard : Yard Tree Private 2     4     6007504.98606 2119897.57415 37.801258207159 -122.418184672095 (37.801258207159, -122.418184672095) 5 1 1 28858 32
57243 206633 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 145 Castenada Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994552.30711 2100925.23177 37.7484276117632 -122.461629977659 (37.7484276117632, -122.461629977659) 1 8 4 29491 40
70998 206529 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 13 Madrone Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992989.73242 2099015.25675 37.7430932380525 -122.466894452432 (37.7430932380525, -122.466894452432) 1 8 4 59 40
71121 206526 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 35 Madrone Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992953.91132 2098913.47299 37.7428116981042 -122.467010912843 (37.7428116981042, -122.467010912843) 1 8 4 59 40
72984 206596 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 135 Magellan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5995085.45283 2100859.88169 37.7482788513041 -122.459781650511 (37.7482788513041, -122.459781650511) 1 8 4 29491 40
77345 206554 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 47 Sotelo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5993895.61602 2101166.11299 37.7490511881613 -122.463918266634 (37.7490511881613, -122.463918266634) 1 8 4 29491 40
81352 206602 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 160 Magellan Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5995047.85902 2100763.4476 37.7480119055303 -122.459904663381 (37.7480119055303, -122.459904663381) 1 8 4 29491 40
83405 206668 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 15 Sotelo Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993998.36893 2100916.34697 37.7483713150869 -122.463544824955 (37.7483713150869, -122.463544824955) 1 8 4 29491 40
85017 51537 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 4138 20th St 3 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
86826 121662 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
90233 108929 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 12x MacOndray Ln 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6008556.45633 2119171.57464 37.7993239210113 -122.414494709684 (37.7993239210113, -122.414494709684) 5 1 10 308 32
101316 94077 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 629 Los Palmos Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2010 12:00:00 AM   2x4 Permit Number 53465 5996116 2095941 37.734832022473 -122.455862534884 (37.734832022473, -122.455862534884) 9 7 4 59 40
103424 206620 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2105 09th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5993657.15968 2101227.85905 37.7492069822304 -122.464747327347 (37.7492069822304, -122.464747327347) 1 8 4 29491 40
106812 206577 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 215 Dorantes Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5993636.26419 2099712.16168 37.7450440573323 -122.464709533316 (37.7450440573323, -122.464709533316) 1 8 4 29491 40
109919 206599 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 150 Magellan Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5995053.98462 2100829.4455 37.7481934714657 -122.459888261529 (37.7481934714657, -122.459888261529) 1 8 4 29491 40
114722 218122 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 45 Lopez Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5994032.10421 2100668.86964 37.7476937487685 -122.463410213512 (37.7476937487685, -122.463410213512) 1 8 4 29491 40
122610 176075 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 100 Capistrano Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6001444.80034 2093622.381 37.7287700227166 -122.4372730928 (37.7287700227166, -122.4372730928) 9 7 6 28861 25
123072 206530 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 175 Garcia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5994631.6545 2099433.40276 37.7443359914089 -122.461247472601 (37.7443359914089, -122.461247472601) 1 8 4 59 40
123636 182596 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 945 Rivera St 3 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5990197.9307 2100380.5725 37.7466805119975 -122.47664737489 (37.7466805119975, -122.47664737489) 1 8 3 29491 35
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
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
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
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
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
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
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
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
164255 126380 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1136 Havens St 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 7ft   6007510.81799 2119357.46903 37.7997755425663 -122.418126178374 (37.7997755425663, -122.418126178374) 5 1 1 28858 32
164265 115538 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
167164 82954 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3   6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
170391 200075 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1500 Van Dyke Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6014900.2728 2093175.985 37.7283000356482 -122.390725081061 (37.7283000356482, -122.390725081061) 10 3 8 58 1
172217 45117 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista Ave East 3 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
176132 206578 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 275 Dorantes Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993312.03833 2099686.0969 37.7449537923783 -122.465828745912 (37.7449537923783, -122.465828745912) 1 8 4 29491 40
178097 206551 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 308 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5994320.14066 2100781.15308 37.7480186414603 -122.462422349606 (37.7480186414603, -122.462422349606) 1 8 4 29491 40
181962 206688 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 629 Los Palmos Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5996101.05251 2095948.39142 37.7348514596286 -122.455914747394 (37.7348514596286, -122.455914747394) 9 7 4 59 40
192879 206646 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 180 Castenada Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994489.71886 2100854.37735 37.7482294605322 -122.461841267977 (37.7482294605322, -122.461841267977) 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)
);