trees
84 rows where qSpecies_id = 73 sorted by qSiteInfo descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |
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 | |||
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 | ||
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 | |
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 | |||
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 | |
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 | |
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 | |||
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 | ||
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 | |||
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 |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );