84 rows where qSpecies_id = 73 sorted by qSpecies_id

View and edit SQL

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)
202 190636 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1 01st St 30 : Yard Tree Private 2     8     6014391.99798 2105898.86804 37.7632061898228 -122.393372206868 (37.7632061898228, -122.393372206868) 14 3 8 28856 29
2136 182314 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2700X Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2001 12:00:00 AM 8 Width 0ft Permit Number 43905 5986474 2105095 37.7594083467555 -122.489870843925 (37.7594083467555, -122.489870843925) 1 8 3 56 35
6091 78333 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 701x 34th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9 3x3   5985357.10266 2111002.94955 37.7755646332868 -122.494169015949 (37.7755646332868, -122.494169015949) 11 6 2 55 26
13483 50429 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 67 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/2006 12:00:00 AM     Permit Number 47120 5996484.84958123 2090316.45977925 37.7194095383054 -122.454181186248 (37.7194095383054, -122.454181186248) 9 8 6 28861 24
13992 78346 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 701x 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12 3x3   5985355.41157 2111047.79119 37.7756876566632 -122.494178171574 (37.7756876566632, -122.494178171574) 11 6 2 55 26
19366 95526 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 2320 Ortega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/2011 12:00:00 AM   3x3 Permit Number 767318 5986850 2102357 37.7519124926116 -122.488369249357 (37.7519124926116, -122.488369249357) 1 8 3 56 35
19836 183141 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3345 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5982420.2443 2099431.2913 37.7436198552063 -122.503471089386 (37.7436198552063, -122.503471089386) 1 8 3 29491 35
20220 228406 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3450 26th St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6006768.95703 2100889.1016 37.7490240484265 -122.419382402677 (37.7490240484265, -122.419382402677) 2 4 7 28859 19
24619 52551 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1570 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 4   Permit Number 48646 5984388.12260109 2104491.91964058 37.7576304407303 -122.49704020612 (37.7576304407303, -122.49704020612) 1 8 3 56 35
27661 184362 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2235 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5981703.3038 2099872.4987 37.7447891133624 -122.505982756659 (37.7447891133624, -122.505982756659) 1 8 3 29491 35
27866 122248 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5991505.6794 2114885.86108 37.786583912584 -122.473183050399 (37.786583912584, -122.473183050399) 11 6 1 54 33
27904 185248 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2546 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5982756.6298 2097779.5782 37.7391044746726 -122.502185765567 (37.7391044746726, -122.502185765567) 1 8 3 29491 35
28806 97041 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
28951 39814 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2079 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/2019 12:00:00 AM 3   Permit Number 783238 5982286.3414 2100973.7552 37.7478471598417 -122.504048312387 (37.7478471598417, -122.504048312387) 1 8 3 29491 35
33444 46975 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1255 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM     Permit Number 48658 5983642.12848026 2106614.74740767 37.7634153834379 -122.499777017625 (37.7634153834379, -122.499777017625) 1 8 3 56 35
33597 97039 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
34198 183213 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2219 43rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5982939.2739 2099996.1393 37.7452012719672 -122.501718222466 (37.7452012719672, -122.501718222466) 1 8 3 29491 35
37633 181694 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1356 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 Width 0ft Permit Number 781097 5982161.9827 2105857.6697 37.7612496970921 -122.504840173741 (37.7612496970921, -122.504840173741) 1 8 3 56 35
42069 52552 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1570 38th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 3   Permit Number 48646 5984388.12260109 2104491.91964058 37.7576304407303 -122.49704020612 (37.7576304407303, -122.49704020612) 1 8 3 56 35
42303 32561 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1538 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 0   Permit Number 48668 5983450.91831802 2104669.15901481 37.758062124893 -122.500294491982 (37.758062124893, -122.500294491982) 1 8 3 56 35
46757 184653 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3344 Moraga St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5983815.0158 2103618.5402 37.7551987837707 -122.498957685795 (37.7551987837707, -122.498957685795) 1 8 3 56 35
50725 184680 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3349 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5983788.2273 2104242.0898 37.7569093054043 -122.499096396977 (37.7569093054043, -122.499096396977) 1 8 3 56 35
52741 47270 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1415 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM     Permit Number 45211 5988330.87338266 2105673.9689989 37.7611062868333 -122.483491388447 (37.7611062868333, -122.483491388447) 1 8 3 56 35
55816 219165 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 99x San Marcos Ave 8 Median : Cutout Tree DPW 1     7 Width 5ft   5993760.22324 2100276.50528 37.7466007478231 -122.464321873352 (37.7466007478231, -122.464321873352) 1 8 4 29491 40
60132 46379 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2487 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 8   Permit Number 44616 5982998.62822569 2098215.25779792 37.7403149466908 -122.501381278015 (37.7403149466908, -122.501381278015) 1 8 3 29491 35
60582 181697 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1360 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 Width 0ft Permit Number 780426 5982163.8853 2105835.7898 37.7611897330607 -122.50483197223 (37.7611897330607, -122.50483197223) 1 8 3 56 35
60981 51216 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1314 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/11/2004 12:00:00 AM 0   Permit Number 47579 5987428.7112989 2106322.72675592 37.7628350476798 -122.486659176536 (37.7628350476798, -122.486659176536) 1 8 3 56 35
62691 97040 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
63258 184652 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3342 Moraga St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5983832.8748 2103618.5402 37.755199831309 -122.498895925085 (37.755199831309, -122.498895925085) 1 8 3 56 35
64748 182645 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2326 Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5986741.8525 2102358.1899 37.7519094491518 -122.48874332116 (37.7519094491518, -122.48874332116) 1 8 3 56 35
66415 184685 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3339 Lawton St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5983851.9132 2104244.1115 37.7569185921002 -122.498876300129 (37.7569185921002, -122.498876300129) 1 8 3 56 35
69629 219167 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 99x San Marcos Ave 13 Median : Cutout Tree DPW 1     8 Width 5ft   5993768.02883 2100241.187 37.7465042226907 -122.464292318936 (37.7465042226907, -122.464292318936) 1 8 4 29491 40
69660 5686 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1511 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/08/2013 12:00:00 AM 6 3X3   6005299.08112 2099468.71725 37.7450411021616 -122.424364236744 (37.7450411021616, -122.424364236744) 2 7 5 28859 22
70190 219161 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 521 Bright St 1 : Tree Private 2     8 Width 3ft   5993760.1338 2090633.97995 37.7201247508438 -122.463622478709 (37.7201247508438, -122.463622478709) 9 8 6 64 24
73789 258441 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 2582 46th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2019 12:00:00 AM 3 3x3 Permit Number 783275 5982135.80523 2097534.25294 37.7383943847578 -122.50431408952 (37.7383943847578, -122.50431408952) 1 8 3 29491 35
74680 44374 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 3000 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723) 1 8 4 64 35
84019 184651 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3340 Moraga St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5983852.0817 2103619.2141 37.7552028082153 -122.498829552794 (37.7552028082153, -122.498829552794) 1 8 3 56 35
84829 47213 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 786 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2002 12:00:00 AM 8   Permit Number 45164 5982321.87525 2110412.54018 37.7737654637847 -122.504624671037 (37.7737654637847, -122.504624671037) 11 6 2 55 26
85299 43839 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2719 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/2000 12:00:00 AM 7   Permit Number 43461 5985528.40624319 2096828.27146962 37.7366548975452 -122.492532318834 (37.7366548975452, -122.492532318834) 1 8 3 29491 35
86604 44371 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 3000 25th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723) 1 8 4 64 35
88545 44372 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 3000 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723) 1 8 4 64 35
94880 184682 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3345 Lawton St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5983812.8255 2104241.7528 37.756909823021 -122.499011303641 (37.756909823021, -122.499011303641) 1 8 3 56 35
94923 47973 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 511 Gennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45705 5997432.80489118 2095030.9839196 37.7324088233194 -122.451244298155 (37.7324088233194, -122.451244298155) 9 7 4 59 40
96862 45586 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1850 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2001 12:00:00 AM     Permit Number 44322 5986625.54089387 2102658.2527045 37.7527265518545 -122.489167596375 (37.7527265518545, -122.489167596375) 1 8 3 56 35
99108 47843 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 6924 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/14/2002 12:00:00 AM 5   Permit Number 45604 5981873.70805 2109654.60346 37.7716580179505 -122.506118715787 (37.7716580179505, -122.506118715787) 11 6 2 55 26
99908 47435 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 621 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 10   Permit Number 45346 5982857.02296 2111534.04249 37.7768762472938 -122.502856578138 (37.7768762472938, -122.502856578138) 11 6 2 55 26
101508 43613 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2278 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/20/2000 12:00:00 AM 3   Permit Number 43266 5986102.56484148 2099736.52612164 37.7446737419753 -122.490761155574 (37.7446737419753, -122.490761155574) 1 8 3 29491 35
102337 219162 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 99x San Marcos Ave 5 Median : Cutout Tree DPW 1     6 Width 5ft   5993732.15666 2100284.86554 37.7466220851571 -122.464419530755 (37.7466220851571, -122.464419530755) 1 8 4 29491 40
105340 258231 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 2562 44th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/2019 12:00:00 AM 3 3x3 Permit Number 783204 5982751.84158 2097685.04737 37.7388446375406 -122.50219532719 (37.7388446375406, -122.50219532719) 1 8 3 29491 35
111343 74187 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 296 Flournoy St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2011 12:00:00 AM 7   Permit Number 768359 5993850.51069 2086764.50614 37.709505305201 -122.463029477422 (37.709505305201, -122.463029477422) 9 8 6 28861 25
112233 228408 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 511 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007849.96973 2096414.41057 37.7367983659444 -122.415327513369 (37.7367983659444, -122.415327513369) 2 7 7 28859 2
112867 52558 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1674 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 5   Permit Number 48654 5984102.47415155 2103774.16691432 37.7556429486434 -122.497975077402 (37.7556429486434, -122.497975077402) 1 8 3 56 35
114251 184507 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1883 47th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5981621.681 2102272.7873 37.7513748283574 -122.506442956648 (37.7513748283574, -122.506442956648) 1 8 3 56 35
115311 219166 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 99x San Marcos Ave 12 Median : Cutout Tree DPW 1     8 Width 5ft   5993758.91368 2100249.51951 37.7465265762511 -122.46432444273 (37.7465265762511, -122.46432444273) 1 8 4 29491 40
119797 46974 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 3939 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/2002 12:00:00 AM     Permit Number 44993 5982076.50778341 2104184.40475962 37.756650358799 -122.505011787407 (37.756650358799, -122.505011787407) 1 8 3 56 35
120454 47260 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1354 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM     Permit Number 45201 5988989.00067535 2106115.56060803 37.7623570608384 -122.481247573852 (37.7623570608384, -122.481247573852) 1 8 3 56 35
122373 52573 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1600 40th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM     Permit Number 48665 5983775.59805013 2104247.52774772 37.7569234956345 -122.499140474752 (37.7569234956345, -122.499140474752) 1 8 3 56 35
126770 52574 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1687 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 0   Permit Number 48666 5983743.00399894 2103682.55294706 37.7553703206529 -122.499211449645 (37.7553703206529, -122.499211449645) 1 8 3 56 35
127891 184681 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3347 Lawton St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5983801.7058 2104241.4158 37.756908245442 -122.499049734219 (37.756908245442, -122.499049734219) 1 8 3 56 35
129444 52569 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1600 40th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM     Permit Number 48665 5983775.59805013 2104247.52774772 37.7569234956345 -122.499140474752 (37.7569234956345, -122.499140474752) 1 8 3 56 35
131400 52570 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1600 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 8   Permit Number 48665 5983775.59805013 2104247.52774772 37.7569234956345 -122.499140474752 (37.7569234956345, -122.499140474752) 1 8 3 56 35
133057 228407 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 200 Eugenia Ave 6 Front Yard : Yard Tree Private 2     2     6006574.82543 2098099.74067 37.7413541569807 -122.419855808525 (37.7413541569807, -122.419855808525) 2 7 7 28859 2
136240 183140 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3349 Santiago St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5982406.7135 2099430.6148 37.7436172022461 -122.503517824716 (37.7436172022461, -122.503517824716) 1 8 3 29491 35
138645 181687 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1364 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 Width 0ft Permit Number 783206 5982164.361 2105821.0447 37.7611492752094 -122.504829234381 (37.7611492752094, -122.504829234381) 1 8 3 56 35
138712 46383 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 2095 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM     Permit Number 44620 5982596.20069175 2100871.95933253 37.7475858735141 -122.502969316686 (37.7475858735141, -122.502969316686) 1 8 3 29491 35
139788 47187 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 399 El Camino Del Mar 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2002 12:00:00 AM 9   Permit Number 45147 5987458.66147 2115287.92656 37.7874527137546 -122.487214103607 (37.7874527137546, -122.487214103607) 11 6 1 55 33
147688 219164 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 99x San Marcos Ave 7 Median : Cutout Tree DPW 1     6 Width 5ft   5993746.9601 2100281.9643 37.7466149724013 -122.464368131807 (37.7466149724013, -122.464368131807) 1 8 4 29491 40
151160 219163 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 99x San Marcos Ave 6 Median : Cutout Tree DPW 1     6 Width 5ft   5993739.16637 2100264.73593 37.746567218412 -122.464393830836 (37.746567218412, -122.464393830836) 1 8 4 29491 40
154450 219168 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 255 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5998386.0282 2093784.15423 37.7290398562028 -122.447859063839 (37.7290398562028, -122.447859063839) 9 7 4 28861 40
155574 184453 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2127 45th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   03/02/2018 12:00:00 AM 3 Width 0ft Permit Number 781491 5982298.6938 2100612.8284 37.7468568817183 -122.503978870033 (37.7468568817183, -122.503978870033) 1 8 3 29491 35
161131 184650 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3338 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5983871.6255 2103619.2141 37.7552039545022 -122.498761965635 (37.7552039545022, -122.498761965635) 1 8 3 56 35
163508 184415 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3516 Quintara St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5982523.9135 2100851.2465 37.747524752909 -122.503217743959 (37.747524752909, -122.503217743959) 1 8 3 29491 35
164610 52566 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1555 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 3x3 Permit Number 777142 5983716.6125 2104561.7225 37.7577827259957 -122.499367683206 (37.7577827259957, -122.499367683206) 1 8 3 56 35
166631 80082 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1935 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2016 12:00:00 AM 1 3x3 Permit Number 775149 5981628.83345213 2101911.76750205 37.7503839907451 -122.506391453662 (37.7503839907451, -122.506391453662) 1 8 3 29491 35
169247 52568 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 1600 40th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 9   Permit Number 48665 5983775.59805013 2104247.52774772 37.7569234956345 -122.499140474752 (37.7569234956345, -122.499140474752) 1 8 3 56 35
171563 44373 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 3000 25th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/31/2001 12:00:00 AM     Permit Number 43739 5988858.57145041 2095220.96614763 37.7324357997732 -122.480900990723 (37.7324357997732, -122.480900990723) 1 8 4 64 35
176465 97038 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
177356 182923 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 2615 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5981792.4148 2097276.497 37.7376664555995 -122.505482245332 (37.7376664555995, -122.505482245332) 1 8 3 29491 35
179656 52559 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1678 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/2006 12:00:00 AM 6   Permit Number 48655 5984103.37400315 2103748.01053753 37.755571183273 -122.497970034028 (37.755571183273, -122.497970034028) 1 8 3 56 35
184651 46404 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 3425 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/2002 12:00:00 AM 5   Permit Number 44634 5982854.31136486 2100808.2311864 37.7474260606989 -122.502072085099 (37.7474260606989, -122.502072085099) 1 8 3 29491 35
187296 47327 Permitted Site 7 Hakea suaveolens :: Sweet Hakea Tree 73 521 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2002 12:00:00 AM     Permit Number 45257 5993751.93708077 2090693.48871517 37.7202876752678 -122.463655128535 (37.7202876752678, -122.463655128535) 9 8 6 64 24
190606 12668 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1124 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   5991953.3721 2114824.26552 37.7864406996636 -122.471629667444 (37.7864406996636, -122.471629667444) 11 6 1 54 11
190818 190635 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1 01st St 28 : Yard Tree Private 2     9     6014407.37845 2105898.42582 37.7632058300952 -122.393318979581 (37.7632058300952, -122.393318979581) 14 3 8 28856 29
193684 72148 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 86 San Gabriel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM 8 3x3 Permit Number 53743 6000997.44808 2093594.63988 37.7286684110043 -122.43881762804 (37.7286684110043, -122.43881762804) 9 7 6 28861 25

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