trees
1,194 rows where qSpecies_id = 50 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
571 | 91075 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858 | 2104570 | 37.7591922359052 | -122.415877090614 | (37.7591922359052, -122.415877090614) | 2 | 4 | 7 | 28859 | 19 | ||
991 | 38251 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | 8 | 4 | 7 | 28853 | 19 | ||
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
2118 | 73083 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.418411696436 | (37.7635727856768, -122.418411696436) | 8 | 4 | 7 | 28859 | 19 | ||
2399 | 121749 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
4647 | 36593 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
4736 | 121804 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 22 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
5495 | 260381 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1924 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015697 | 2093053 | 37.7280065148754 | -122.387962157958 | (37.7280065148754, -122.387962157958) | 10 | 3 | 8 | 58 | 1 | ||||
6402 | 94573 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3978 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53752 | 6003116 | 2105363 | 37.761101890414 | -122.432333828196 | (37.761101890414, -122.432333828196) | 15 | 4 | 5 | 28862 | 3 | ||
6465 | 261249 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 23 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007038 | 2095471 | 37.7341622992343 | -122.418067993983 | (37.7341622992343, -122.418067993983) | 2 | 7 | 7 | 28859 | 2 | ||||
6953 | 34058 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37960 | ||||||||||||||
8083 | 261467 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003376.13457 | 2107738.85817 | 37.7676401694851 | -122.431603760325 | (37.7676401694851, -122.431603760325) | 15 | 5 | 5 | 28862 | 3 | ||||
8559 | 264797 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 685 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009656 | 2091058 | 37.7221921373886 | -122.40870548174 | (37.7221921373886, -122.40870548174) | 10 | 3 | 7 | 309 | 28 | ||||
8650 | 46584 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2790 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2002 12:00:00 AM | Permit Number 44712 | |||||||||||||
8746 | 37676 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3330 20TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40072 | 6008031 | 2104525 | 37.7590784006599 | -122.415275586184 | (37.7590784006599, -122.415275586184) | 2 | 4 | 7 | 28859 | 19 | ||
9084 | 52119 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 700 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 3x3 | Permit Number 48306 | 6004489.25693114 | 2110876.3075584 | 37.7763178722928 | -122.427977208208 | (37.7763178722928, -122.427977208208) | 7 | 9 | 11 | 28852 | 10 | |
9095 | 256124 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1250X Florida St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009290 | 2101816 | 37.7517107736785 | -122.410730034064 | (37.7517107736785, -122.410730034064) | 2 | 4 | 7 | 28859 | 19 | ||||
9289 | 260836 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1536 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015652 | 2095724 | 37.7353380520345 | -122.388304065218 | (37.7353380520345, -122.388304065218) | 10 | 3 | 8 | 58 | 1 | ||||
10242 | 52219 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 351 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2005 12:00:00 AM | Permit Number 48402 | 6007831.77869094 | 2105893.38398739 | 37.7628244688066 | -122.416061497544 | (37.7628244688066, -122.416061497544) | 8 | 4 | 7 | 28859 | 19 | |||
11283 | 96093 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Drake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481 | 2086737 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | 9 | 7 | 6 | 28861 | 5 | ||
11638 | 95638 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767404 | 6004462 | 2107407 | 37.7667904546556 | -122.427824239372 | (37.7667904546556, -122.427824239372) | 8 | 4 | 5 | 28862 | 3 | |
12676 | 251651 | Significant Tree 6 | Jacaranda mimosifolia :: Jacaranda 50 | 3237 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 782183 | 6009049 | 2099828 | 37.7462386522881 | -122.411423013741 | (37.7462386522881, -122.411423013741) | 2 | 7 | 7 | 28859 | 2 | |||
12919 | 262245 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004464 | 2102825 | 37.7542094840672 | -122.427490860103 | (37.7542094840672, -122.427490860103) | 2 | 4 | 5 | 28862 | 22 | ||||
13018 | 121737 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 12 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
13157 | 253697 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 865 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003091 | 2107654 | 37.7673910038901 | -122.432583941874 | (37.7673910038901, -122.432583941874) | 15 | 5 | 5 | 28862 | 3 | ||||
13239 | 35575 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 99 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | 7X6 | Permit Number 38943 | 6005733.52150857 | 2103415.89933022 | 37.7559036789868 | -122.423142532595 | (37.7559036789868, -122.423142532595) | 2 | 4 | 5 | 28859 | 19 | |
13570 | 34057 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | 8 | 4 | 7 | 28859 | 19 | ||
13796 | 46609 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1078 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44732 | 6010490.67134457 | 2102955.14321265 | 37.7549058552549 | -122.406658202843 | (37.7549058552549, -122.406658202843) | 10 | 4 | 7 | 28859 | 19 | |||
13806 | 36597 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1325 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 39450 | 6009555.90279082 | 2101454.80149403 | 37.7507339080729 | -122.409785009854 | (37.7507339080729, -122.409785009854) | 2 | 4 | 7 | 28859 | 19 | ||
14306 | 35546 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
14333 | 68480 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1218 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32350 | 6010273.43286101 | 2102111.66598921 | 37.7525776974999 | -122.407350018785 | (37.7525776974999, -122.407350018785) | 2 | 4 | 7 | 28859 | 19 | ||
14521 | 259145 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 115 Wool St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007403 | 2097606 | 37.7400450761075 | -122.416957288885 | (37.7400450761075, -122.416957288885) | 2 | 7 | 7 | 28859 | 2 | ||||
14868 | 93885 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 61@ San Jose Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2010 12:00:00 AM | Permit Number 53373 | 6006171 | 2099937 | 37.7463760977894 | -122.421382540818 | (37.7463760977894, -122.421382540818) | 2 | 7 | 5 | 28859 | 2 | |||
15490 | 264795 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 685 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009656 | 2091058 | 37.7221921373886 | -122.40870548174 | (37.7221921373886, -122.40870548174) | 10 | 3 | 7 | 309 | 28 | ||||
15582 | 34308 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
15956 | 121747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 10 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
17028 | 264796 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 685 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009656 | 2091058 | 37.7221921373886 | -122.40870548174 | (37.7221921373886, -122.40870548174) | 10 | 3 | 7 | 309 | 28 | ||||
17101 | 36665 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1361 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39471 | 6010110.56144118 | 2101283.13510395 | 37.750293617943 | -122.407854839546 | (37.750293617943, -122.407854839546) | 2 | 4 | 7 | 28859 | 19 | ||
19118 | 34336 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
19632 | 121745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 8 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
19970 | 42662 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42694 | 6006739.09438078 | 2102580.17039633 | 37.7536656552896 | -122.419605633092 | (37.7536656552896, -122.419605633092) | 2 | 4 | 7 | 28859 | 19 | ||
21656 | 255546 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 209 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006712 | 2104859 | 37.7599212687364 | -122.419861024185 | (37.7599212687364, -122.419861024185) | 2 | 4 | 7 | 28859 | 19 | ||||
21766 | 36029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 57 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39176 | 6008256.82211369 | 2099693.24167493 | 37.7458241717762 | -122.414152744353 | (37.7458241717762, -122.414152744353) | 2 | 7 | 7 | 28859 | 2 | ||
21984 | 105306 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4365 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2014 12:00:00 AM | 3x3 | Permit Number 771671 | 6001537.2 | 2100535.2 | 37.7477562656077 | -122.437448482105 | (37.7477562656077, -122.437448482105) | 2 | 4 | 5 | 63 | 22 | |||
22913 | 96092 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 116 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3x3 | Permit Number 56922 | 6001481 | 2086737 | 37.7098663684689 | -122.436655293893 | (37.7098663684689, -122.436655293893) | 9 | 7 | 6 | 28861 | 5 | ||
23163 | 35804 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 233 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39048 | 6006716.02273257 | 2104761.27467675 | 37.7596531643404 | -122.41984017695 | (37.7596531643404, -122.41984017695) | 2 | 4 | 7 | 28859 | 19 | ||
23830 | 34752 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 667 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2000 12:00:00 AM | Permit Number 38399 | 6007930.97034241 | 2104052.78354238 | 37.7577761801817 | -122.415588103657 | (37.7577761801817, -122.415588103657) | 2 | 4 | 7 | 28859 | 19 | ||
23886 | 37758 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52226 | 6010092.02702876 | 2101618.78120771 | 37.7512141902983 | -122.40794259966 | (37.7512141902983, -122.40794259966) | 2 | 4 | 7 | 28859 | 19 | ||
24874 | 37335 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 822 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53759 | 6003062.69037898 | 2103433.56920909 | 37.7558011125208 | -122.432380395486 | (37.7558011125208, -122.432380395486) | 2 | 4 | 5 | 28862 | 22 | |
25134 | 34329 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
25503 | 94663 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53800 | 6004614 | 2097695 | 37.7401321706185 | -122.426606846161 | (37.7401321706185, -122.426606846161) | 2 | 7 | 5 | 63 | 7 | |
25581 | 36604 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1449 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39457 | 6009591.69172547 | 2100806.68710724 | 37.748956335196 | -122.409615508849 | (37.748956335196, -122.409615508849) | 2 | 4 | 7 | 28859 | 19 | ||
25857 | 43125 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 28 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | Permit Number 42943 | 6006014.62206932 | 2098348.860336 | 37.7420066078017 | -122.421810489884 | (37.7420066078017, -122.421810489884) | 2 | 7 | 7 | 28859 | 2 | ||
25889 | 52052 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 84 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48254 | 6005362.31259493 | 2099645.76538508 | 37.7455308063117 | -122.424158182307 | (37.7455308063117, -122.424158182307) | 2 | 7 | 5 | 28859 | 22 | |||
26785 | 33029 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
26900 | 35554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 117 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38928 | 6005427.85924462 | 2103026.46196551 | 37.754817120668 | -122.424171918741 | (37.754817120668, -122.424171918741) | 2 | 4 | 5 | 28859 | 19 | ||
26942 | 37739 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | |||
27597 | 34735 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38385 | 6008060.11038004 | 2101550.08300487 | 37.7509115908716 | -122.41496434851 | (37.7509115908716, -122.41496434851) | 2 | 4 | 7 | 28859 | 19 | ||
28096 | 35326 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 239 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38793 | 6006717.55595043 | 2104727.62386215 | 37.7595608533974 | -122.41983248648 | (37.7595608533974, -122.41983248648) | 2 | 4 | 7 | 28859 | 19 | ||
28782 | 81873 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1312 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52224 | 6010043.81301103 | 2101548.7849116 | 37.7510192965024 | -122.408104393789 | (37.7510192965024, -122.408104393789) | 2 | 4 | 7 | 28859 | 19 | ||
29003 | 40334 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1359 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 3x3 | Permit Number 41465 | 6007740.61181979 | 2101748.78645974 | 37.7514392269717 | -122.416083278537 | (37.7514392269717, -122.416083278537) | 2 | 4 | 7 | 28859 | 19 | |
29366 | 36052 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | |||
29877 | 39158 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
30569 | 44068 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 304 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 43592 | 6006646.88740951 | 2098034.91768842 | 37.741180227012 | -122.419602044821 | (37.741180227012, -122.419602044821) | 2 | 7 | 7 | 28859 | 2 | ||
30844 | 36599 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1423 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39452 | 6009585.61659215 | 2100916.70354088 | 37.7492580755485 | -122.409644280871 | (37.7492580755485, -122.409644280871) | 2 | 4 | 7 | 28859 | 19 | ||
31441 | 50614 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 474 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2003 12:00:00 AM | Permit Number 47214 | 6002793.31412073 | 2098675.69251057 | 37.7427218255103 | -122.432972078444 | (37.7427218255103, -122.432972078444) | 2 | 7 | 5 | 63 | 22 | |||
31864 | 121730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 5 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
31962 | 33030 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3428 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37311 | 6006888.9310023 | 2100900.56738488 | 37.7490622873512 | -122.418968344047 | (37.7490622873512, -122.418968344047) | 2 | 4 | 7 | 28859 | 19 | ||
32241 | 59724 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 19156 | 6001209.48230507 | 2102271.53927268 | 37.7525052007973 | -122.438706110204 | (37.7525052007973, -122.438706110204) | 2 | 4 | 5 | 28862 | 22 | ||
32997 | 40317 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 999 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41459 | 6006351.75417313 | 2103777.48351974 | 37.7569313744996 | -122.421030150349 | (37.7569313744996, -122.421030150349) | 2 | 4 | 7 | 28859 | 19 | ||
34062 | 121740 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201x Vermont St | 3 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011405 | 2102539 | 37.7538143308772 | -122.403466904543 | (37.7538143308772, -122.403466904543) | 10 | 4 | 8 | 28859 | 19 | ||||
34391 | 121731 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1301 Vermont St | 6 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 6011430 | 2102074 | 37.7525389392772 | -122.403347738299 | (37.7525389392772, -122.403347738299) | 10 | 4 | 8 | 28859 | 19 | ||||
34493 | 34309 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
34711 | 44001 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
35048 | 46554 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2169 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | Permit Number 44694 | 6008148.92674441 | 2105809.63139765 | 37.7626123299985 | -122.414958662117 | (37.7626123299985, -122.414958662117) | 8 | 4 | 7 | 28859 | 19 | |||
35462 | 50281 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2890 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46985 | 6009507.79940806 | 2102799.18720578 | 37.7544225953783 | -122.410046254665 | (37.7544225953783, -122.410046254665) | 2 | 4 | 7 | 28859 | 19 | ||
35623 | 52402 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 92@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | Permit Number 48522 | 6006139.57045617 | 2097557.41563242 | 37.7398405238756 | -122.421322267329 | (37.7398405238756, -122.421322267329) | 2 | 7 | 7 | 28859 | 2 | ||
35810 | 34056 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37959 | 6009442.90556489 | 2106775.8067624 | 37.7653378532253 | -122.410551467879 | (37.7653378532253, -122.410551467879) | 8 | 4 | 7 | 28859 | 19 | ||
35946 | 68105 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 78 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31851 | 6008211.91573535 | 2099564.22145596 | 37.7454673885178 | -122.414298897694 | (37.7454673885178, -122.414298897694) | 2 | 7 | 7 | 28859 | 2 | ||
36827 | 37740 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
37084 | 71739 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1467 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 56975 | 6008043.26276721 | 2099626.05915094 | 37.7456277058322 | -122.41488645052 | (37.7456277058322, -122.41488645052) | 2 | 7 | 7 | 28859 | 2 | ||
37180 | 44003 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 2701X 17th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | 3x3 | Permit Number 775718 | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.410449858863 | (37.7642662704227, -122.410449858863) | 8 | 4 | 7 | 28859 | 19 | ||
37473 | 37697 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 590 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40081 | 6007854.26822666 | 2104498.62498081 | 37.7589960467021 | -122.41588494267 | (37.7589960467021, -122.41588494267) | 2 | 4 | 7 | 28859 | 19 | ||
39039 | 35325 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 226 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38792 | 6006662.54340548 | 2104792.55869269 | 37.7597360500369 | -122.42002735576 | (37.7597360500369, -122.42002735576) | 2 | 4 | 7 | 28859 | 19 | ||
39458 | 67919 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31630 | 6004275.26721169 | 2095614.00906402 | 37.734399085455 | -122.427629821288 | (37.734399085455, -122.427629821288) | 2 | 7 | 5 | 28861 | 25 | ||
39886 | 37737 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
40238 | 46344 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 365 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44590 | 6005506.87362767 | 2101591.77673747 | 37.7508822683578 | -122.423796657689 | (37.7508822683578, -122.423796657689) | 2 | 4 | 5 | 28859 | 19 | ||
40292 | 82604 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1306 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52223 | 6010041.95956984 | 2101582.34952093 | 37.7511113537145 | -122.408113170097 | (37.7511113537145, -122.408113170097) | 2 | 4 | 7 | 28859 | 19 | ||
40413 | 40242 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41413 | 6005060.66345882 | 2103723.48995015 | 37.7567102567185 | -122.425491387148 | (37.7567102567185, -122.425491387148) | 2 | 4 | 5 | 28859 | 19 | ||
41290 | 36062 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1401 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1998 12:00:00 AM | Permit Number 39185 | 6009421.20140012 | 2108121.84074464 | 37.7690325354797 | -122.410721604896 | (37.7690325354797, -122.410721604896) | 8 | 4 | 8 | 28853 | 19 | ||
41565 | 81287 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3145 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50544 | 6008016.04178081 | 2102664.62636249 | 37.7539693984201 | -122.415195628809 | (37.7539693984201, -122.415195628809) | 2 | 4 | 7 | 28859 | 19 | ||
42122 | 93487 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 643 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2010 12:00:00 AM | 3x3 | Permit Number 53236 | 6005997.4 | 2099554.6 | 37.745316324998 | -122.421955670553 | (37.745316324998, -122.421955670553) | 2 | 7 | 5 | 28859 | 2 | |||
42631 | 89008 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 3x3 | Permit Number 52629 | 6012436 | 2104662 | 37.7597011565358 | -122.400050528825 | (37.7597011565358, -122.400050528825) | 10 | 3 | 8 | 28856 | 29 | |||
42787 | 39159 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 69 Lapidge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40827 | 6006035.82025068 | 2105107.15671694 | 37.7605645323651 | -122.422217235752 | (37.7605645323651, -122.422217235752) | 2 | 4 | 5 | 28859 | 19 | ||
43209 | 39079 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 2280X Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | 8 | 4 | 8 | 28853 | 19 | |||
45805 | 34314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/1997 12:00:00 AM | Permit Number 38095 | 6011565.66175485 | 2101164.33215433 | 37.7500487659499 | -122.402814623369 | (37.7500487659499, -122.402814623369) | 10 | 3 | 8 | 28856 | 29 | ||||
46326 | 94953 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 763 Brannan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53984 | 6011909 | 2109793 | 37.7737603305178 | -122.402233924084 | (37.7737603305178, -122.402233924084) | 14 | 2 | 9 | 28853 | 34 | ||
46591 | 37747 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1266 Florida St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1998 12:00:00 AM | Permit Number 40095 | 6009484.78268632 | 2101799.61949938 | 37.751676715706 | -122.410055290726 | (37.751676715706, -122.410055290726) | 2 | 4 | 7 | 28859 | 19 | ||
47921 | 35543 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 110 Bartlett St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38923 | 6006656.9527086 | 2103125.85221235 | 37.7551593447884 | -122.419928417644 | (37.7551593447884, -122.419928417644) | 2 | 4 | 7 | 28859 | 19 | ||
48255 | 50560 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2003 12:00:00 AM | Permit Number 47183 | 6002030.50619515 | 2102333.72789299 | 37.7527226291178 | -122.435871324431 | (37.7527226291178, -122.435871324431) | 2 | 4 | 5 | 28862 | 22 |
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) );