Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");