trees

493 rows where qSpecies_id = 133 sorted by Police Districts

✎ 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)
8188 126379 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1136 Havens St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 7ft   6007507.74968 2119357.27743 37.7997748437807 -122.418136782297 (37.7997748437807, -122.418136782297) 5 1 1 28858 32
10533 71420 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 637 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6009832.0273 2120182.0847 37.8021701092209 -122.410152151595 (37.8021701092209, -122.410152151595) 3 1 10 308 23
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
42279 126381 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1022 Vallejo St 1 Front Yard : Yard Tree Private 2     5     6008596.52569 2118672.84077 37.7979567725457 -122.414320748412 (37.7979567725457, -122.414320748412) 5 1 10 308 21
47893 62968 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1136 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1986 12:00:00 AM     Permit Number 23354 6007556.73602589 2118875.23289672 37.7984540273893 -122.417933081039 (37.7984540273893, -122.417933081039) 5 1 10 28858 32
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
54746 143086 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 459 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6010641.4481 2120294.7479 37.8025247902186 -122.407359099343 (37.8025247902186, -122.407359099343) 3 1 10 308 23
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
95062 62709 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1171 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1986 12:00:00 AM     Permit Number 23049 6007422.95308964 2118804.22805474 37.7982515357622 -122.418390975112 (37.7982515357622, -122.418390975112) 5 1 10 28858 32
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
184572 50986 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1120REVISED Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2004 12:00:00 AM 6   Permit Number 47576 6007503.31376 2119893.93908 37.801248132044 -122.418190201138 (37.801248132044, -122.418190201138) 5 1 1 28858 32
187759 126384 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1120 Greenwich St 2 Front Yard : Yard Tree Private 2     4     6007500.24433 2119896.23774 37.8012542708165 -122.418200985801 (37.8012542708165, -122.418200985801) 5 1 1 28858 32
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
65411 82956 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 1 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
77895 82955 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 660X Clementina St 2 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
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
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
119767 84504 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 650X Clementina St 2 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
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
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
14886 51359 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.7316638818713 -122.393534297068 (37.7316638818713, -122.393534297068) 10 3 8 58 1
16376 190928 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1778 Quesada Ave 1 : Tree Private 2     4 Width 3ft   6014320.53257 2095360.07162 37.73426491189 -122.392882024183 (37.73426491189, -122.392882024183) 10 3 8 58 1
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
34434 38590 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1614 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 2   Permit Number 40545 6015168.4288 2094722.1342 37.7325603247077 -122.389906003807 (37.7325603247077, -122.389906003807) 10 3 8 58 1
42534 66157 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1765 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1990 12:00:00 AM     Permit Number 29228 6013882.21689766 2094959.68148484 37.7331411667579 -122.394369408432 (37.7331411667579, -122.394369408432) 10 3 8 58 1
61766 35377 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 767 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM     Permit Number 38834 6011637.61839103 2091581.433538 37.7237401685956 -122.401892240977 (37.7237401685956, -122.401892240977) 10 3 7 309 28
65048 30759 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1563 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 5   Permit Number 48354 6014932.9973 2093776.0212 37.7299494300904 -122.390653863275 (37.7299494300904, -122.390653863275) 10 3 8 58 1
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
80368 51358 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.71931 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766) 10 3 8 58 1
86236 190926 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1303 Rhode Island St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6012003.88758 2102215.75937 37.7529602155494 -122.401373086604 (37.7529602155494, -122.401373086604) 10 3 8 28856 29
95861 200074 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1500 Van Dyke Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6014921.0644 2093162.4986 37.7282641582289 -122.39065226097 (37.7282641582289, -122.39065226097) 10 3 8 58 1
123517 49836 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 572 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/2005 12:00:00 AM     Permit Number 46619 6011764.04798466 2105724.17808831 37.7625801734793 -122.402449179614 (37.7625801734793, -122.402449179614) 8 3 8 28856 29
124900 190927 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1050 Wisconsin St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6012767.00645 2102579.68997 37.7540020378723 -122.39875959738 (37.7540020378723, -122.39875959738) 10 3 8 28856 29
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
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
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
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
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
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
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
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
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
31240 47741 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1384 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/2002 12:00:00 AM     Permit Number 45524 6010066.05430582 2101146.00958918 37.7499146097647 -122.407999079784 (37.7499146097647, -122.407999079784) 2 4 7 28859 19
32772 255586 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 157 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006708 2105213 37.760893044988 -122.419899978675 (37.760893044988, -122.419899978675) 2 4 7 28859 19
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
33731 67340 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 2520 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1992 12:00:00 AM     Permit Number 30824 6011380.01787368 2101864.42331106 37.7519606958911 -122.403505842523 (37.7519606958911, -122.403505842523) 10 4 8 28859 19
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
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
40601 223023 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 330 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006515.40022 2104174.73701 37.7580313639845 -122.420492397202 (37.7580313639845, -122.420492397202) 2 4 7 28859 19
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
45934 69199 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1342 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33247 6009509.54623645 2101351.16759285 37.7504467544428 -122.409938000531 (37.7504467544428, -122.409938000531) 2 4 7 28859 19
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
52294 28791 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2737 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008967.21311 2102509.30076 37.7535963186214 -122.411895265148 (37.7535963186214, -122.411895265148) 2 4 7 28859 19
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
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
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
70202 223024 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 979 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6009975.92603 2103539.78877 37.756482348292 -122.408479582484 (37.756482348292, -122.408479582484) 2 4 7 28859 19
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
70967 28792 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2731 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6008964.24348 2102548.86607 37.7537047894643 -122.411908330514 (37.7537047894643, -122.411908330514) 2 4 7 28859 19
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
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
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
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
106219 34302 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1261 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38090 6010338.30191232 2101880.05024725 37.7519453623814 -122.407109364623 (37.7519453623814, -122.407109364623) 10 4 7 28859 19
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
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
123656 223036 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 2743 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008969.13541 2102480.10351 37.7535162573804 -122.411886554326 (37.7535162573804, -122.411886554326) 2 4 7 28859 19
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
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
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
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
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
165574 65260 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1153 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/2002 12:00:00 AM     Permit Number 28059 6009500.12226017 2102463.02471256 37.7534991381214 -122.410049073844 (37.7534991381214, -122.410049073844) 2 4 7 28859 19
165972 34344 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1325 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38101 6010099.44079349 2101484.52277039 37.7508459613928 -122.407907495355 (37.7508459613928, -122.407907495355) 2 4 7 28859 19
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
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
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
7001 225622 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 67 Woodland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5997067.03037 2106173.30325 37.7629819312842 -122.453312997018 (37.7629819312842, -122.453312997018) 15 5 11 29492 12
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
11337 206619 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 181 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5994070.38957 2104649.56309 37.7586259201623 -122.463566678468 (37.7586259201623, -122.463566678468) 1 5 4 56 12
18339 70315 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 226 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5997860.8667 2109778.6627 37.7729267975155 -122.450827376517 (37.7729267975155, -122.450827376517) 15 5 11 29492 16
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
47942 48500 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1584(REVISED) Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2003 12:00:00 AM     Permit Number 46340 5998006.8549345 2108237.90665559 37.7687046321234 -122.450211308243 (37.7687046321234, -122.450211308243) 15 5 11 29492 9
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
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
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
74617 206562 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 1478 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   5994313.38923 2105462.92602 37.7608732027602 -122.462785287235 (37.7608732027602, -122.462785287235) 1 5 11 56 12
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
91240 51948 Permitted Site 7 Crataegus laevigata :: English Hawthorn 133 1506 Willard St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 48172 5996897.19536074 2106034.05471344 37.7625898542367 -122.453890338129 (37.7625898542367, -122.453890338129) 15 5 11 29492 12
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
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
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
113884 206558 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 517 Laguna Honda Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5995506.85137 2100151.86426 37.7463590370584 -122.458273237436 (37.7463590370584, -122.458273237436) 1 5 4 59 40
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
119257 223030 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 125 Belgrave Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5997950.67072 2104889.0935 37.7595064230002 -122.450164233094 (37.7595064230002, -122.450164233094) 15 5 11 28862 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
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
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

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