trees

1,914 rows where qSpecies_id = 45 sorted by DBH

✎ 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)
103 253831 DPW Maintained 1 :: 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
141 254165 DPW Maintained 1 :: 45 579 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5983759 2111886 37.7778955894485 -122.499762435435 (37.7778955894485, -122.499762435435) 11 6 2 55 26
144 108797 Undocumented 4 :: 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
179 113995 DPW Maintained 1 :: 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
217 105438 Undocumented 4 :: 45 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002483 2102334 37.7527490702591 -122.434306541099 (37.7527490702591, -122.434306541099) 2 4 5 28862 22
229 121402 Undocumented 4 :: 45 346X Duncan St 1 Back Yard : Yard Tree Private 2       3x3   6004011 2099874 37.7460810947058 -122.428847079389 (37.7460810947058, -122.428847079389) 2 7 5 63 22
257 115298 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
299 116945 Undocumented 4 :: 45 3676 23RD ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
301 108803 Undocumented 4 :: 45 401-499 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
375 115067 DPW Maintained 1 :: 45 70 Coral Rd 7 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
380 116339 Undocumented 4 :: 45 1400X Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
391 104857 DPW Maintained 1 :: 45 2555 46th Ave   Sidewalk: Curb side : Cutout Landscaping Private 2           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124) 1 8 3 29491 35
392 108811 Undocumented 4 :: 45 301-399 University St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
397 253904 DPW Maintained 1 :: 45 3637 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997456 2115038 37.7873443747179 -122.4526074861 (37.7873443747179, -122.4526074861) 11 6 1 54 31
427 114621 Undocumented 4 :: 45 2400X Post St 6 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
435 108949 Permitted Site 7 :: 45 254 Dublin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6003932.1 2088992 37.7161971007686 -122.428344449747 (37.7161971007686, -122.428344449747) 9 7 6 28861 5
466 116275 Undocumented 4 :: 45 700X Greenwich St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
468 121614 Undocumented 4 :: 45 800X Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001168 2102650 37.7535420028484 -122.438876681597 (37.7535420028484, -122.438876681597) 2 4 5 28862 22
740 105361 Permitted Site 7 :: 45 850 Guerrero St 3 Sidewalk: Property side : Cutout Tree Private 2       12x2.75   6005583.5 2103975.8 37.7574325683666 -122.423701164602 (37.7574325683666, -122.423701164602) 2 4 5 28859 19
803 105089 Significant Tree 6 :: 45 344 Fulton St 9 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
1416 109762 DPW Maintained 1 :: 45 1801 Scott St 1 Sidewalk: Property side : Cutout Landscaping Private 2       1.5x6.5   6001511.7 2114646.3 37.7865004107291 -122.438547564751 (37.7865004107291, -122.438547564751) 13 6 1 29490 27
1503 33210 Permitted Site 7 :: 45 80 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.7446507048802 -122.454762009134 (37.7446507048802, -122.454762009134) 1 5 4 59 40
1914 116946 Undocumented 4 :: 45 3676 23RD ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
2263 31189 Permitted Site 7 :: 45 744 Shields St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572) 9 8 6 64 24
2548 104858 DPW Maintained 1 :: 45 4205 24th St   Sidewalk: Property side : Cutout Landscaping Private 2           6001816 2101720.7 37.7510272133613 -122.436569249202 (37.7510272133613, -122.436569249202) 2 4 5 28862 22
2779 117319 Permitted Site 7 :: 45 1935 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5993426.4 2102307.1 37.7521569948021 -122.465623688401 (37.7521569948021, -122.465623688401) 1 8 4 29491 12
2785 261137 DPW Maintained 1 :: 45 2454 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5981796.50413 2098381.86438 37.7407017304597 -122.505550019662 (37.7407017304597, -122.505550019662) 1 8 3 29491 35
4568 253833 DPW Maintained 1 :: 45 607 Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3                      
5302 36500 Permitted Site 7 :: 45 78 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39380 6007942.28499887 2098248.55652594 37.7418397151309 -122.41513812883 (37.7418397151309, -122.41513812883) 2 7 7 28859 2
5914 254656 Private 9 :: 45 640 Larch St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004524 2112776 37.781535924842 -122.427992425483 (37.781535924842, -122.427992425483) 7 9 11 29490 41
6014 38201 Permitted Site 7 :: 45 254X Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40328 6010721.34684579 2091489.60477168 37.7234368466837 -122.405053190481 (37.7234368466837, -122.405053190481) 10 3 7 309 28
6366 117001 DPW Maintained 1 :: 45 1X Bernal Heights Blvd 1 Front Yard : Yard Tree DPW 1                              
7483 116947 Undocumented 4 :: 45 3676 23RD ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005238 2102584 37.7535915013127 -122.424797029407 (37.7535915013127, -122.424797029407) 2 4 5 28859 19
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
8458 259610 DPW Maintained 1 :: 45 1107 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF         6009254.2033 2087326.13058 37.7119226839796 -122.409831104788 (37.7119226839796, -122.409831104788) 9 7 8 309 39
8915 253260 DPW Maintained 1 :: 45 734 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993234 2110465 37.7745453462497 -122.466882031228 (37.7745453462497, -122.466882031228) 11 6 2 54 11
9359 114615 Undocumented 4 :: 45 2400X Post St 2 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
10197 251293 DPW Maintained 1 :: 45 3789 Market St 1 Sidewalk: Property side : Cutout Landscaping Private 2       3x3   6000208 2102740 37.753734455764 -122.442203020617 (37.753734455764, -122.442203020617) 2 4 5 63 38
10228 142720 Undocumented 4 :: 45 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078) 5 1 10 308 23
10340 36516 Permitted Site 7 :: 45 430 Crescent Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824) 2 7 7 28859 2
10564 114630 Undocumented 4 :: 45 2400X Post St 16 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
11414 173708 DPW Maintained 1 :: 45 126 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001214 2098705 37.7427125900371 -122.438434982469 (37.7427125900371, -122.438434982469) 2 7 5 63 7
11756 108765 Undocumented 4 :: 45 500X Lathrop Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
11763 108805 Undocumented 4 :: 45 401-499 University St 6 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
11776 108812 Undocumented 4 :: 45 301-399 University St 8 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
11783 31192 Permitted Site 7 :: 45 744 Shields St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572) 9 8 6 64 24
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
12815 261606 DPW Maintained 1 :: 45 108 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993739.19456 2089854.88419 37.7179843347129 -122.463638343115 (37.7179843347129, -122.463638343115) 9 8 6 64 24
12997 258944 DPW Maintained 1 :: 45 190 Freelon St 1 Sidewalk: Curb side : Yard Landscaping DPW 1       Width 2ft   6013228 2111376 37.7781804260272 -122.397782321929 (37.7781804260272, -122.397782321929) 6 2 9 28856 34
14351 109754 Permitted Site 7 :: 45 601 Steiner St 1 Sidewalk: Property side : Cutout Landscaping Private 2       1x12   6003025.4 2110381.6 37.7748766027312 -122.433005738531 (37.7748766027312, -122.433005738531) 15 5 11 29492 10
15400 112605 DPW Maintained 1 :: 45 1534 Hayes St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   08/10/2015 12:00:00 AM   5.6x12   6000465 2110329.2 37.7745871625182 -122.441858914128 (37.7745871625182, -122.441858914128) 15 5 11 29492 16
15784 114629 Undocumented 4 :: 45 2400X Post St 15 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
15900 108806 Undocumented 4 :: 45 401-499 University St 8 Sidewalk: Curb side : Cutout Tree Private 2           6008323.15237 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207) 9 3 7 309 28
15911 105081 Significant Tree 6 :: 45 344 Fulton St 1 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
16470 36527 Permitted Site 7 :: 45 619 Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39400 6007328 2097732 37.7403868250383 -122.417225535064 (37.7403868250383, -122.417225535064) 2 7 7 28859 2
17108 105086 Significant Tree 6 :: 45 344 Fulton St 6 Front Yard : Yard Tree Private 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17437 105043 DPW Maintained 1 :: 45 2660 Harrison St 5 Sidewalk: Property side : Cutout Landscaping Private 2       2x4   6008902 2102968 37.7548521445958 -122.412153203197 (37.7548521445958, -122.412153203197) 2 4 7 28859 19
17525 108731 Undocumented 4 :: 45 1822-1898X 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013006 2102886 37.7548564119513 -122.39795458116 (37.7548564119513, -122.39795458116) 10 3 8 28856 29
18354 36517 Permitted Site 7 :: 45 430 Crescent Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824) 2 7 7 28859 2
18399 115024 Permitted Site 7 :: 45 2500 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2016 12:00:00 AM       5983385.7 2098079 37.7399635443515 -122.500032889381 (37.7399635443515, -122.500032889381) 1 8 3 29491 35
18687 104158 DPW Maintained 1 :: 45 525X Church St 6 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
19220 122819 Undocumented 4 :: 45 121 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003309 2094407 37.7310302083694 -122.430884409483 (37.7310302083694, -122.430884409483) 9 7 5 28861 25
20009 40513 Permitted Site 7 :: 45 1620 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41577 5999999.85509787 2110944.48687978 37.7762500681911 -122.443512144169 (37.7762500681911, -122.443512144169) 15 5 11 29492 16
20105 255010 Planning Code 138.1 required 2 :: 45 619 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5989082.77589 2111106.98355 37.7760675897916 -122.481288779285 (37.7760675897916, -122.481288779285) 11 6 2 55 26
21621 37520 Permitted Site 7 :: 45 649 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39973 6008796.59183246 2114756.17350418 37.7872137988014 -122.413351333091 (37.7872137988014, -122.413351333091) 5 1 10 28852 36
22185 116323 Undocumented 4 :: 45 1400X Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
22609 116318 Undocumented 4 :: 45 1451 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010547.7 2101110.8 37.74984488673 -122.406331036849 (37.74984488673, -122.406331036849) 10 4 7 28859 19
23428 114625 Undocumented 4 :: 45 2400X Post St 11 Sidewalk: Curb side : Cutout Tree Private 2           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976) 15 6 11 29490 13
23775 108576 Property Tree 8 :: 45 2479 Diamond St 1 Front Yard : Yard Landscaping Private 2           6002240 2097369 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
25187 116322 Undocumented 4 :: 45 1400X Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6010648.28497 2101378.43149 37.7505853701643 -122.406002059271 (37.7505853701643, -122.406002059271) 10 4 8 28859 19
26240 115259 DPW Maintained 1 :: 45 2130 Jackson St   Sidewalk: Curb side : Cutout Landscaping Private 2   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004 37.7931106894063 -122.430387878845 (37.7931106894063, -122.430387878845) 13 9 1 29490 27
26512 114567 Permitted Site 7 :: 45 1930 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/2015 12:00:00 AM   3x3   6008702.7 2119505.5 37.8002490116896 -122.414012289596 (37.8002490116896, -122.414012289596) 3 1 10 308 32
26985 41854 Permitted Site 7 :: 45 942 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42241 5991990.35837611 2105257.12694546 37.7601740626082 -122.470804559297 (37.7601740626082, -122.470804559297) 1 8 4 56 12
27852 37456 Permitted Site 7 :: 45 442 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39929 6010236.40979486 2098631.79989851 37.7430206762597 -122.407232767953 (37.7430206762597, -122.407232767953) 10 7 7 28859 2
28225 253377 Planning Code 138.1 required 2 :: 45 2 Alpine Ter 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001556 2108661 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225) 15 5 5 29492 9
29005 38003 Permitted Site 7 :: 45 2478 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2002 12:00:00 AM     Permit Number 40215 5992069.67302471 2098579.11634993 37.7418425623068 -122.470043991015 (37.7418425623068, -122.470043991015) 1 8 4 29491 40
29145 121591 Undocumented 4 :: 45 162 Mangels Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6000339 2095263 37.7332118579221 -122.441213569672 (37.7332118579221, -122.441213569672) 9 7 5 63 40
29183 139164 Undocumented 4 :: 45 1975 POST ST 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6002726.0596 2114048.1262 37.7849269803652 -122.434303405747 (37.7849269803652, -122.434303405747) 13 9 11 29490 13
29284 36507 Permitted Site 7 :: 45 584 Anderson St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/29/2003 12:00:00 AM     Permit Number 39385 6007790.43718065 2096197.35426509 37.7361990307601 -122.415517981354 (37.7361990307601, -122.415517981354) 2 7 7 28859 2
30113 33407 Permitted Site 7 :: 45 100 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247) 1 5 4 59 40
30541 253834 DPW Maintained 1 :: 45 747 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6006860.78535 2113242.76542 37.7829494746502 -122.419941385136 (37.7829494746502, -122.419941385136) 7 9 9 28852 36
31000 104827 Permitted Site 7 :: 45 4366 26th St   : Cutout Tree Private 2       3X3   6001535.3 2100615.2 37.7479758185871 -122.437460780102 (37.7479758185871, -122.437460780102) 2 4 5 28862 22
31577 104151 DPW Maintained 1 :: 45 525X Church St 1 Sidewalk: Property side : Cutout Landscaping SFUSD 4 DPW     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
31879 115804 Undocumented 4 :: 45 282X GRAYSTONE TER 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5999572 2103825 37.7566773324243 -122.444480417383 (37.7566773324243, -122.444480417383) 2 5 5 28862 38
32995 124715 DPW Maintained 1 :: 45 599X 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002687 2100013 37.7463877287793 -122.433435226166 (37.7463877287793, -122.433435226166) 2 7 5 63 22
33016 31148 Permitted Site 7 :: 45 500 Hearst Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34853 5998089.630643 2094417.27408922 37.7307613077995 -122.44892931603 (37.7307613077995, -122.44892931603) 9 7 4 59 40
35856 253828 DPW Maintained 1 :: 45 825 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW     3x3   6007000.12586 2113749.24795 37.7843480014325 -122.419495267967 (37.7843480014325, -122.419495267967) 7 9 9 28858 36
36178 108990 Undocumented 4 :: 45 2073-2099X Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           5999311.1 2121145.9 37.8042211586385 -122.446628874501 (37.8042211586385, -122.446628874501) 13 9 1 57 17
36894 121612 Undocumented 4 :: 45 800X Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001168 2102650 37.7535420028484 -122.438876681597 (37.7535420028484, -122.438876681597) 2 4 5 28862 22
38005 35482 Permitted Site 7 :: 45 1136 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/2000 12:00:00 AM     Permit Number 40088 6008340.04148266 2093836.36406151 37.7297471396453 -122.413450843683 (37.7297471396453, -122.413450843683) 9 3 7 309 28
40034 116284 Undocumented 4 :: 45 700X Greenwich St 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009521.9 2120182.3 37.8021533125646 -122.411225360908 (37.8021533125646, -122.411225360908) 3 1 10 308 23
40795 35996 Permitted Site 7 :: 45 36 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39146 6007490.93822931 2099869.27557104 37.7462644727809 -122.416813538412 (37.7462644727809, -122.416813538412) 2 7 7 28859 2
42253 38110 Permitted Site 7 :: 45 1296 29th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM     Permit Number 40278 5987114.66231835 2106457.26685396 37.763186144894 -122.487755232649 (37.763186144894, -122.487755232649) 1 8 3 56 35
42415 108792 Permitted Site 7 :: 45 201-299 University St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6008053.41125 2093004.09823 37.7274458184293 -122.414382893832 (37.7274458184293, -122.414382893832) 9 3 7 309 28
43838 253762 Planning Code 138.1 required 2 :: 45 520 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993490 2111935 37.7785963431655 -122.466103329181 (37.7785963431655, -122.466103329181) 11 6 2 54 11
45721 108810 Undocumented 4 :: 45 301-399 University St 3 Sidewalk: Curb side : Cutout Tree Private 2           6008160.40727 2092653.74948 37.7264898456848 -122.413988233103 (37.7264898456848, -122.413988233103) 9 3 7 309 28
45738 109978 Undocumented 4 :: 45 75 Escondido Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5986097 2096084.1 37.73464482809 -122.490511739576 (37.73464482809, -122.490511739576) 1 8 3 64 35
47069 117591 Undocumented 4 :: 45 1262 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999100 2105386 37.7609365084256 -122.446225043361 (37.7609365084256, -122.446225043361) 15 5 5 28862 3
47607 33409 Permitted Site 7 :: 45 100 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247) 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)
);