Street_Tree_List

Data source: data.sfgov.org

79 rows where qSpecies = 14

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23 52566 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1555 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2016 12:00:00 AM 2 3x3 Permit Number 777142 5983716.6125 2104561.7225 37.7577827259957 -122.499367683206 (37.7577827259957, -122.499367683206)
3782 182315 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2724 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2001 12:00:00 AM 9 Width 0ft Permit Number 43905 5986428.3511 2105069.3949 37.759335376640294 -122.490026834722 (37.7593353766403, -122.490026834722)
3786 182314 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2722 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2001 12:00:00 AM 8 Width 0ft Permit Number 43905 5986467.3075 2105072.335 37.7593457241234 -122.489892322597 (37.7593457241234, -122.489892322597)
18790 95526 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2320 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM   3x3 Permit Number 767318 5986850.0 2102357.0 37.7519124926116 -122.48836924935699 (37.7519124926116, -122.488369249357)
23117 5686 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 1511 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/08/2013 12:00:00 AM 6 3X3   6005299.081119999 2099468.71725 37.7450411021616 -122.424364236744 (37.7450411021616, -122.424364236744)
24310 184685 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3339 Lawton St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5983851.9132 2104244.1115 37.756918592100206 -122.498876300129 (37.7569185921002, -122.498876300129)
27920 219161 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 521 Bright St 1 : 4 Tree 1 Private 1     8 Width 3ft   5993760.1338 2090633.97995 37.720124750843794 -122.463622478709 (37.7201247508438, -122.463622478709)
30266 184650 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3338 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983871.6255 2103619.2141 37.7552039545022 -122.498761965635 (37.7552039545022, -122.498761965635)
31771 47843 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 6924 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/14/2002 12:00:00 AM 5   Permit Number 45604 5981873.70805 2109654.60346 37.7716580179505 -122.506118715787 (37.7716580179505, -122.506118715787)
37071 184415 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3516 Quintara St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982523.9135 2100851.2465 37.747524752909 -122.50321774395901 (37.747524752909, -122.503217743959)
40272 72148 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 86 San Gabriel Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/15/2010 12:00:00 AM 8 3x3 Permit Number 53743 6000997.4480800005 2093594.63988 37.72866841100429 -122.43881762803998 (37.7286684110043, -122.43881762804)
42355 51216 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1314 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/11/2004 12:00:00 AM 0   Permit Number 47579 5987428.711298901 2106322.72675592 37.76283504767979 -122.48665917653601 (37.7628350476798, -122.486659176536)
42448 228408 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 511 Anderson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007849.96973 2096414.41057 37.7367983659444 -122.41532751336901 (37.7367983659444, -122.415327513369)
43117 219165 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 99x San Marcos Ave 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 5ft   5993760.22324 2100276.5052799997 37.7466007478231 -122.46432187335199 (37.7466007478231, -122.464321873352)
43982 122248 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2 14th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5991505.6794 2114885.8610799997 37.786583912584 -122.473183050399 (37.786583912584, -122.473183050399)
49674 47187 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 399 El Camino Del Mar 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 9   Permit Number 45147 5987458.66147 2115287.92656 37.787452713754604 -122.487214103607 (37.7874527137546, -122.487214103607)
50422 183141 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3345 Santiago St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5982420.2443 2099431.2913 37.7436198552063 -122.50347108938601 (37.7436198552063, -122.503471089386)
57574 184362 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2235 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5981703.3038 2099872.4987 37.7447891133624 -122.505982756659 (37.7447891133624, -122.505982756659)
58710 50429 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 67 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/2006 12:00:00 AM     Permit Number 47120 5996484.84958123 2090316.45977925 37.7194095383054 -122.454181186248 (37.7194095383054, -122.454181186248)
58979 183140 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3349 Santiago St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5982406.7135 2099430.6148 37.74361720224611 -122.503517824716 (37.7436172022461, -122.503517824716)
60262 219167 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 99x San Marcos Ave 13 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   5993768.02883 2100241.187 37.7465042226907 -122.464292318936 (37.7465042226907, -122.464292318936)
69676 78346 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 701x 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2000 12:00:00 AM 12 3x3   5985355.4115699995 2111047.7911900003 37.7756876566632 -122.494178171574 (37.7756876566632, -122.494178171574)
69777 52559 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1678 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 6   Permit Number 48655 5984103.37400315 2103748.01053753 37.755571183273 -122.497970034028 (37.755571183273, -122.497970034028)
70245 190636 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1 01st St 30 : Yard 23 Tree 1 Private 1     8     6014391.99798 2105898.86804 37.763206189822796 -122.393372206868 (37.7632061898228, -122.393372206868)
73004 190635 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1 01st St 28 : Yard 23 Tree 1 Private 1     9     6014407.37845 2105898.42582 37.7632058300952 -122.393318979581 (37.7632058300952, -122.393318979581)
73878 74187 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 296 Flournoy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2011 12:00:00 AM 7   Permit Number 768359 5993850.51069 2086764.5061400002 37.709505305201 -122.46302947742201 (37.709505305201, -122.463029477422)
74480 185248 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2546 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5982756.6298 2097779.5782 37.7391044746726 -122.50218576556699 (37.7391044746726, -122.502185765567)
76824 219162 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 99x San Marcos Ave 5 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   5993732.15666 2100284.86554 37.74662208515711 -122.46441953075501 (37.7466220851571, -122.464419530755)
78429 46975 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1255 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM     Permit Number 48658 5983642.12848026 2106614.74740767 37.7634153834379 -122.49977701762501 (37.7634153834379, -122.499777017625)
81503 47270 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1415 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM     Permit Number 45211 5988330.87338266 2105673.9689988997 37.7611062868333 -122.48349138844699 (37.7611062868333, -122.483491388447)
89553 44374 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 3000 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723)
90248 97040 Property Tree 7 Hakea suaveolens :: Sweet Hakea Tree 14 195B Kiska Rd   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
92608 47973 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 511 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2002 12:00:00 AM     Permit Number 45705 5997432.80489118 2095030.9839196 37.732408823319396 -122.451244298155 (37.7324088233194, -122.451244298155)
92727 44372 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 3000 25th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723)
93671 44371 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 3000 25th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723)
99978 45586 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1850 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM     Permit Number 44322 5986625.54089387 2102658.2527044998 37.7527265518545 -122.48916759637501 (37.7527265518545, -122.489167596375)
105583 52573 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1600 40th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM     Permit Number 48665 5983775.59805013 2104247.52774772 37.756923495634496 -122.49914047475201 (37.7569234956345, -122.499140474752)
105989 46974 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 3939 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2002 12:00:00 AM     Permit Number 44993 5982076.50778341 2104184.40475962 37.756650358799 -122.505011787407 (37.756650358799, -122.505011787407)
106784 47260 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1354 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM     Permit Number 45201 5988989.00067535 2106115.56060803 37.7623570608384 -122.481247573852 (37.7623570608384, -122.481247573852)
107568 52569 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1600 40th Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM     Permit Number 48665 5983775.59805013 2104247.52774772 37.756923495634496 -122.49914047475201 (37.7569234956345, -122.499140474752)
107608 52570 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1600 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 8   Permit Number 48665 5983775.59805013 2104247.52774772 37.756923495634496 -122.49914047475201 (37.7569234956345, -122.499140474752)
111231 46383 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2095 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM     Permit Number 44620 5982596.20069175 2100871.95933253 37.747585873514105 -122.502969316686 (37.7475858735141, -122.502969316686)
120065 52568 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1600 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 9   Permit Number 48665 5983775.59805013 2104247.52774772 37.756923495634496 -122.49914047475201 (37.7569234956345, -122.499140474752)
125485 97041 Property Tree 7 Hakea suaveolens :: Sweet Hakea Tree 14 195B Kiska Rd   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
128784 97039 Property Tree 7 Hakea suaveolens :: Sweet Hakea Tree 14 195B Kiska Rd   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
130272 182923 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2615 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981792.4148 2097276.497 37.7376664555995 -122.50548224533199 (37.7376664555995, -122.505482245332)
130453 228407 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 200 Eugenia Ave 6 Front Yard : Yard 7 Tree 1 Private 1     2     6006574.82543 2098099.74067 37.741354156980705 -122.41985580852501 (37.7413541569807, -122.419855808525)
131097 184681 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3347 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983801.7058 2104241.4158 37.756908245442 -122.499049734219 (37.756908245442, -122.499049734219)
131387 52558 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1674 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 5   Permit Number 48654 5984102.47415155 2103774.16691432 37.7556429486434 -122.497975077402 (37.7556429486434, -122.497975077402)
132890 47213 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 786 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2002 12:00:00 AM 8   Permit Number 45164 5982321.87525 2110412.54018 37.773765463784706 -122.504624671037 (37.7737654637847, -122.504624671037)
133931 184652 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3342 Moraga St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5983832.8748 2103618.5402 37.755199831309 -122.498895925085 (37.755199831309, -122.498895925085)
135135 43839 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2719 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 7   Permit Number 43461 5985528.40624319 2096828.27146962 37.73665489754521 -122.492532318834 (37.7366548975452, -122.492532318834)
140223 44373 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 3000 25th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723)
140629 97038 Property Tree 7 Hakea suaveolens :: Sweet Hakea Tree 14 195B Kiska Rd   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
141959 47327 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 521 Bright St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/2002 12:00:00 AM     Permit Number 45257 5993751.93708077 2090693.48871517 37.7202876752678 -122.46365512853501 (37.7202876752678, -122.463655128535)
145953 12668 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 1124 Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 3X3   5991953.3721 2114824.26552 37.7864406996636 -122.471629667444 (37.7864406996636, -122.471629667444)
151029 52552 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1570 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 3   Permit Number 48646 5984388.12260109 2104491.91964058 37.757630440730296 -122.49704020611999 (37.7576304407303, -122.49704020612)
153012 46379 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2487 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 8   Permit Number 44616 5982998.62822569 2098215.25779792 37.740314946690795 -122.501381278015 (37.7403149466908, -122.501381278015)
153160 47435 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 621 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 10   Permit Number 45346 5982857.02296 2111534.0424900004 37.7768762472938 -122.50285657813801 (37.7768762472938, -122.502856578138)
153403 80082 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1935 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM 1 3x3 Permit Number 775149 5981628.83345213 2101911.76750205 37.7503839907451 -122.50639145366199 (37.7503839907451, -122.506391453662)
153512 219166 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 99x San Marcos Ave 12 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   5993758.91368 2100249.51951 37.7465265762511 -122.46432444273 (37.7465265762511, -122.46432444273)
154163 219163 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 99x San Marcos Ave 6 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   5993739.16637 2100264.73593 37.746567218412 -122.46439383083599 (37.746567218412, -122.464393830836)
154621 184653 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3344 Moraga St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983815.0158 2103618.5402 37.7551987837707 -122.498957685795 (37.7551987837707, -122.498957685795)
156535 219164 DPW Maintained 3 Hakea suaveolens :: Sweet Hakea Tree 14 99x San Marcos Ave 7 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   5993746.9601 2100281.9643 37.7466149724013 -122.464368131807 (37.7466149724013, -122.464368131807)
159488 46404 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 3425 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 5   Permit Number 44634 5982854.31136486 2100808.2311863997 37.7474260606989 -122.50207208509899 (37.7474260606989, -122.502072085099)
162082 52574 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1687 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 0   Permit Number 48666 5983743.00399894 2103682.55294706 37.7553703206529 -122.499211449645 (37.7553703206529, -122.499211449645)
164561 228406 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3450 26th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6006768.95703 2100889.1016 37.7490240484265 -122.419382402677 (37.7490240484265, -122.419382402677)
171238 78333 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 701x 34th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2000 12:00:00 AM 9 3x3   5985357.102659999 2111002.94955 37.7755646332868 -122.494169015949 (37.7755646332868, -122.494169015949)
172293 184682 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3345 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983812.8255 2104241.7528 37.756909823021005 -122.499011303641 (37.756909823021, -122.499011303641)
176028 52551 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1570 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 4   Permit Number 48646 5984388.12260109 2104491.91964058 37.757630440730296 -122.49704020611999 (37.7576304407303, -122.49704020612)
176299 182645 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2326 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5986741.8525 2102358.1899 37.751909449151796 -122.48874332116002 (37.7519094491518, -122.48874332116)
176539 183213 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 2219 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5982939.2739 2099996.1393 37.745201271967204 -122.501718222466 (37.7452012719672, -122.501718222466)
177479 219168 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 255 Staples Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5998386.0282 2093784.15423 37.729039856202796 -122.44785906383899 (37.7290398562028, -122.447859063839)
179342 184680 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3349 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5983788.2273 2104242.0898 37.7569093054043 -122.49909639697701 (37.7569093054043, -122.499096396977)
180055 184651 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 3340 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983852.0817 2103619.2141 37.7552028082153 -122.49882955279399 (37.7552028082153, -122.498829552794)
182081 43618 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1918 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM 9   Permit Number 43270 5985398.78072313 2102143.2200772 37.7512407312978 -122.493371949534 (37.7512407312978, -122.493371949534)
182171 32561 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1538 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 0   Permit Number 48668 5983450.91831802 2104669.15901481 37.758062124892994 -122.500294491982 (37.758062124893, -122.500294491982)
187219 43613 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 2278 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2000 12:00:00 AM 3   Permit Number 43266 5986102.56484148 2099736.52612164 37.7446737419753 -122.49076115557399 (37.7446737419753, -122.490761155574)
187951 184507 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1883 47th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5981621.681 2102272.7873 37.7513748283574 -122.506442956648 (37.7513748283574, -122.506442956648)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 42.962ms · Data source: data.sfgov.org