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