trees

493 rows where qSpecies_id = 133 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

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)
56077 51543 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 330 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/2006 12:00:00 AM     Permit Number 47842 6006500.80110502 2104175.14616456 37.7580316646871 -122.4205429163 (37.7580316646871, -122.4205429163) 2 4 7 28859 19
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
178314 223033 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 281 Richland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006248.27078 2096110.49551 37.7358737315714 -122.420843728155 (37.7358737315714, -122.420843728155) 2 7 7 28859 2
92618 223022 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 6ft   6006257.51967 2099541.04409 37.7452937702941 -122.42105525589 (37.7452937702941, -122.42105525589) 2 7 7 28859 2
18410 68121 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 101 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31868 6006245.31002458 2099503.96919514 37.7451912827439 -122.421094842871 (37.7451912827439, -122.421094842871) 2 7 7 28859 2
4563 223021 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 109 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006234.71683 2099501.18451 37.7451830394575 -122.421131274692 (37.7451830394575, -122.421131274692) 2 7 7 28859 2
99489 68122 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 109 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31870 6006226.82006776 2099469.59440232 37.7450958550009 -122.42115633768 (37.7450958550009, -122.42115633768) 2 7 7 28859 2
178830 251786 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 300 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2017 12:00:00 AM 3 3x3   6006195 2098242 37.7417233638646 -122.421179213365 (37.7417233638646, -122.421179213365) 2 7 7 28859 2
36175 68120 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 94 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31866 6006215.83488054 2099558.94321569 37.7453405673201 -122.421200665955 (37.7453405673201, -122.421200665955) 2 7 5 28859 2
177885 223020 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 6ft   6006199.74889 2099432.38497 37.7449921601655 -122.421247303447 (37.7449921601655, -122.421247303447) 2 7 7 28859 2
42650 68124 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 125 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31872 6006189.84017158 2099400.84484915 37.7449049995041 -122.421279326768 (37.7449049995041, -122.421279326768) 2 7 7 28859 2
86127 32398 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 244 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 8   Permit Number 36939 6005971.23324 2096091.59209 37.7358062077876 -122.421800215602 (37.7358062077876, -122.421800215602) 2 7 7 28859 2
1435 68125 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 172 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31874 6006033.71828156 2099220.36912277 37.7444006509706 -122.421806351312 (37.7444006509706, -122.421806351312) 2 7 5 28859 2
25370 28296 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1432 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2003 12:00:00 AM 6 2X3   6005818.9272 2100626.68333 37.7482499542668 -122.422648971496 (37.7482499542668, -122.422648971496) 2 4 5 28859 19
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
85167 223025 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 380 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6005467.6636 2101500.58617 37.7506296665394 -122.423925765973 (37.7506296665394, -122.423925765973) 2 4 5 28859 19
80974 62145 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 75 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/1985 12:00:00 AM     Permit Number 22258 6005427.84181989 2099597.4165714 37.7454017512266 -122.423928154749 (37.7454017512266, -122.423928154749) 2 7 5 28859 22
34239 46345 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 382 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/2002 12:00:00 AM     Permit Number 44591 6005460.79581087 2101487.62598308 37.7505936931274 -122.423948593876 (37.7505936931274, -122.423948593876) 2 4 5 28859 19
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
165895 42999 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Rose St 2 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
115810 63593 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 198 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/20/1999 12:00:00 AM     Permit Number 24225 6005185.44614551 2109584.80310454 37.7728110766439 -122.425476960922 (37.7728110766439, -122.425476960922) 7 9 11 28852 10
192920 64244 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 554 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33284 6005149.6274741 2111313.35504132 37.7775552357395 -122.425723916077 (37.7775552357395, -122.425723916077) 7 9 11 28852 10
171056 223027 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 116 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6004711.20676 2102860.50548 37.754320952762 -122.426638485476 (37.754320952762, -122.426638485476) 2 4 5 28862 22
111061 223026 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 114 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004706.47094 2102901.67728 37.7544337331488 -122.426657794828 (37.7544337331488, -122.426657794828) 2 4 5 28862 22
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
171197 223102 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 247 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779888 6004283.79281 2099537.35517 37.7451721819657 -122.427879813411 (37.7451721819657, -122.427879813411) 2 7 5 63 22
110897 223053 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 701 Church St 13 Front Yard : Yard Tree Private 2     4 Width 3ft   6004342.54387 2104435.23189 37.7586239308804 -122.42802562499 (37.7586239308804, -122.42802562499) 2 4 5 28862 3
25870 223054 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 701 Church St 15 Front Yard : Yard Tree Private 2     5 Width 3ft   6004339.17113 2104460.25399 37.7586924448242 -122.428039072561 (37.7586924448242, -122.428039072561) 2 4 5 28862 3
33319 54717 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 3609 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2002 12:00:00 AM     Permit Number 24726 6004298.03079874 2103629.31683929 37.756408560199 -122.428122138519 (37.756408560199, -122.428122138519) 2 4 5 28862 22
65845 223047 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3864 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6004003.36703 2102490.39098 37.7532646621477 -122.429059987437 (37.7532646621477, -122.429059987437) 2 4 5 28862 22
176527 223048 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3880 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6003922.51538 2102484.70879 37.7532444831531 -122.429339183778 (37.7532444831531, -122.429339183778) 2 4 5 28862 22
91882 121558 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 400X Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6003675 2102779 37.7540385213778 -122.430216135756 (37.7540385213778, -122.430216135756) 2 4 5 28862 22
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
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
38562 66726 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 416 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1992 12:00:00 AM     Permit Number 31446 6003651.13955938 2102766.75784402 37.7540035558201 -122.430297777513 (37.7540035558201, -122.430297777513) 2 4 5 28862 22
63437 60436 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 474 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/2004 12:00:00 AM     Permit Number 20020 6003505.36219814 2098957.85837164 37.7435369501722 -122.430530149996 (37.7435369501722, -122.430530149996) 2 7 5 63 22
85025 48468 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1409 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/2002 12:00:00 AM     Permit Number 45831 6003303.13281599 2100036.19716336 37.7464863595987 -122.431306366847 (37.7464863595987, -122.431306366847) 2 7 5 63 22
47287 82780 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 3946 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50814 6003353.51076321 2104798.51931181 37.7595654262957 -122.43147208276 (37.7595654262957, -122.43147208276) 2 4 5 28862 3
52691 63792 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 4094 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24478 6003252.0069668 2101284.19573809 37.7499101740217 -122.431572236451 (37.7499101740217, -122.431572236451) 2 4 5 28862 22
117769 126378 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1976 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003585.79025 2118315.11213 37.7966917978451 -122.431633760802 (37.7966917978451, -122.431633760802) 13 9 1 57 17
183578 35403 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 550 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38858 6003059.40190018 2098358.03858994 37.7418647106265 -122.432029345324 (37.7418647106265, -122.432029345324) 2 7 5 63 22
174811 161273 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 566 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   0 Width 0ft   6002889.18037 2090346.52899 37.7198572690851 -122.432045948864 (37.7198572690851, -122.432045948864) 9 7 6 28861 5
92777 247816 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 550 30th St 1 : Tree Private 2     5 Width 3ft   6003030.78831 2098349.34835 37.7418392269952 -122.432127661269 (37.7418392269952, -122.432127661269) 2 7 5 63 22
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
73339 51538 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 4138 20th St 1 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
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
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
26466 34431 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 42 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38175 6002613.57489862 2096408.07550267 37.7364852770817 -122.433431554421 (37.7364852770817, -122.433431554421) 2 7 5 63 7
76572 223055 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 42 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6002598.631 2096412.43412 37.7364963969952 -122.433483533142 (37.7364963969952, -122.433483533142) 2 7 5 63 7
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
55830 41230 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3618 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1999 12:00:00 AM 6 3x3 Permit Number 41935 6002625.18254 2121047.68706 37.804140238442 -122.435153221671 (37.804140238442, -122.435153221671) 13 9 1 57 17
14146 41229 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 3618 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1999 12:00:00 AM 5 3x3 Permit Number 41935 6002621.77288 2121066.97203 37.8041929962699 -122.435166401228 (37.8041929962699, -122.435166401228) 13 9 1 57 17
48817 41708 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 203 Surrey St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42156 6002096.90165519 2096076.31860804 37.7355450223799 -122.435194188204 (37.7355450223799, -122.435194188204) 2 7 5 63 7
169683 41707 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 203 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42156 6002096.90165519 2096076.31860804 37.7355450223799 -122.435194188204 (37.7355450223799, -122.435194188204) 2 7 5 63 7
177067 223038 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 10 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002089.19721 2096067.16423 37.7355194490575 -122.435220170783 (37.7355194490575, -122.435220170783) 2 7 5 63 7
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
101641 35101 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 774 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1998 12:00:00 AM     Permit Number 38642 6001926.16682464 2089330.25640032 37.71701216685 -122.435302089615 (37.71701216685, -122.435302089615) 9 7 6 28861 5
124950 176073 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 774 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6001923.16259 2089317.3719 37.7169766182659 -122.43531155268 (37.7169766182659, -122.43531155268) 9 7 6 28861 5
99367 176074 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 786 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001892.13578 2089268.05693 37.7168394482606 -122.435415271495 (37.7168394482606, -122.435415271495) 9 7 6 28861 5
20331 95111 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 649 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM 3 3x3 Permit Number 54039 6001701.74477 2093288.67335 37.7278683408513 -122.436360947301 (37.7278683408513, -122.436360947301) 9 7 6 28861 25
164008 95110 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 649 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2010 12:00:00 AM 2 3x3 Permit Number 54039 6001693.52474 2093271.82828 37.7278216210543 -122.436388158988 (37.7278216210543, -122.436388158988) 9 7 6 28861 25
57524 47492 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 657 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 5   Permit Number 45386 6001676.19021 2093232.03842 37.7277113821718 -122.436445238065 (37.7277113821718, -122.436445238065) 9 7 6 28861 25
97453 206694 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 125 Chilton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001630.15209 2095380.35715 37.733607556928 -122.43675811219 (37.733607556928, -122.43675811219) 9 7 5 63 40
70629 104352 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 304 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x10 Permit Number 770823 6001744.6 2103958.8 37.7571684409617 -122.436976369496 (37.7571684409617, -122.436976369496) 2 4 5 28862 3
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
167854 206695 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 140 Hamerton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001321.91458 2095363.51303 37.7335437842173 -122.437822570471 (37.7335437842173, -122.437822570471) 9 7 5 63 40
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
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
34876 45122 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 201 Buena Vista Ave East 2 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
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
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
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
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
52405 223051 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 24 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001422.87059 2107990.68113 37.7682207070445 -122.438377882942 (37.7682207070445, -122.438377882942) 15 5 5 29492 3
103846 223050 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 18 Buena Vista Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001422.84544 2108013.2139 37.7682825750187 -122.438379584463 (37.7682825750187, -122.438379584463) 15 5 5 29492 3
90444 45125 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 215 Buena Vista East Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2001 12:00:00 AM     Permit Number 43982 6001423.51922816 2108204.04749997 37.7688065951097 -122.438390927701 (37.7688065951097, -122.438390927701) 15 5 5 29492 3
167261 87776 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 333 Sussex St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50481 6001129 2096659 37.737089918679 -122.438582321394 (37.737089918679, -122.438582321394) 2 7 5 63 7
192031 87775 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 333 Sussex St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50481 6001129 2096659 37.737089918679 -122.438582321394 (37.737089918679, -122.438582321394) 2 7 5 63 7
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
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
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
76261 26484 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 154 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6000987.64369 2098692.25572 37.7426647191989 -122.439216742684 (37.7426647191989, -122.439216742684) 2 7 5 63 7
166632 47955 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 59 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2002 12:00:00 AM     Permit Number 45685 6001000.20919275 2101375.03881203 37.7500317183297 -122.439365554728 (37.7500317183297, -122.439365554728) 2 4 5 28862 22
114901 126377 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 122 Cervantes Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6001345.97363 2121147.25207 37.8043408951819 -122.439587150049 (37.8043408951819, -122.439587150049) 13 9 1 57 17
59033 126376 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 122 Cervantes Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6001336.2876 2121154.5777 37.8043604581295 -122.439621194774 (37.8043604581295, -122.439621194774) 13 9 1 57 17
178877 72340 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 230 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51610 6000779.3756349 2094751.92568258 37.7318336416051 -122.43965444862 (37.7318336416051, -122.43965444862) 9 7 4 63 40
126227 206696 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 230 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000774.6257 2094855.98841 37.7321191034008 -122.439678327791 (37.7321191034008, -122.439678327791) 9 7 4 63 40
10122 52665 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1200 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM 3 3x3 Permit Number 774794 6000815 2109317 37.77182785317 -122.440575583218 (37.77182785317, -122.440575583218) 15 5 11 29492 9
105415 54097 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 121 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/1995 12:00:00 AM     Permit Number 9824 6000463.76381209 2104868.98714017 37.7595947080418 -122.441471294748 (37.7595947080418, -122.441471294748) 2 4 5 28862 3
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
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
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
111111 137657 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2167 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5999659.4785 2111881.8514 37.7788044135747 -122.444756988886 (37.7788044135747, -122.444756988886) 15 5 11 29490 16
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
118642 137632 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2175 TURK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999619.2063 2111878.8056 37.7787937523144 -122.444896086774 (37.7787937523144, -122.444896086774) 15 5 11 29490 16
190535 249691 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2400 Baker St 23 Front Yard : Yard Tree Private 2     1     5999714.93782 2117284.79533 37.793642655433 -122.444953636697 (37.793642655433, -122.444953636697) 13 9 1 57 27
48670 249686 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2400 Baker St 18 Front Yard : Yard Tree Private 2     4     5999708.23219 2117360.34158 37.7938497027636 -122.444982272037 (37.7938497027636, -122.444982272037) 13 9 1 57 27
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
62246 121661 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 860 Teresita Blvd 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998939 2095554 37.7339310276146 -122.446074655004 (37.7339310276146, -122.446074655004) 9 7 4 59 40
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

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