Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
8578 | 8578 | 10632 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003878.786 | 2110787.057 | 37.7760382564385 | -122.43008262774599 | (37.7760382564385, -122.430082627746) | ||
19290 | 19290 | 24816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 12 | 2x3 | 6008197.49032 | 2095113.0796700001 | 37.733244720069706 | -122.414033944713 | (37.7332447200697, -122.414033944713) | ||
31678 | 31678 | 137728 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999638.3271 | 2111189.9480000003 | 37.77690341710429 | -122.444780412241 | (37.7769034171043, -122.444780412241) | |||
33288 | 33288 | 220075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001146.06945 | 2104525.9934099996 | 37.758691778412704 | -122.43908696419201 | (37.7586917784127, -122.439086964192) | |||
38779 | 38779 | 68329 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 12 | Permit Number 32144 | 5991421.402000001 | 2110674.853 | 37.7750167634254 | -122.47316740712401 | (37.7750167634254, -122.473167407124) | |
41095 | 41095 | 220673 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.21028 | 2095878.12902 | 37.735409776738294 | -122.410119940478 | (37.7354097767383, -122.410119940478) | |||
41760 | 41760 | 203657 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 226 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6000556.64604 | 2094979.3129099999 | 37.7324453144793 | -122.440440771241 | (37.7324453144793, -122.440440771241) | |||
41964 | 41964 | 246075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 635 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998492.5621 | 2108432.0423 | 37.7692654626532 | -122.44854527514299 | (37.7692654626532, -122.448545275143) | |||
43560 | 43560 | 67530 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.766088665392296 | -122.394807417822 | (37.7660886653923, -122.394807417822) | |
45189 | 45189 | 220002 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6009383.355930001 | 2096884.0702099998 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | |||
48670 | 48670 | 220058 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 564 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007852.78726 | 2104670.9495900003 | 37.7594691272161 | -122.415902267384 | (37.7594691272161, -122.415902267384) | |||
53685 | 53685 | 220687 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004894.475319999 | 2110399.44382 | 37.775031437471704 | -122.426541481018 | (37.7750314374717, -122.426541481018) | |||
55462 | 55462 | 113717 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991400.52029 | 2110673.00421 | 37.775010478076794 | -122.47323950591299 | (37.7750104780768, -122.473239505913) | |||
57888 | 57888 | 220056 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009277.433730001 | 2100868.30065 | 37.7491078976199 | -122.410706569176 | (37.7491078976199, -122.410706569176) | |||
61990 | 61990 | 140718 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002160.0013 | 2110449.3533 | 37.7750135114472 | -122.436004179308 | (37.7750135114472, -122.436004179308) | |||
62065 | 62065 | 188522 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016938.13191 | 2094902.8329099999 | 37.7331544721811 | -122.38380023041701 | (37.7331544721811, -122.383800230417) | |||
68651 | 68651 | 220688 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | |||
72341 | 72341 | 220010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3561 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006555.55006 | 2104341.3837900003 | 37.758491199927 | -122.420365369767 | (37.758491199927, -122.420365369767) | |||
72487 | 72487 | 249768 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 266 Lombard St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | |||
117697 | 117697 | 38332 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | 12 | Permit Number 40386 | 6007469.91383888 | 2105705.1165966997 | 37.7622871778741 | -122.417299722191 | (37.7622871778741, -122.417299722191) | |
123798 | 123798 | 67185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.76087342528071 | -122.44976537124599 | (37.7608734252807, -122.449765371246) | |
125571 | 125571 | 220042 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 890 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6000646.62015 | 2102597.34113 | 37.7533677370469 | -122.440675944861 | (37.7533677370469, -122.440675944861) | |||
125676 | 125676 | 50046 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46777 | 6002595.036724 | 2102416.46621438 | 37.752981861465294 | -122.433924992434 | (37.7529818614653, -122.433924992434) |
136405 | 136405 | 203653 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6002114.00252 | 2095255.92738 | 37.733293387768995 | -122.435076406948 | (37.733293387769, -122.435076406948) | |||
137659 | 137659 | 64510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 838 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 12 | Permit Number 25391 | 6000497.2416 | 2111874.2369 | 37.778831278686496 | -122.441858298358 | (37.7788312786865, -122.441858298358) | |
158299 | 158299 | 138337 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001955.802999999 | 2114338.6797 | 37.7856810164636 | -122.436989049911 | (37.7856810164636, -122.436989049911) | |||
162001 | 162001 | 220694 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4054 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003525.2287099995 | 2100710.43544 | 37.74835024488029 | -122.430586486796 | (37.7483502448803, -122.430586486796) | |||
166210 | 166210 | 203659 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.44725691200199 | (37.7320962615306, -122.447256912002) | |||
173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
178617 | 178617 | 188524 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017319.36932 | 2094988.95682 | 37.7334120182438 | -122.38248816719299 | (37.7334120182438, -122.382488167193) | |||
179662 | 179662 | 203222 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993081.79545 | 2099194.6713799997 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | |||
180377 | 180377 | 31436 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4336 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35011 | 6000994.34179 | 2103320.5787299997 | 37.7553733681958 | -122.439525295576 | (37.7553733681958, -122.439525295576) | |
180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
182704 | 182704 | 32332 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 12 | Permit Number 36896 | 6006735.75103 | 2098040.81049 | 37.741201412511295 | -122.419295203505 | (37.7412014125113, -122.419295203505) | ||
185093 | 185093 | 220033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 502 28th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002622.25428 | 2099488.24408 | 37.7449431983695 | -122.433621612357 | (37.7449431983695, -122.433621612357) | ||||
186973 | 186973 | 220091 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3076 Merritt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000057.55788 | 2105416.72092 | 37.7610754998513 | -122.442915486985 | (37.7610754998513, -122.442915486985) | |||
7770 | 7770 | 20060 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
8970 | 8970 | 10634 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.43021469913201 | (37.7760227838468, -122.430214699132) | ||
15210 | 15210 | 20061 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
16839 | 16839 | 20059 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
21207 | 21207 | 10209 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/1994 12:00:00 AM | 12 | 3X3PL | 6005849.39823 | 2101351.62015 | 37.7502421837319 | -122.4225951102 | (37.7502421837319, -122.4225951102) | ||
77429 | 77429 | 23663 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 311 Virginia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453896999 | (37.7419584813283, -122.41861453897) | |||
111638 | 111638 | 23659 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 305 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.742095179874795 | -122.418753453583 | (37.7420951798748, -122.418753453583) | |||
112941 | 112941 | 23666 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 313 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006939.3181056 | 2098298.0428385 | 37.7419191778851 | -122.41860957638501 | (37.7419191778851, -122.418609576385) | |||
128008 | 128008 | 23660 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 305 Virginia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.742095179874795 | -122.418753453583 | (37.7420951798748, -122.418753453583) | |||
142538 | 142538 | 23664 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 311 Virginia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453896999 | (37.7419584813283, -122.41861453897) | |||
21499 | 21499 | 24820 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/22/2008 12:00:00 AM | 12 | 3x3 | 6007910.58435 | 2094958.48618 | 37.732804121515606 | -122.415014921609 | (37.7328041215156, -122.415014921609) | ||
96893 | 96893 | 105172 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) |
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");